Skip to Content
0
Former Member
Nov 02, 2005 at 03:55 PM

Query Design Problem

27 Views

Hello All,

I have a cube which has local currency and group currency key figures. But this data is in YTD (Year to Date) format.

Now in the query, I need to display monthly data. Now the issue here is caused by the different exchange rates for different months.

Could anyone help me understand and build a logic where I can convert the YTD data to monthly and with proper exchange rate conversion.

Would building a multicube with the cube and the exchange rate infoobject make more sense?

Looking for your inputs.

Thanks,

BWUser.