New answers tagged ssas
We really need more detail on your measures and dimensions to give you an exact answer on this, but since you are using SSAS a few general rules apply. If you add more detail I can expand my answer to be in line with your data model. Since you want to compare the number of transactions you should have a measure showing the number of transactions. As you ...
Another option would be to use a union to get parallel periods for the current and previous member. Then extract the first item out of this, which will always be the current member (except in the case of Feb 29 where it should fall back to the previous member). That is, effectively coalesce with the previous member parallel period as per below: union ( ...
Check the server property BuiltinAdminsAreServerAdmins. Till SQL Server 2014 it defaults to true. Not sure if it will be changed in 2016 (hopefully). Link: https://msdn.microsoft.com/en-us/library/ms174561(v=sql.120).aspx
I just had to change the Employee Display NameColumn to LastName. And it worked!!! Thanks!!
I don't think you can verify an SSAS database isn't corrupt apart from querying it. If you query it and you get errors it's corrupt. If your database ends up corrupt the only sure way to recover is to restore the last known good backup, even though sometimes you can get away with messing in the .xml files or the data folder structure there is no guarantee ...
Unless you have data in your SSAS cubes that no longer exists in your source (if this is the case correct that going forward!) then you can simply install a new instance of SSAS then deploy and process your SSAS solutions from SSDT (the 2012+ replacement for BIDS). For SSRS if you have a basic install you can do the same thing - simply install the new ...
Top 50 recent answers are included