Authorization on Bex Queries.

Hello,

below is the current scenario,

Auth Object

Account

Segment

Company

Hierarchy object

ROLE1

Account - * (all accounts allowed)

Segment - AIM

COMPANY - 3000

ROLE2

Account - * (all accounts allowed)

Segment - *

COMPANY - *

USER Jhon has ROLE1 under him.

Requirement:

New Query is developed

In this Query ALONE User Jhon should be able to see ALL Companies and Segments data (meaning ROLE2 should be used).

and In the OLD queries still user should be able to see the data as per the ROLE1

any ideas will be rewarded.