Problem Removing Bad Syntax Calculated Measure

X

XSLer

A person in my org recently added a custom Calculated Measure under our cube
configuration. Since he cut and pasted it, it has a parameter that doesn't
exist.

While he deleted it, it still appears to exist as now our cube won't build.
I went and did ALTER TO in the appropriate cube and the database, and got the
process successfully by removing some MDX stuff, however when the build
happens in PWA, this apparntly is overridden from somewhere.

So, my question is, how can I get rid of this calculated measure across the
board. It no longer appears in the UI, so can't do it there.
 
G

Gary L. Chefetz

If this was added to the cube configuration the correct way, you need to
remove it by going to Server Settings > Cube Configuration. In the
Calculated Members section, select each cube in the pick list until you find
the offending member and delete it. Going forward always test your MDX
expressions using a local custom field in a view rather than adding them to
your cube configuration directly. After verifying that it works and doesn't
crash the view, you can safely add it to your cube configuration.
 
Top