Hello All!



I have reached a problem while using this function.



Details:

I have two cubes Sales_USD (dimensions Goods, Time, Country and measure
Sale) and CurrencyRate (dimensions Currency, Time and measure Rate).

I made a calculated member Sales_UAH to get Sales in local currency as
Sum({Descendants([Time].CurrentMember, [Month])}, Sale *
ValidMeasure(Currency.UA)) and got nothing as a result!



Am I doing something wrong?


--
Posted via http://dbforums.com

I think the problem could be that you're not explicitly stating that you
want to multiply Sale * Rate - in the VALIDMEASURE function you only specify
the Currency dimension, so it would return the default measure in the
virtual cube, which would probably be Sale. Try something like:

Sum({Descendants([Time].CurrentMember, [Month])},
Validmeasure(Measures.Sale) * ValidMeasure((Measures.Rate, Currency.UA)))

HTH,

Chris

--

Chris Webb
Consultant, Microsoft Services Switzerland
(to email: remove 'online.' from the address this was posted with)

Microsoft Services Switzerland and our partners can help you with your
Analysis Services project!

Disclaimer: This posting is provided 'AS IS' with no warranties, and confers
no rights.

"Gvynt" <member37608 (AT) dbforums (DOT) com> wrote