Hi,

I have a cube and have created a lookup cube to get currency rate. I
have a calculated member that does a lookup from the main cube to get
the rate from currency cube based on currency selected and year
selection. This works fine.

I also have a currency dimension (USD,GBP,EUR) where GBP is the native
currency to be reported in the main cube.

What I want to do is :-

1) As the reporting currency is GBP, I need to create a calculated
member that sums the USD,GBP,EUR after applying the conversion rate to
GBP.

This is my attempt in solving point 1 but does not work as i get
strange results (not correct)

Sum({[scc].&[USD],[SCC].&[GBP],[SCC].&[EUR]},[Measures].[ConvPimRate])

I also want this calculation to be in parent dimension SCC.

ConvPimrate is the rate retreived from the lookup cube.
Any help appreciated.
Thanks

Something like:

'Sum({[SCC].&[USD],[SCC].&[GBP],[SCC].&[EUR]},
[Measures].[ConvPimRate] *
[Measures].CurrentMember)'

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!