Skip to Content
0

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

Sep 07, 2017 at 02:16 AM

110

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded

Hi,

How and where is this hierarchy coming from?.

Thanks,

Jothi

0
Former Member

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sateesh Kumar Bukkisham Sep 10, 2017 at 02:13 PM
0

Hi Raj ,

Use set function "DEPTH" to find out levels .

=[hierarchy].depth .

Regards

Sateesh

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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 ?

0

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

0