on 06-02-2009 3:09 PM
Hello,
In Report Deisgner, I have to build a report per company employee. The organisation is managed in the hierarchy 0ORGUNIT and I would like to see all levels of my hierarchy for each employee.
The hierarchy is always displayed with nodes, but I would like it to be this way:
Employee XX
Level1
Level2
Level3
Level4
....
Employee YY
Level1
Level2
Level3
Level4
In fact all levels should appear at the lowest level of the hierarchy.
Is there a way to do so ?
Thank you for your help,
Benoit
Hi..what is present under levels?
also ,is the no. of employess not much..then only you can put their values in text node?
If so then go in RSH1.
Create one hierarchy on the infobject which is at the lowest level.
for ex.
I have a hierarchy :
Region 1
PlantA
PlantB
PlantC
Region 2
Plant X
Plant Y
Plant Z
.
So I create text nodes for region 1 and region 2.and I put the plant infoobject as characteristic values.
When I see report .I can drill down from Region to Plant.
Regards,
RK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Which version of BI are you using so that i can give you exact steps. When you select hierarchy,,there is option for 'Upto how many levels you want to expand'. There you select the lowest level & then save & execute the report. You will get the hierarchy to the level you have specified. This you can do at report level also but that will not be default.
regards
Sandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.