Cube Measures

[spicysudhi]

hi

my requirement is like this.

The table contains the country code, currency, value and exchange rate. When the user looks at the local country i want to see the value in local currency and at global level at USD using the exchange rate.

sample data

Country Value Currency Exch rate
US 10 USD 1
UK 20 GBP 1.5
FR 10 EUR 0.5


expected output like this

US 10
UK 20
FR 10
Country 35

Country row is 35 (= 10 + 20*1.5 + 10*0.5) and not 40

how to get this?

regards,
sudhi

 

[BruceReed]

Are you using the exchange rate utility in transformer and PP? This would take a little bit of time to set up, but it is the best bet (I believe it needs pp 6.6 & higher)for you if you're setting up a cube for long term use.

Your way should be 45 & you're getting 40 indicates you are using straight addition in the PP report. Did you try switching the calculation order? See the on line help under Calculation Precedence. This might help you.

Post back if you have detailed questions.

Good luck
Bruce