Getting Cumulative Balances from Cube 0FI_AR_3

Hello Friends,

I am getting Line Item Data of Customer in the Data Flow of Cube 0FI_AR_1 . But now i want to calculate cumulative balances for report purpose . I am not getting Data Profit Center wise in the Transaction cube 0FI_AR_1 . Now i want to calculate the Transaction Figures in Bi side from Line Item Data . For that each month i have to calculate Opening Balance and Closing Balance , Please suggest me a solution .

Regards

Nilesh vakil