Skip to Content

Run business rules in embedded model from consolidation monitor

Hello gurus,

We are on BPC 10.1 sp11 and I am moving our Balance Sheet functionality from the standard model to the embedded model. I have created a Consolidation Model to use business rules to calculate Net Income etc even though we do not do Consolidations or translation in BPC. I have tried creating a task sequence to be able to run the BR from the Consolidation Monitor but am stuck. I see 2 issues -

1. Task Sequence does not let me select a BR, just the type of Business Rules like Account Based Business Rule. How can I select individual rules to be run from the monitor?

2. No company codes show up in the consolidation Monitor. I do not have my company codes grouped to the group dimension. So, my Scope dimension (type Group) is basically a dummy. Is it mandatory to have the entity assigned to the Group dimension to be be able to run the rules?

Any help is greatly appreciated...


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 16, 2017 at 07:39 AM

    Hi if you do not want to run consolidation why are you setting up a consolidation model?

    Answering your questions:

    1- You can specify the Account Transformation ID in the Task Sequence by using the key word CALC_ID="business rule ID" in the setting column

    You might need go through s-note 2385198, 2437140 and 2479249

    2- Yes to use the consolidation monitor you do need a valid ownership structure - even if you have only one dummy group with all entities assigned.



    Add comment
    10|10000 characters needed characters exceeded

  • Jul 10, 2017 at 06:03 PM

    Hello Lucas,

    Thank you for your answer. I have just come back from my vacation and saw your reply. I am using a consolidation model because I want to use business rules for calculating Net Income, generating Cash Flow statement etc. The only other way that I know is to use Planning Function if I don't make it a consolidation model.

    I tried adding the rule with the CALCID="<rule>" statement in the settings column. However, I am getting an error saying my <rule> is not valid while it exists.


    Add comment
    10|10000 characters needed characters exceeded