MDX Help needed. Highest Time member from the selected set -
07-08-2003
, 06:41 PM
I want to write a calculated measure to achieve the below results:
My cibe has three dimensions. Product, Time and Measures
Three measures: Base, Adjs, Comp
Base and Adjs are fact table measures. Comp is a calculated member.
Suppose the user selects 2001, 2002, 2003 on either rows or columns.
Example:
2001 2002 2003
Base 10 15 20
Adjs 5 8 9
Comp 10/9 15/9 20/9
And if the user selects:
1997 2000 2002
Base 60 35 25
Adjs 8 7 8
Comp 60/8 35/8 25/8
And even if the users select Products and Measures on roes and
columns, but slice it by Time:
Base Adjs Comp
Prod1 9 5 9/5
Prod6 7 5 7/5
Slice by Time: {1999, 2001}
If you follow:
I want the CALCULATED MEMBER "Comp" to be always based on Adjs value
of Highest Year in the selections.
Can you please help? I don't know how to refer to an item from current
selection. |