Data loading with 2 keyfigures
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.
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.