Hierarchy level filter

[Former Member]

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]

Filter on hierarchy node level

[Former Member]

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]

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

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