Reporting on 0FIAR_C03

[Former Member]

Hi All,

I have a reporting requirement in which i want to get a result to display the Opening Balance and Closing Balance for the given time interval on POSTING DATE for 0FIAR_C03 Cube.

Here the Opening Balance should the date before the given FROM date...

(ex: If FROM Date is 01.09.2008,then 31.08.2008 will be the Opening Balance)

and TO date is the Closing Balance...

Can you please tell me the procedure to solve this issue.

thanks in advance

ASK

[Former Member]

Hi,

We had a similar requirement and we had used the field POSTING PERIOD, though not for showing opening and closing balances.

What can be done is that you can create a variable on Posting Period, which is an Interval Variable. So, the user has to enter an interval and the result is shown only for that particular interval.

Hope this would solve your problem.