Hi, all experts here,
As we are enabled to deploy the calculation MDX scripts by installing BIDS Helper. But why there is no options for us to decide where the MDX scripts will be deployed to? And where can I find those deployed MDX scripts? Thanks a lot in advance and I am confused and I am looking forward to hearing from you shortly for your help. (Assume I am right, to my understanding, with capability to deploy the calculated MDX scripts we are then able to reuse them?)
With best regards,
Yours sincerely,
Helen999888 wrote:
But why there is no options for us to decide where the MDX scripts will be deployed to?
Because It is deployed to the server and database that is specified in the deployment settings of your project. Which should be the same server that the cube was deployed to in the first place.
And where can I find those deployed MDX scripts?
The MDX script is the calculation script that you find in the calculations tab of the cube designer. The deploy calculations feature pushes changes from your client machine up onto the server.
(Assume I am right, to my understanding, with capability to deploy the calculated MDX scripts we are then able to reuse them?)
No, the MDX calculations are not persisted anywhere, the xmla alter commands are sent directly to the target server specified in the deployment settings for your project. The xmla command is targeted at a specific DatabaseID and CubeID and usually the calculations would be fairly specific to the structure of the cube.
The main advantage to using the deploy MDX script feature is that it is very quick if you know that all you have done is to make a change to the MDX script.
|||Hi, Darren,
Thanks very much for your kind advices.
As you advised, all the point of using this feature is to quickly deploy changes of calculations to the analysis services database for the specific cube? Thanks a lot.
With best regards,
Yours sincerely,
