HANA SQL to give a BPC user name and get the dimension members that they can access

[mrj_marcelo]

Hi, all.

I need a HANA SQL code which I input a user name and a secured dimension name for BPC and it returns the list of dimension members that the given user can access.

I have tried join with tables USR02, AGR_USERS, UJE_PROFILE_AGR, but I didn't get success yet.

Who can help me?
Thanks and best regards.

[HakanHaslaman]

There is no direct way to get this information using HANA SQL because the authorization data is stored in BW authorization objects and not in HANA tables.