I'm trying to figure out how to approach a calculated member with an MDX expression. Here's what I want to do.
I have some existing calculated members (measures) figure out a rate represented as percentage. The problem is that the users think about these rates at their annual level (one of the inputs to this calc is semi additive). What I need to be able to do is
scale them up to be indicative of the annual rate.
So what I have now is this
I need to scale these up as follows:
Quarter: 1.16% (0.29*4 quarters)
Month: 1.20% (0.1*12 months)
Can anyone demonstrate how to alter the multiplying factor at different levels of a time dimension?
Thanks in advance,
View Complete Post