Default Formula Package Run Nullifies Existing Data Records

[former_member212236]

Hello All,

Could you please provide some insights on the below issue.

BPC Version - 10.1
BPC Cons Model - Management IFRS

Issue:

Whenever the Def. Formula package is manually executed after a data copy or posting, the already posted values gets nullified due to the new record that comes in with a positive value brought as a part of def.formula package run.

Questions:
Why is data flowing when Def. Formula package is executed?
How to avoid the existing records getting nullified?

Example:

1. There is a record with under Category ACTUAL posted for 2019.P02

2. The user copies this record using the copy function. From ACTUAL To ACTUAL-BUD2019 for Period 2019.P02

3. At this moment, when I check the t-code listcube at the backend, I am able to see that the values for both ACTUAL and ACT-BUD2019 for Period 2019.P02 have been posted without any issues.

4. Now, when I execute a Default Formula package, I have two new records (refer highlighted in Orange in the screenshot above) with +ve value on the measure. This nullifies the total.

The Default Formula package calls the ALL_CALC.LGF script that has code for both currency conversion and Eliminations.

Def. Formula Logs:

ALL_CALC.LGF script:

Process Chain Structure:

Reference Links:

https://help.sap.com/saphelp_bpc75/helpdata/en/12/6c1166f25b4f198032c74f7d628607/content.htm?no_cach...

https://answers.sap.com/questions/9707671/run-defaultlgf-after-package-execution.html#

Regards,

Vinoth V

[former_member186338]

It's better to post script text using CODE button, instead of screenshot!

And for BPC and BW it's required to show both version and SP....

[former_member186338]

P.S. Incorrect tag used!

Not: SAP Business Planning and Consolidation, version for the Microsoft platform

But: SAP Business Planning and Consolidation, version for SAP NetWeaver

I have alerted moderator to change tag!

[former_member186338]

"During the FX conversion, as per the log the currency conversion step submits records.
Is this not normal?" - for sure it's normal!

You have to analyze your currency conversion rule to understand the logic of record generation!

[former_member186338]

"But, one question is that, we do have a nightly load that pulls ACTUAL data into the Cons. models in BPC. As a part of the chain, the Default Formula package also gets executed on a daily basis overnight." - please provide details how it's triggered?

Do you use package link or... during overnight data load?

[former_member186338]

Please answer this question!

[former_member212236]

Hi Vadim,

Thank You for highlighting the incorrect tag.

We do use a package link with two tasks in it for the nightly load. One for Actual data pull from BW std. cube and another task is Default Formulas.

Regards,

Vinoth V

[former_member186338]

vinoth.v

Hope that "Default Formulas" package in this package link is the same as you run manually!

By the way "Default Formulas" is a bad name for the Data manager package. "Default Formulas" is just a chain name used to launch any script logic file. Better to name package like: "FX and Interco Elim"

[former_member186338]

Comment US_ELIM in the script to understand the effect of elimination.

[former_member212236]

Hello Vadim,

Thank You so much for your input. Sure, I will try doing that to see how the system responds.

But, one question is that, we do have a nightly load that pulls ACTUAL data into the Cons. models in BPC. As a part of the chain, the Default Formula package also gets executed on a daily basis overnight.

I do not remember any instance where the user came back saying that they do not find data that was posted by them yesterday. I am not sure what is that thing that happens when Default Formula Package is ran manually and not when executed automatically daily.

One other thing to note is that during nightly load we just load the data into the BPC and not a copy of data. Is it possible for a Default Formula package to behave different when ran after data loading and after data copy?

Regards,

Vinoth V

[former_member212236]

Hi Vadim,

Here is the script text. We are BW version 7.5 SPS 0008 and EPM 10.0 SP 26 Patch 3 , Build 9630

////////////////////////////////////////////////////////////////////////////////////
//DESCRIPTION: This script is used to perform currency
translation and intercompany
//            
eliminations simultaneously.
////////////////////////////////////////////////////////////////////////////////////

*SELECT(%REPORTING_CURRENCIES%, [ID], RPTCURRENCY,
[REPORTING] = 'Y')
*FOR %CAT% = %CATEGORY_SET%

//*INCLUDE FXTRANS.LGF

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CAT%
TID_RA = %TIME_SET%
CURRENCY = %REPORTING_CURRENCIES%
RATEENTITY = Global
INCREMENTAL_MODE = X
//OTHER = [M_ENTITY = %M_ENTITY_SET%]
*ENDRUN_PROGRAM
*COMMIT

//*INCLUDE ICELIM.LGF

*RUN_PROGRAM US_ELIM
CATEGORY = %CAT%
CURRENCY = %REPORTING_CURRENCIES%
TID_RA = %TIME_SET%
//OTHER = [M_ENTITY = %M_ENTITY_SET%]
*ENDRUN_PROGRAM
*COMMIT
*NEXT

[former_member186338]

vinoth.v

*COMMIT

this statement is absolutely useless in this script!

[former_member212236]

Hello Vadim,

I had tried commenting the lines related to Elimination from the script and ran the default formula package. But, still the execution of Def. Formula package had brought in two new records that lead to the nullification of data.

[former_member186338]

vinoth.v

DM package log, please!

[former_member212236]

^{Hello Vadim,}

^{Sorry for the delay in response.}

^{Please find attached the screenshot of the DM package log.}

I suspect that the data is being brought into the cube with additional posting leading to the nullification of values when we perform a copy followed by Def. Form package run. But, I am not sure how this can happen as our LGF for FX trans is a standard script.

[former_member186338]

vinoth.v

You have number of records created during FX conversion. Can be your nullification!

[former_member212236]

You are Correct Vadim. During the FX conversion, as per the log the currency conversion step submits records.

Is this not normal? Kindly advise.