Skip to Content
0

BCF appends the data in Periodic Model

Jan 12, 2017 at 08:00 AM

82

avatar image

Hello Experts,

We are on BPC 10.1 NW SP14

Issue is standard BCF function appends data in periodic model if we re-run the BCF whereas it overwrites data in a YTD model. We want periodic model should behave same like YTD model where we can avoid clearing the accounts and avoid the data duplication.

REgards,

10 |10000 characters needed characters left characters exceeded

Can you explain your logic why you are using BCF???? You are working on Consolidation or Planning model?

0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Jan 19, 2017 at 02:25 PM
1

Just tested the sample from How-To: http://www.sap.com/documents/2015/08/4c19d052-557c-0010-82c7-eda71af511fa.html

Working absolutely correct!

Test model (Periodic):

ACCOUNT (OPENING_ACCOUNT property not used)

AUDITTRAIL

CATEGORY (empty properties CATEGORY_FOR_OPE, OPENING_PERIOD, OPENING_YEAR)

ENTITY
FLOW

RPTCURRENCY
TIME

Rule:

Script:

*RUN_PROGRAM COPYOPENING
CATEGORY = %CATEGORY_SET%
CURRENCY = %RPTCURRENCY_SET%
TID_RA = %TIME_SET%
*ENDRUN_PROGRAM

Report before BCF:

Result after first script run with CATEGORY=Actual, RPTCURRENCY=USD, TIME=2017.01:

Log:

LOG BEGIN TIME:2017-01-19 17:20:33
FILE:\ROOT\WEBFOLDERS\ENV1\ADMINAPP\PERIODPLAN\BCF.LGF
USER:V.KALININ
APPSET:ENV1
APPLICATION:PERIODPLAN
RUN COPY OPENING
1  SUBMITTED, 1  SUCCESS, 0  FAIL.
SCRIPT RUNNING TIME IN TOTAL:1.00 s.
LOG END TIME:2017-01-19 17:20:33
File path: \ROOT\WEBFOLDERS\ENV1\PERIODPLAN\PRIVATEPUBLICATIONS\V.KALININ\tempfiles\20170119172033\BCF.LOG

Second run with the same parameters resulted in no changes! Log:

LOG BEGIN TIME:2017-01-19 17:50:46
FILE:\ROOT\WEBFOLDERS\ENV1\ADMINAPP\PERIODPLAN\BCF.LGF
USER:V.KALININ
APPSET:ENV1
APPLICATION:PERIODPLAN
RUN COPY OPENING
0  SUBMITTED, 0  SUCCESS, 0  FAIL.
SCRIPT RUNNING TIME IN TOTAL:1.00 s.
LOG END TIME:2017-01-19 17:50:47
File path: \ROOT\WEBFOLDERS\ENV1\PERIODPLAN\PRIVATEPUBLICATIONS\V.KALININ\tempfiles\20170119175046\BCF.LOG

After I changed the value in 2016.12 to 2000 and run the script again the result was also correct:

No surprise!


cat.png (19.5 kB)
aud.png (27.9 kB)
flow.png (22.1 kB)
beforebcf.png (13.0 kB)
rule.png (15.4 kB)
after1bcf.png (13.2 kB)
after3bcf.png (12.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
SAP BPC Jan 12, 2017 at 08:11 AM
0

I am using BCF for planning where I need to carry forward certain adjustments made on BS accounts.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

I dont think...in case of re run, periodic model will overwrite!

0

no..it is not..it is adding up the values as we execute BCF.

0
Vadim Kalinin Jan 12, 2017 at 08:16 AM
0

Please provide full info: data sample before and after bcf, script used to run bcf, prompt settings for script, rule setup, etc...

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Script Used :

*RUN_PROGRAM COPYOPENING

CATEGORY = %CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY=%ENTITY_SET%] /

ENDRUN_PROGRAM

Prompts are standard :

CATEGORY : ACTUAL

TIME: JAN.2017

RPTCURRENCY : USD

ENTITY : <all>

Rule :

Source GL : GL10001 ( dummy GL) Source Audit : ELIM_MANUAL Audit Type : A and rest all are blank.

C/F Year and C/F Period properties are been maintained in category dimension.

Sample Data Before BCF :

DEC.2016 GL10001 1000

JAN.2017 GL10001 0

After 1st Run :

DEC.2016 GL10001 1000

JAN.2017 GL10001 1000

After 2nd Run :

DEC.2016 GL10001 1000

JAN.2017 GL10001 2000

After 3rd Run :

DEC.2016 GL10001 1000

JAN.2017 GL10001 3000

0
Vadim Kalinin Jan 12, 2017 at 10:22 AM
0

Please compare all your settings with this document: http://www.sap.com/documents/2015/08/4c19d052-557c-0010-82c7-eda71af511fa.html

I do not see all settings in your answers.

Show 5 Share
10 |10000 characters needed characters left characters exceeded

could you please share what other details are required ? I have configured the same config for legal model with added flows in BR, and it is working fine.

0

If you configured the same settings as in the provided document then it will work correctly.

0

I have configured as per the document and the same I have also mentioned in the post.

0

Screenshot of rule setup and properties!

0

bcf.png KFA for the business setup and properties for audittrail and category.

bcf.png (132.9 kB)
0