Question Re: Data loading with 2 keyfigures in Financial Management Q&A

Data loading with 2 keyfigures

Former Member — Sat, 18 Jul 2015 06:41:00 GMT

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

Re: Data loading with 2 keyfigures

Ankur_Jain1m8 — Sat, 18 Jul 2015 08:04:45 GMT

Hi,

You can use MVAL keyword to map multiple key figures in a single mapping.

Let's say you have 2 different accounts A and B to which you want to load 0AMOUNT and 0BALANCE respectively then, you may use the following:

ACCOUNT = *MVAL(0AMOUNT|A||0BALANCE|B)

Regards,

Ankur Jain

Re: Data loading with 2 keyfigures

Former Member — Sat, 18 Jul 2015 08:24:09 GMT

hi ankur,,

thanks for your reply.

I need to map multiple keyfigure to signed data.

I just want to load 0AMOUNT for P&L items and 0BALANCE for Balance sheet items.

So I need mapping for SIGNEDDATA and not the account

Re: Data loading with 2 keyfigures

Former Member — Mon, 20 Jul 2015 02:50:52 GMT

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

Re: Data loading with 2 keyfigures

former_member544285 — Mon, 20 Jul 2015 05:33:34 GMT

Hi,

You can't load YTD data to periodic model. The "measure" in dimension is not an actual dimension. It's just used to show data in the report by applying some MDX formula.

If you want to load YTD data to periodic model, you will need to do some calculation from BW to calculate the periodic data before adding to BPC model. Then inside the model you can show data in YTD by using measure

Re: Data loading with 2 keyfigures

Former Member — Mon, 20 Jul 2015 11:55:56 GMT

Hi,

Use below links for data loading with 2 keyfigures.

http://scn.sap.com/docs/DOC-26973

Hope this will help you,

Regards,

Devi

Re: Data loading with 2 keyfigures

Former Member — Mon, 20 Jul 2015 12:44:28 GMT

Please read what the user is asking, your answer is totally irrelevant.

Re: Data loading with 2 keyfigures

gajendra_moond — Mon, 20 Jul 2015 17:09:43 GMT

As others suggested, it is not possible to have IF condition for SDATA.

Try creating a package link comprising of packages for P&L items and B/S items as one of the ways to load data in one load process.

Re: Data loading with 2 keyfigures

Former Member — Tue, 21 Jul 2015 03:53:47 GMT

Did you read both documents...they are relevant...how you take use of it is depends on you.

don't comment without proper info...

user is asking how to load two key figure, it's in first document and user is asking for both account type P&L and balance sheet (i.e. INC,EXP,AST and LEQ). that is in second document...

he can use both document and take use of it and prepare his solution based on his requirement.

i din't tell use the document, i just mentioned. document might help.

Re: Data loading with 2 keyfigures

Former Member — Fri, 24 Jul 2015 10:08:02 GMT

Thanks Andy,

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 by calculating in BI for the balance sheet and then show the report in YTD measure.