eo
MIS
- Apr 3, 2003
- 809
Hi
I have a exchange rate in the source sql table. An example of the data is...
...I need to multiply the measure with the rate in a cube and wwould like to use MDX for it. But I think the Aggregate Funcion property must be set to none, as aggregation of the various rate types makes no sense, it is therefore not a simple calculated measure whereby a aggrgated total value of all the measures are multipled by an aggregated totl value of the rates. What I need to do is apply the measure x rate calculation at the granular level, and that result can then be aggregated. I am sure this is possible in MDX but how??
EO
Hertfordshire, England
I have a exchange rate in the source sql table. An example of the data is...
Code:
Year Curr Measure Rate
2001 GBP 100.00 1
2001 ZAR 2200.00 12.12
2001 USD 5000.00 1.85
2002 AUD 1600.00 2.12
2002 USD 400.00 1.86...I need to multiply the measure with the rate in a cube and wwould like to use MDX for it. But I think the Aggregate Funcion property must be set to none, as aggregation of the various rate types makes no sense, it is therefore not a simple calculated measure whereby a aggrgated total value of all the measures are multipled by an aggregated totl value of the rates. What I need to do is apply the measure x rate calculation at the granular level, and that result can then be aggregated. I am sure this is possible in MDX but how??
EO
Hertfordshire, England