Skip to Content
Former Member
Jul 27, 2009 at 09:08 PM

ODS vs Cube Average Balance Scenario


Hi experts,

This is the scenario, Im going to extract the table FAGLFLEXA from R3 to obtain the daily movements of FI accounts, I have all that data on a ODS with the same fields, then I need to calculate the daily Balance and the Average Balance (Daily Balance / Day of month).

Im planning to have a InfoCube for reporting with dimensions(0Calday, 0Gl_Account, Segmentg...) and ratio (0Debit, 0Credit, 0Balance, ZAvgBalance).

Is it possible to create an ABAP routine to calculate the daily Balance and AvgBalance and insert that information on the InfoCube? or is only posible using ODs?

Thanks in advance.