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.