cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

0 Kudos

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.