Skip to Content
author's profile photo Former Member
Former Member

Clarification on Hierarchies


what is difference between custom hierarchy and report based heirarchy?


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2012 at 07:52 AM

    Dear Franz,

    Regarding to the Hierarchies in Business Object -

    Report Based Hierarchy (Default Hierarchy): is Based on the Order in which Dimensions are placed in the Class within the Universe.


    In this case, when User perform Drilling on the report, user will be able to drill on Dimension accodring to the above Order in the Universe.

    Drill Path: Year -> Year_Half -> Quarter -> Month

    This drill path is defaulted in the report according to order in the universe.

    In some cases when user want to drill directly from "Year Dimension" to "Quarter Dimension" and they don't want to passthrough the "Year Half Dimension". In this case, we can use "Custom Hierarchy".

    Custom Hierarchy: is used when two or more hierarchies starts with Same Dimensions but follow by different dimensions at lower end.

    You can defind Customer Hierarchy in Universe Deisgner by selecting "Tools > Hierarchies" as shown in following figure.

    In this case you can define "Custom Hierarchies" as follow:

    By defining "Custom Hierarchies" in Universe, you don't need to create a New Class with Different Dimension Hierarychy which may lead to Complexity of Universe. More efficient way to solve when different drill-paths are required for one Class in Universe.

    When user peform drilling in report, Business Objects will prompt to choose the drill-path as shown in following figure:

    Reference from:

    Hope Helpful.

    Best Regards,

    Han. 😀

    New Picture.png (3.8 kB)
    New Picture.png (3.5 kB)
    New Picture2.png (9.9 kB)
    New Picture.png (8.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 21, 2012 at 12:34 PM

    Hi Franz,

    Custom Hierarchy---In custom hierarchy the sequence of dimensions is defined by developer based on business need of analysis.

    Report based hierarchy---A hierarchy based on the order of the objects within a class is a default hierarchy.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.