Skip to Content

Drill down in Webi with Bex Query Hierachy and business layer on top

Hi there,

I need to use a business security profile to handle security on the BO users... but that's the main reason of why I got a business layer on top of a bex query.

IDT 4.2

Build: 14.2.3.2538 Version: 4.2 Support Pack 3 Patch 10

So, back in the bex query I have hierachies to drill down on a given characteristics that are on the business layer as dimesions, but I'm not able to drill down on them using a webi report, or create a custom hierarchy on IDT.

I'll appreciate your help on any colaboration on this subject.

Best Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 24, 2017 at 09:14 PM

    Aren't you better off using the Bex Query in BI Tools? And use BW security at data level. On the fly, can you try turning off Bex Hierarchy completely and check.

    Add comment
    10|10000 characters needed characters exceeded

    • On this scenario, there's a cost on the BW licensing that is blocking this native path for the security data level. So I look for the BSP on top of bex query as an alternative.