Wednesday, July 15, 2009

Updating SSAS Cube Perspective

An SSAS cube Perspective is a close cousin of our View(From Database engine) except that it cannot be looked at from the security stand point(which a traditional DB view provides). It should be used to simplify the overwhelming amount of information provided to a user(not all users need to see everything from the Warehouse).A Perspective hides\shows information like attributes\measures\calculations\KPI's.. of a cube. Thus creating a scenario where a user might request more and more information from a Warehouse as time , which is hidden based upon in functional role in his company.

Changing a Perspective should not force you to Reprocess the Cube. As this is just a pair of glassed sitting on top of the actual cube limmiting what we see. A perspective can be changed in two ways.
(1) Changing Online
Open Visual Studio and then File-->Open-->Analysis Services Database. Enter the credentials to connect to the SSAS Server, this will open up the cube on the server. Go to the Perspectives tab in the Cube Designer, add\remove attributes\measures... and then click the SAVE button on the left hand top corner. That's it .... we are done. :)
The disadvantage of this is our solution file (probably the one checked into source safe) gets out of sync. Which i hope we don't want to happen.

(2)Updating the Visual Studio Solution
Open you solution and make sure you update you Perspective as described above and then SAVE the solution. Once done got o properties of the solution and make sure when you deploy you do not process the cube. This way only changes to metadata are passed on to the server. Then right click on the solution and then say DEPLOY and you are done!