I’m going insane here trying to figure out this issue and was wondering if anyone had ideas as to what the cause.
If you look at the below picture, the totals are incorrect for 3/5. Tier 1 shows a total of 452, however when expanded (or drilled down into) only shows a total of 80!
For the life of me, I can’t figure it out. It’s not a Proclarity specific thing either, the same numbers are returned through Management Studio.
The data is stored in MOLAP. The issue does resolve itself eventually, though I don’t know how.