Embedded or Standard Modeling in BPC 11.1 BW4HANA SP02?

[former_member258755]

Dear Experts,

I have worked with standard model BPC as well as BW on HANA for years. It's well known that BPC Embedded model and Standard model works very differently from the fundamental. However is there any document or white paper regarding the performance and data size limitation comparing these 2 (since they're all using ADSOs)? I have also heard complaints about EPM (standard modeling frontend) reporting is not achievable once the combinations of dimension has members exceed the limit. Even if you can use "remove empty row or column" or dynamic filters to limit the output. The error will show and cannot be avoided.

Please kindly help. Since my next coming project will involve a large scale implementation. I need to know which one will be suitable for it.

Many thanks and best regards,

Jim

[former_member186338]

"I have also heard complaints about EPM (standard modeling frontend) reporting is not achievable once the combinations of dimension has members exceed the limit. Even if you can use "remove empty row or column" or dynamic filters to limit the output. The error will show and cannot be avoided." - can you provide any proof of the mentioned issue? I am working with a huge retail client and have no issues with limits... For sure it's possible to create some artificial case when you may see performance issues, but in the real life I don't have problems. And about embedded - I know some clients that refused to use embedded because of AO reporting.

[Private_Member_467521]

Hi jim.ck.hsu,

The limitations are really on persistent layer of HANA, so at the end, you will be limited by the maximum number of columns on a Hana table:

In the case of ADSO In maximum number of fields/InfoObjects, the limit is1000 for a Hana 1SP12.

If you are interested in digging on this, here are some additional SAP notes I've researched on.

This explores the topic of the length of generated tables:

https://launchpad.support.sap.com/#/notes/2507857

You will falso find other line items constraints like this one journal entries limitation:

https://launchpad.support.sap.com/#/notes/2804354

BTW, and this is just my 2 cents. I would have to find a very good reason to use any version of BPC instead of SAP Analytics Cloud for Planning and S/4 Group Reporting for Consolidation.

Hope this sheds a light.

Cheers,

Luis