Question on where the MDX is deployed to by BIDS Helper

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.

Helen999888 wrote:

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.

Helen999888 wrote:

(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,

Question on cube and dimension deployment in production

Hi, all experts here,

Would any of you here shed me any light on how could we deploy cubes and dimensions to other server rather than the one where they are created? And also what permissions at least are needed to be set up for them to be accessed in production enviornment?

Hope it is clear for your help.

Thanks a lot and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hi Helen,

Take a look at the functionality of the Deployment Wizard: http://msdn2.microsoft.com/en-us/library/ms176121.aspx

Regarding permissions, do you mean administrative access or the ability to query data? In either case BOL is again the best place to start: http://msdn2.microsoft.com/en-us/library/ms174517.aspx. Or do you mean the ability just to connect to the cube at all? In which case this new paper on connectivity problems might help - it discusses everything might might stop you from connecting:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

Regards,

Chris

|||

Hi, Chris,

Thanks a lot for your very kind help. Definitely they've been very helpful to clear up my confusions and questions on that.

Yes, I am concerning about being able to access the cubes and dimensions after they are deployed to other production environment.

Thanks a lot again.

With best regards,

Yours sincerely,