BPC Consolidation: Consolidation monitor not updated

[LouisdeCarville]

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

[former_member186338]

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

[LouisdeCarville]

Hi Vadim,

But we wanted to avoid to create 8 temporary cubes (1 per key figure). It would be too much maintenance for the customer and it would also complicate the reconciliation between the systems ECC-BW-BPC. Business didn't want that

Louis

[former_member186338]

Sorry, but it's not the reason for doing incorrect things! You will have a lot of issues!

Not only with consolidation...

[LouisdeCarville]

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

[former_member186338]

"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)?