Skip to Content

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

Oct 24, 2017 at 08:38 PM


avatar image

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: 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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

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.

Show 1 Share
10 |10000 characters needed characters left 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.