Hierarchical Grouping in webi like Crystal

[Former Member]

I would like  to know the Option  to group data hierarchically when building Web Intelligence reports just like we can do in Crystal Reports 2008. If We have a table that contains a parent-child relationship such as Employee ID and Manager ID then I would like to build a hierarchical report that understands the parent-child relationship and displays the report results hierarchically.

Regards

Yogi

[Former Member]

Thanks Ingo!!. I will do this in the underlying source

Regards

Yogi

[Former Member]

Hi Nikil/Sahil

I am not asking about the Hierarchies in universe My requirement is I have to show the report like below

--In DB I have Mapping like this .,.Employee id , Employee name, Mangerid

The hierarchy is like this

Reps --> Manager--> Area Manager-->Director  for 1 channel

For Other Channels Reps-->Directors

So Here it is Ragged Dimentions and levels are also not Fixed . The manager I can find using Managerid

Report Should be shown as below

Level1  Name --> Directior

Level2  Name -->Area Manager

Level2 Name --> Manager

Level3 Name --> Reps

Block with Rep Details .

So Basically I need to group the Records Based on Mangerid/ Name (It should be dynamic )

In CR I know we can do this based on the Hierachical Grouping

In DB We can achieve this using Connect by SQL . I want to know any way to do this in Webi  Report Level

Regards

Yogi

[Former Member]

Hi,

If You Have Four Dimensions for 4 Levels Then you can achieve it by applying sections.

Section 1 = Level 1(Director).

     Section 2 = Level 2(Area Manager).     //This Section will be inside Section 1.

          Section 3 = Level 3....

Like That You can add multiple levels & It will be dynamic.

[IngoH]

Hello Yogeeswara,

Web Intelligence is able to leverage the hierarchy either from the underlying source - like BW - or from the Universe but Web Intelligence does not have the option to create in the report a hierarchical grouping based on a parent child relationship like you mentioned from Crystal Reports.

For Web Intelligence the hierarchy has to exist already in the underlying source

regards

Ingo Hilgefort, SAP

[Former Member]

Hi,

You will have to maintain hierarchy in Universe level Tools-->Heirarchies.

Maintain Custom Hierarchies & Export universe .

[former_member207878]

Please go through below link:

http://www.bidw.org/business-objects/universe-design/hierarchies-in-business-objects-universe/