Time characteristic problem with Multi provider

[Former Member]

Dear all,

I have created a query (multiprovider) which contains 0figl_c01, ofiar_c02 and 0sd_c03. I have to generate a report in monthly wise. 0figl_c01 and 0fiar_co2 contains timecharacteristic 0fiscal year/period, 0sd_c03 contains calender year/month. So that when I use either of these time characteristic it is showing the values of corresponding cube only i.e. if i use 0fiscalyear/period it is showing values of 0figl_c01 and ofiar_c02 but not osd_c03.

Can you tell me how to get the values of these 3 cubes in monthly wise.

Waiting for ur reply.

Thanks and Regards,

Girikumar.S

[Former Member]

Hi,

It is common problem with Multiprovider. We can solve to some extent by restrictino key figure concept( FI key figures are restricted with FISCAL period (user entry Variable), and other SD Key figures will be restricted with 0CALmonth(user exit variable).

With rgds,

Anil Kumar Sharma .P