BI roles-queries

[Former Member]

Hello,

I have some BI roles and queries have been assigned in to those roles.

I need the list of Roles versus Queries , is there any table in BI where i can down load this in Excel ? ( like we have agr_tcodes table in R/3.. )

Thanks,

SR

[manohar_kappala2]

Hi,

if you are referring to the queries which a user has access to can be known to a level through

AGR_1251 for Auth Objects S_RS_COMP, S_RS_COMP1.

reports with the instances having field RSZCOMPTP with value "REP"

in them verify values for field RSZCOMPID "Name (ID) of a reporting component".

The value there the list of queries to which a user has access to.

But the problem is u might not get the exact names in some cases where a string has been given like CA* etc..

same way look for the COMP1 object too and the intersection of these two is the access u have..

hope this helps

Manohar