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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top