Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data loading with 2 keyfigures

Dear Experts,

We are having single model which is periodic containing all the planning ( Revenue, Expense and Capex)

We need periodic values for  (Revenue, Expense) then we will be loading from 0AMOUNT key figure and while loading for Capex and all other balance sheet items we will  be loading from 0BALANCE  key figure which is cumulative keyfigure.

Can we map 2 key figures in single mapping for signed data like :

SIGNEDDATA = IF (ACCTYPE = EXP/INC)  then  0AMOUNT ELSE  0BALANCE))

Also I would like certain clarification, are we following correct approach by loading  0BALANCE  for the balance sheet accounts, or  we need to load the periodic values for the balance sheet and then show the report in YTD measure.

But there is a problem, the balance sheet items are not getting added up in the YTD measure in the periodic model and I believe this is  SAP BPC standard.

Request you to put certain clarification on the same.

Regards,

sap bpc

Former Member
Former Member replied

Hi,

You can't do IF statement on signeddata, create two transformation files and do separate loads for balance and P&L account, or use start/end routine BADI to do the check for you.

Andy

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question