SSAS: add deploy Perspectives


I feel that there is no good way of dealing with perspectives. I'd like to be abel to deploy them like you can do with MDX scripts.
Closed Dec 13, 2013 at 10:44 PM by furmangg
This feature is checked in and will appear in release 1.6.5:


GuyS66 wrote Feb 28, 2013 at 4:51 PM

i completely agree :) doesnt seem right to have to redeploy and reprocess just to modify a perspective.

dgosbell wrote Feb 28, 2013 at 7:39 PM

You don't have to re-process when you deploy a perspective, but you do have to re-deploy the whole cube as a perspective is considered a "minor object" within the cube, where as the MDX script is a "major object" and as such can be deployed independently. This is a restriction of the XMLA language and there is no way for BIDS Helper to alter this.

dgosbell wrote Dec 12, 2013 at 6:51 PM

The server does not support this capability therefore it is impossible for us to implement in BIDS Helper

** Closed by dgosbell 2/28/2013 11:40 AM

furmangg wrote Dec 12, 2013 at 6:51 PM

I noticed that the Perspective object is derived from MajorObject, and I tried an XMLA alter on a Perspective and it worked against AS2012. So it is worth revisiting this feature.

Looking back to AMO in AS2005, Perspective was even derived from MajorObject back then. So maybe there was a bug that was fixed sometime.