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

Hierarchy in WEBI

Hi team

I have created a universe based on the SQL table from SQL 2005 server.

Now I have also created webi on top of that universe.

But now my problem is i want to create an hierarchy from three fields from SQL table..how can i achive it?

Three fields

1) Sales Manager

2)Sales Leader

3) Sales employees

NOw in the webi i want to see this data in hierarchy fasion.? How can this be achieved

Please provide some hints

Thanks

Pallavi

Add a comment
10|10000 characters needed characters exceeded

Related questions

10 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2014 at 12:48 PM

    I have created custom hierarchy but i need guidance on how to use it in webi.

    I want report to display the first col as hierarchy.. and then next col with the quantity.

    There are few other dimensions as well to be displayed along with hierarchy like the region, flag etc..

    Your help is appreciated!!

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 30, 2014 at 11:27 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2014 at 11:31 AM

    Just create Custom hierarchies based on your requirement.

    Regards,

    Chandrakanth

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 30, 2014 at 11:35 AM

    If you want hierarchical expand-collapse option in webi (like Web Intelligence 4.0: Connect to a Bex query with hierarchical data), then I guess it is possible only for OLAP.

    Alternative is applying Break and using Page Fold/Unfold in webi.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 30, 2014 at 11:19 AM

    Hi Pallavi,

    You may create this Hierarchy by using custom hierarchies option right??

    Please let me know if you need steps for creating this hierarchy..

    Thanks,

    DSP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2014 at 12:02 PM

    Pallavi,

    You would be best creating the hierarchy within the universe.via the Tools - Hierarchies menu

    Regards,

    Mark

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2014 at 01:01 PM

    Hi Pallavi,

    Solution provided by Arijit Das will surely work for your query..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2014 at 02:16 PM

    The key here is the enable the drill mode...and also you will have correct access setup for your accounts in CMC to be able drill..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2014 at 04:10 AM

    Hi Pallavi,

    If you need to display your data as hierarchy at report level. note that such functionality is only available with OLAP data with hierarchies.

    but you can play with formatting of a table to make it look like a hierarchy.

    Please refer following link for more details.http://scn.sap.com/community/businessobjects-web-intelligence/blog/2013/06/05/bobj-trick-to-display-table-data-in-hierarchy-format

    But If you need to use only power of drilling functions then go for custom hierarchies/custom navigation paths as suggested by others in above comments.

    Note: Custom Navigation path does not display day in hierarchy form but allows you to navigate through hierarchy using drilling options.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 06, 2014 at 11:27 AM

    Thankyou all for the reply

    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.