Skip to Content
avatar image
Former Member

BPC Consolidation: Consolidation monitor not updated

Hi Experts,

We have implemented BPC Consolidation for my current customer.

As we need multiple key figures for a specific interface (HFM), we created multiple flow and each flow represent a key figure:

  • F00 = Openning Balance
  • F01 = Credit
  • F02 = Debit
  • F99 = Closing Balance

Due to the duplication of load, we were not able to use the delta function in BPC in order to load our balances.

That's why we created in BW transformations and DTP in order to load via delta the balances for the 4 key figures.

It's working very well but I am facing an issue on the Consolidation monitor.

If for example we have the following business case:

  1. First all the company codes in the monitor have the status "To be Executed"
  2. Then we execute the Consolidation
  3. All the company codes in the monitor have the status "Done"
  4. Then we have a new posting in SAP ECC and it's going through our BPC model
  5. The status in the monitor are still in "Done" instead of "To be Executed"

Have you already faced the same kind of issue?

Thanks a lot for your help

Louis

PS: the version of BPC is Standard 10.1 and BW 7.4 SP13

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 14, 2017 at 08:06 PM

    "As we need multiple key figures for a specific interface (HFM), we created multiple flow and each flow represent a key figure:"

    Strange... I have used BPC -> HFM loading but never used Debit/Credit postings. What for? How do you transfer data?

    "That's why we created in BW transformations and DTP in order to load via delta the balances for the 4 key figures." - can you provide more details (steps)?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14, 2017 at 08:40 PM

    Hi Vadim,

    Thanks a lot for your quick answer.

    It's also the first time for me too that I face this requirement. We are not the owner of the HFM landscape unfortunetly. The US head office that own the HFM reporting asked us to provide for each GL Account/entity the openning balance, the YTD Debit, the YTD Credit and the YTD Closing Balance. In addition of that, they needed 2 group currencies: CAD and USD. So in total, it's in fact 8 Key figures that we are exctracting from our source cube in BW

    I tried to use the delta load functionality in EPM but it was not working as I needed to create 8 delta and the system lock you when you create the 2nd one as it tells you you will duplicate the data in the BPC model:

    In term of BW, we created 8 transformations (Via Rules Group) between our Source Cube and our BPC Model:

    We also created a DTP for the Delta load

    Am I answering to your questions?

    Thanks a lot

    Louis

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14, 2017 at 10:52 PM

    You are using DTP to directly load data to BPC cubes??? Bad and unsupported idea! Use some temporary BW cube...

    Add comment
    10|10000 characters needed characters exceeded