cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchy level filter

Former Member
0 Kudos

Hello Everyone,

In my WEBi Query I want to print top 8 values from hierarchy which is coming from BEX

and i want to print the level 3 hierarchy values and with out having the main hierarchy.

Can anybody help me on this.

Former Member
0 Kudos

Filter on hierarchy node level

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hey Amit, Thanks For the answer,

But whenever i apply ranking on Hierarchy I am getting the main Hierarchy level (0 & 1) values in the report.

But i want with out Level 0& 1 i.e i need only level 2 values with out hierarchies in the report.

I am using that hierarchy in Crosstab.

amitrathi239
Active Contributor
0 Kudos

check attached link. try with creating =hierarchy.depth function

http://davidlai101.com/blog/2013/04/08/custom-bw-hierachy-level-selection-in-webi/