Removing a duplicate field in cube - 2007 Server

D

DogLBer

using 2007 with latest CUs, SQL 2005. I added Availiability MDX code to
MSP_Portfolio_Analyzer cube. I built the cube which gave erronous results due
to a typo error in it. I deleted the code and rentered the formula. This time
it ran successfully. But now I have two Availability field showing in the DA
View drop down list and the delete command is greyed out. Rebuilding the cube
has not deleted the field and I only have one Name and formula showing in the
Calculated Measures view. I find a lot of instructions on adding to the cube
but not much on correcting the cube. How can I delete the extra field?
 
B

Ben Howard

I would do the simple thing of specifying a new AS database name. You'll
need to redefine each DataAnalysis view to use the new AS DB name, but this
should be more than a 10 mins work (assuming 20 views a 30 seconds each!)
 

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