Skip to Content

Alternate Hierarchies Limitation

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!

Add comment
10|10000 characters needed 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

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 21, 2016 at 06:56 AM

    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

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



    Add comment
    10|10000 characters needed characters exceeded

  • Dec 22, 2016 at 06:01 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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 I choose not to comment on it. Not sure it will help with alternate hiercrhies!



  • Dec 22, 2016 at 06:13 PM

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

    Add comment
    10|10000 characters needed characters exceeded