Error stemming from deleted cube dimension

PeterFrb
PeterFrb used Ask the Experts™
on
I am using Visual Studio 2008 Analysis Services and processing the AdventureWorks database to create and process a cube.  I was having trouble with my time-related fields (Order date, due date,  ship date), which was keeping my project from deploying.  In a fit of pique, I deleted the offending fields, intending to re-establish them later.  However, my impetuousness made the situation worse, and I still can't deploy.  I get errors of the type below:

Error      10      MdxScript(Adventure Works) (13, 8) The dimension 'xxx' was not found in the cube when the string, [xxx].[yyy].[zzz], was parsed.

I tested each dimension separately, and all successfully processed.  My best guess is that some calculated field is failing to find the field I deleted, resulting in this error.  I would appreciate any suggestions for how to ferret out this genre of error.

Thanks, ~Peter Ferber

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Data anslyst, tableau visualization developer, vb certified
Commented:
I discovered the answer myself.  The answer lies in going to the Calculations tab in the cube and getting rid of any offending calculation that turns up there.
~Petet

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial