Time characteristic problem with Multi provider
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,