cancel
Showing results for 
Search instead for 
Did you mean: 

How to show different levels of hierarchy in different columns in WEBI report

Former Member
0 Kudos

Hi

I'm not that savvy in WEBI report recently I got requirement that I want to show different level of hierarchy different column WEBI report .And we're building report on top of bex queries

Eg:

Commitment Item Revenue percentage in revenue

Revenue

Taxes

sales taxes

I want output as :

Commitment Item Revenue Taxes Revenue percentage in revenue

Is there any way than I can be doable?

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

How and where is this hierarchy coming from?.

Thanks,

Jothi

Former Member
0 Kudos

Hi Jyothi

These hierarchy are come from BW .

Current Report output

Inline image 1

Expecting report out put should be like this

Inline image 2

Accepted Solutions (0)

Answers (1)

Answers (1)

sateesh_kumar1
Active Contributor
0 Kudos

Hi Raj ,

Use set function "DEPTH" to find out levels .

=[hierarchy].depth .

Regards

Sateesh

Former Member
0 Kudos

Hi sateesh

Thanks for your response .I tried as you said but no luck

Before Depth function

Inline image 1

After Depth Function

Inline image 2

After applying depth function Budget values are missing .Just I want to know is it doable ?

sateesh_kumar1
Active Contributor
0 Kudos

I didn't see any images ! . Is data from 2 queries ?

we can derive levels using Depth function ,then use If else to get the required level information .

Regards

Sateesh