Skip to Content
Aug 21, 2020 at 01:45 PM

BEx Query Designer: Show or hide key figure column based on user authorization

133 Views Last edit Aug 24, 2020 at 07:31 AM 2 rev

Hi all

I have the following requirement:
We have a BEx query with two key figures. The first key figure is always shown but the second key figure should only be shown for some users. Therefore it should be suppressed for the other users. The users with showing the second key figure are authorized for 0COMP_CODE = *, the other users only for one company code.
I know this can be done by making all key figures relevant for authorization (0TCAKYFNM) but this is the only key figure with this requirement. And we do not want to change all our BW authorizations.

How can I design the query to manage this?