StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I don't know whether this is the root cause but i recreated same error every time i process the cube. </p> <p>Let me begin the story, I was working on optimization of cubes as our reports where running slow. I found out that there is a Customer dimension which is actually larger than fact "<strong>Depreciated Dimension</strong>", so i created new customer dimension "<strong>customer1</strong>" which has customers equal to fact. So that way, i <strong>resolved</strong> my <strong>optimization</strong>. Then there were 4 more cubes for which i have to create whole new customer dimension specific to those cubes. So i created second customer dimension "<strong>customer2</strong>" for another cube, thought of processing it first and boom, i got this error "<strong>metadata manager error: \somelocation...\\customer1.dim.0.xml error</strong>". I very carefully read that error message and i thought, why its throwing error for the dimension "<strong>customer1</strong>" when i am trying to process dimension "<strong>customer2</strong>". then processed dimension "<strong>customer1</strong>" and it got processed. Then i processed my second dimension "<strong>customer2</strong>" and it got processed.</p> <p>I was delighted but also pissed and confused, that how come this are interrelated or from which MS SSAS document says that u have to follow sequence for processing. So to test this i created 1 more dimension "<strong>customer3</strong>" then repeated same steps above. try to process first this dimension, got error , then processed the first dimension "<strong>customer1</strong>", then processed dimension "<strong>customer3</strong>" and again i got error but for dimension "<strong>customer2</strong>" then i processed dimension "<strong>customer2</strong>" then "<strong>customer3</strong>" all processed successfully. and now every time i have <strong>to process</strong>, i have to <strong>follow sequences</strong>. hope this helps..</p> <p>Regards,</p> <p>Avi</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload