I'm new to MDX and I can't figure out how to create a working calculated member.
Here's business background:
There are 2 measures in the cube - a and b.
The formula for Total Revenue is
a - b - $1000 ( don't ask me why =), 1000 is being subtracted from each day's Total Revenue - a ball park adjustment for something)
My calculated member [Measures]. [Total Revenue] looks like this
When IsEmpty([Measures].[a]- [Measures].[b])
Else [Measures].[a]- [Measures].[b]-1000
Unfortunately this calculated member doesn't work correctly, it subtracts $1000 from everywhere and not from the intersection of [Dim Calendar].[HierarchyTime].[Day] and Total Revenue.
How do I make it work in accordance with business logic? The objective is to adjust Total Revenue by subtracting $1000 for each day.
Thanks in advance!
View Complete Post