YTD conversion stopped working

[Former Member]

Hi All,

We are transferring periodic measure from one BPC 10 model to another as YTD.

This somehow seems to have stopped working. Now the destination app only gets the records transferred and not the YTD roll-over to rest of the year.

Script looks as below.

*XDIM_MEMBERSET DATATYPE = ACTUAL

*XDIM_MEMBERSET MEASURES = YTD

*XDIM_MEMBERSET ACCOUNT = BAS(PL) // P&L Accounts

*DESTINATION_APP = CONSOL

*WHEN ACCOUNT.ACCTYPE

*IS "INC", "EXP"

*REC(FACTOR = 1)

*ENDWHEN

If I load 1 record as periodic CONSOL model should get 12 records as YTD. Only 1 record for period 1 gets reflected in Consol now.

This was working till last month but stopped working now. The Script hasn't changed since long.

Its BPC 10.0 SP 12 NW

Any advise how to trace it down?         

Thanks,

Pratap

[former_member186338 · Accepted solution]

Hi Pratap,

Full script, please! How you select time periods to transfer, etc...

Vadim

[Former Member · Accepted solution]

Hi Vadim,

There is no selection on TIME.

This is default logic so any data loaded on any time period should be transferred to CONSOL.

-Pratap

[former_member186338 · Accepted solution]

Ups, I can't believe that you have this script as default.lgf For any single data change you are transferring ALL P&L accounts...

Can you explain the goal you want to achieve?

[Former Member · Accepted solution]

Thanks, you pointed out something interesting

We use this model as interim data model to get period data and default logic should transfer data to consolidation model.

[former_member186338 · Accepted solution]

"model as interim data" - can you explain the full process:

How do you upload data (some periods, full year...)

Do you perform any manual changes before transfer to ytd

...

[former_member186338 · Accepted solution]

How you trigger default.lgf?

[Former Member · Accepted solution]

We upload data as CSV file using abap program.

[former_member186338 · Accepted solution]

Once again, please explain the process in DETAILS!

How often you upload data?

What is the time scope of uploaded data?

Do you sometimes reload data for previous periods?

[Former Member · Accepted solution]

Its a monthly manual data load.

Some of the divisions which are not on sap load flat files (periodic) every month.

I haven't seen anyone loading previous periods.

[former_member186338 · Accepted solution]

If you never load data for already loaded periods then the script like you have will work: one month at a time or number of last months. If you try to load January having already loaded JAN-APR then the results will be incorrect.

This script is generating the uploaded month (months) YTD values and transfer the result to the same month in YTD cube.

"If I load 1 record as periodic CONSOL model should get 12 records as YTD." - absolutely incorrect idea!

[former_member186338 · Accepted solution]

P.S. Do you trigger default.lgf in the Data Load from flat file DM package?

[former_member186338 · Accepted solution]

By the way, to make script more universal (to calculate properly in case of multiple periods within one year) look on this (using property TIMEID):

*SELECT(%YS%,[YEAR],TIME,ID=%TIME_SET%)

*SELECT(%TY%,[ID],TIME,YEAR=%YS% AND PERIOD=JAN)

*SELECT(%Y%,[YEAR],TIME,ID=%TY%) //Single Year in %Y%

*SELECT(%TIDS%,[TIMEID],TIME,ID=%TIME_SET%)

*SELECT(%TIDPREVINCL%,[TIMEID],TIME,TIMEID<=%TIDS% AND YEAR=%Y% AND CALC=N)

*SELECT(%TNEXTINCL%,[ID],TIME,TIMEID>=%TIDPREVINCL% AND YEAR=%Y% AND CALC=N)

*XDIM_MEMBERSET TIME = %TNEXTINCL% //periods starting from the earliest till the end of the year

*XDIM_MEMBERSET MEASURES=YTD

*DESTINATION_APP = CONSOL

*WHEN DATATYPE

*IS ACTUAL //only in case of ACTUAL data

*WHEN ACCOUNT.ACCTYPE

*IS INC,EXP //P&L accounts

*REC(FACTOR = 1)

*ENDWHEN

*ENDWHEN

Example:

Data uploaded for 2016.02, 2016.04, 2016.05

%TNEXTINCL% will be 2016.02,2016.03,2016.04,2016.05,2016.06,2016.07,2016.08,2016.09,2016.10,2016.11,2016.12

Correct YTD values for all this months will be recalculated

2016.01 YTD will be unchanged.

Vadim