cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchy in WEBI

Former Member
0 Kudos
3,124

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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

Answers (9)

Answers (9)

Former Member
0 Kudos

Thankyou all for the reply

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

Hi Pallavi,

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

Former Member
0 Kudos

Pallavi,

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

Regards,

Mark

arijit_das
Active Contributor
0 Kudos

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
0 Kudos

Just create Custom hierarchies based on your requirement.

Regards,

Chandrakanth

arijit_das
Active Contributor
0 Kudos

Did you check this:

former_member309630
Active Participant
0 Kudos

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