Link to home
Start Free TrialLog in
Avatar of PeterFrb
PeterFrbFlag for United States of America

asked on

Error stemming from deleted cube dimension

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

ASKER CERTIFIED SOLUTION
Avatar of PeterFrb
PeterFrb
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial