I am new to MDX/SSAS and have a problem with setting up two calculations. I have spent several days researching, endless rewriting of MDX queries, and did not find an answer
(or didn’t recognize the post as an answer to my problem :)
I need help with two calculations.
One, a calculation, let’s call it
[Dollar Variance], that computes variance at all levels by this formula:
([Actual Work Billings] - [Budgeted Work Billings]) / [Work Days in Month] = [Dollar Variance]
The problem is that while the [Actual Work Billings] and the [Budgeted Work Billings] are summed at the particular dimension intersects chosen, for the variance to be calculated
View Complete Post