Skip to Content
0

Hierarchy level filter

Feb 10, 2017 at 10:22 AM

16

avatar image

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.

10 |10000 characters needed characters left characters exceeded

Filter on hierarchy node level

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

2 Answers

AMIT KUMAR
Feb 10, 2017 at 11:12 AM
0

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

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

Share
10 |10000 characters needed characters left characters exceeded
vaman kumar Feb 13, 2017 at 10:22 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded