BPC 10.0 SP20 : Carry-forward to the whole next year

[Former Member]

Hi BPC experts,

I have a question about Carry forward (in a YTD consolidation model) :

When I run the concerned package, I have the copy of previous year last fiscal period (let's say in this case 2014.12) in the next first fiscal period (2015.01).

Is it possible to copy these data to all the periods of 2015 through a logic script ? If yes, what would be the logic script ?

In other words, when running the carry forward, I would like to have 2014.12 data from 2015.01, 2015.02... to 2015.12.

Thank you in advance,

Dat

[achim_linker · Accepted solution]

The Standard implementation allows the selection of more then one Destination period.

The Carry Forward is implemented in a script logic file called COPY_OPENING.LGF.

It  Looks like:

*RUN PROGRAM COPYOPENING

     CATEGORY = %CATEGORY_SET%

    TID_RA = %TIME_SET%

     OTHER = [ENTITY = %ENTITY_SET%]

*ENDRUN_PROGRAM

Select all base peroids in the year in Data Manager package.

Kind regards,

Achim

[Former Member · Accepted solution]

Hi Achim,

Thank you for answering.

I am indeed using the standard logic script called COPY_OPENING :

*RUN_PROGRAM COPYOPENING

CATEGORY = %CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

ENTITY = %ENTITY_SET%

*ENDRUN_PROGRAM

But choosing all the required destination period in the prompt does not copy to all the periods. Below are 2 pictures of Carry Forward I did yesterday for only 2015.01 :

Today, I deleted all the carry forward data and proceeded with all the destination period :

The number of records are the same. The report only shows data for the 1st period.

[former_member186338 · Accepted solution]

Please show your Carry Forward rule setup!

[Former Member · Accepted solution]

Here is the business rule :

Dat

[former_member186338 · Accepted solution]

Then check other required settings for copy opening (dimension properties OPENING_PERIOD, OPENING_YEAR, etc...)

Please read:

Then test single period (not the first)

Vadim

[former_member186338 · Accepted solution]

By the way (from the link provided):

"Only one TIME period and only one CATEGORY value can be selected for processing, multiple selections will result in only the first selection being processed."

[former_member186338 · Accepted solution]

"The Standard implementation allows the selection of more then one Destination period" - not sure, in the How-to Guide it's stated that only one Time period will be processed.

Vadim

[Former Member · Accepted solution]

I read your link.

I tried to use the carry forward for only 2015.12. It works but only if we choose one period at a time.

However, by adding

*FOR %TIM% = %TIME_SET%

*NEXT

and changing

TID_RA=%TIM%

the Carry forward is done for all the selected periods in the prompt.

Thank you Vadim !

[former_member186338]

What is the business idea?

Vadim

[Former Member]

Hi Vadim,

The main idea is to have the same view than the transaction S_ALR_87012284 in ECC.

The model is in YTD so shouldn't the BCF transfer the data to the whole next fiscal year periods ?

Dat