Skip to Content
avatar image
Former Member

Hierarchy Node Suppression in a BeX Query

Hi,

We haev a hierarchy with 3 levels

Level 1 (Root) - Customer Hierarchy

Level 2 - Customer Groups

Level 3 - Customer Number

Is it possible to display the Customer Groups (level 2) without displaying the Root Node (level 1) in a BeX query. If we Expand to level 2 , the query displays both level 1 & level 2. We have a requirement to see level 2 only. Is that possible?

If anyone has done this, would really appreciate if you can respond.

Thanks,

Anita

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 23, 2009 at 11:46 AM

    Do one thing create Authorization for Hierarchy so that the user can see only from level 2.

    Cheers,

    Neel.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2009 at 11:12 AM

    You can not achieve this using Hierarchy display. The solution will be to use characteritsics at each node as a seperate navigational attributes and give user flexibility to navigate as per the requirement. In the free characteritsics, remove the level one characteristics.

    - Danny

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2013 at 02:52 AM

    Hi Anita,

             Even we had same requirement to show at some level, then we have used the same approach as Dhavan Mehta says.

             We had hierarchy on Group, so used that as flat list to show data at desired level.

    Hope it helps!

    Thanks,

    Umashankar

    Add comment
    10|10000 characters needed characters exceeded