Hi Matt,
A few years ago you posted this solution below. I can't seem to figure out how to solve my issue of conflicting dimensions. I've pinpointed where the conflict is, but don't know how to solve it.
RE: Management Reporter - Double Totals rolling up (Dimension Conflict)
After you said that some were working without the tree and others were missing, that made me look back at the tree and notice you are crossing databases which means you DO actually need the tree. Can you do a /Save as/ of the tree and only keep one line per database with nothing in the dimensions and see how that comes out?
Here is a snapshot of the tree:
And here is a snapshot of the Row Definition:
The results duplicate the values everywhere in the tree where I have cost center 9910.
Any help would be much appreciated.
Regards,
Andy
Categories:
1