Friday, March 23, 2012

Saving changes in MDX

Hi,

I have written a report in Reporting Services 2005 which gets its data from a cube.

I want to edit the mdx generated by the Mdx builder in RS 2005, so I click on the "design mode" button to do this.

However, when i make the changes, i cannot save it. How can I do this?

Thanks,

Ashleys.

The only time it seems that you can't save the mdx changes are when they are not syntactically correct. Paste the same query into management studio and see if it runs w/o errors (and if you have @.parameters in the query, use actual valuse for them instead).

sql

No comments:

Post a Comment