Hierarchy in WEBI

[Former Member]

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

[Former Member · Accepted solution]

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!!

[arijit_das · Accepted solution]

Once you create the table, enable drill option. Then you can drill down to next object in hierarchy by clicking on any item in first column(parent object in hierarchy).

[Former Member]

Thankyou all for the reply

[Former Member]

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-...

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.

[Former Member]

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..

[Former Member]

Hi Pallavi,

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

[Former Member]

Pallavi,

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

Regards,

Mark

[arijit_das]

If you want hierarchical expand-collapse option in webi (like ), then I guess it is possible only for OLAP.

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

[Former Member]

Just create Custom hierarchies based on your requirement.

Regards,

Chandrakanth

[arijit_das]

Did you check this:

[former_member309630]

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