Skip to Content
avatar image
Former Member

Hierarchy level filter

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 10, 2017 at 11:12 AM

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

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2017 at 10:22 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded