Skip to Content
0

Alternate Hierarchies Limitation

Dec 21, 2016 at 03:14 AM

102

avatar image

We have a requirement to accommodate 50 to 60 alternate hierarchies on EPM 10.1 Standard with BW on HANA system within a dimension.

1. Do we have any limitation on the number alternate hierarchies?

2. We expect 400 to 500 dimension members at base level which will be used with these hierarchies. Is this count acceptable to not cause any performance issues?

3. Does anyone has project experience and if there are any learning that can be shared would be of great help.

4. Is there any advantage of having BW on HANA assuming it will be BW OLAP engine handling the hierarchy rollup than anything on HANA DB.

Thank You!

10 |10000 characters needed characters left characters exceeded

Can you explain the business case? 50 hierarchies looks strange...

P.S. Primary tag is incorrect, please change! Has to be:

SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Priyanka Jagtap Dec 21, 2016 at 06:56 AM
0

Hi Abhishek,

Yes there are limitations to the no.of hierarchies in a dimension. Currently it is approx ~100 hierarchies in one dimension as per this note

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

But I agree with Vadim......50 to 60 hierarchies is strange and complex.....Please try to workaround with it with proper solution.

Regards,

JP

Share
10 |10000 characters needed characters left characters exceeded
Abhishek Mandlik Dec 22, 2016 at 06:01 PM
0

Hi JP,

The document at the link has details on BPC Unified and i assume the 100 alternate hierarchies limit is for Unified.

Does this hold true for BPC Classic as well? EPM 10.1 Standard on NW?

Also, is there any advantage of having HANA DB over non HANA DB for alternate hierarchies. Assuming, there is no difference as Hierarchy will be more of BW OLAP based rollups, but would like to know if there is any benefits that HANA DB can provide?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Abhishek....If you can read....that note is a general note on all the limitations of 10.1 NW! Wherever it is applied to Embedded/Unified it is mentioned in each line for each change. Does the hierarchy point has Embedded written over in it?????

If you have any doubts, please then contact SAP Support!

For HANA is concerned....I have limited knowledge of HANA....so I choose not to comment on it. Not sure it will help with alternate hiercrhies!

Regards,

JP

0
Vadim Kalinin Dec 22, 2016 at 06:13 PM
0

HANA is simply faster! But can you explain the strange business logic to require >50... hierarchies??????

Show 1 Share
10 |10000 characters needed characters left characters exceeded

P.S. Second time: "Primary tag is incorrect, please change! Has to be:

SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver"

0