Hey Steve

Thanks for getting back. What I am trying to see is this. I pull up the AD hierarchy where Joe is and I see only one entry of Joe...

So Martin/Alvin

After our discussion last week, I went back to have a look at my data model and found the problem - thanks for Martin's suspicion of missing dimension keys....

Martin

Again always helpful - ill check it out and get back. Thanks again for all the help.

This is the xml I have scheduled to run daily for my Cube refresh.

You dont think it has anything to do with the "writebacktablecreation" option right.

Your suggestion on the...

Thanks Martin

Alvin also suggested I check the processing steps of the Cube. Not sure why only this one dimension will be affected out of the others during processing but ill...

Interesting and weird is an understatement. Not sure how much help the MDX gives but I got this from Profiler when i ran a Refresh on the sheet. I'm not...

Thanks Alvin

Not sure Im tracking your response. All the steps do execute when the cube...

Interestingly enough, this was one the questions I was asked during the demo of this cube.

Still have a few enhancement changes to make with "Can you add this or can...

Martin

This definitely helps. So I guess I need to be setting permissions to None to stop all drilling into the details.

I've read some articles on being able to configure...

I was able to solve my problem. SSRS does not allow aggregations on child scopes as those scopes are essentially not the current or containing scope.

I now know that...

Hey Steve

Thank you so much for pointing me in the right direction. It helps when you have the correct search term to look for.

Used the link below in my...

First off Steve

Thanks for the quick response. "Closing balance" is defnitely the term I have been looking for and for the life of me couldnt put these words together. My...