cancel
Showing results for 
Search instead for 
Did you mean: 

How to identify which roles have been assigned to a query?

Former Member
0 Kudos
8,412

Hi gurus.

I have a query and I need to know to which roles have it been assigned to?

Appreciate if you could show me how.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

edwin_harpino
Active Contributor

hi Fullham,

take a look

table RSRREPDIR type in queries technical name to field COMPID (use arrow icon 'multiple selection) to get COMPUID, then go to table AGR_HIER SAP_GUID = COMPUID, AGR_NAME is the role name.

hope this helps.

Former Member
0 Kudos

Hi AHP.

Many thanks. I have retrieve the query's COMPUID and went to table AGR_HIER.

However, when I input the COMPUID into the field selection and execute the program, I've got a message as follows:

"No table entries found for specified key".

Appreciate your assistance.

Thanks.

edwin_harpino
Active Contributor
0 Kudos

hi Fullham,

how did you put COMPUID to table AGR_HIER ? directly copy to the screen ?

it may be truncated, the input available is shorter than the length of COMPUID,

try to use the arrow button beside the field ('multiple selection') and copy in the COMPUID.

hope this helps.

Former Member
0 Kudos

Hi AHP.

I've tried as what you suggested, using the arrow button and pasting the COMPUID into SAP_GUID's.

However I still face with the same problem. Appreciate your help.

Thanks.

edwin_harpino
Active Contributor
0 Kudos

hi Fullham,

try table AGR_HIER, SAP_GUID = query technical name.

or from transport connection, drag the query and use grouping 'in dataflow afterwards', and execute to collect the objects, you may see the role(s) there.

hope this helps.

Former Member
0 Kudos

Hi AHP.

Thanks. Still have the same problem when I put SAP_GUID = query technical name. Anyway, I think that transport connection solution should work. I am just trying to look at other way to quickly view to which roles a query is assigned to using other than transport connection.

Cheers.

edwin_harpino
Active Contributor
0 Kudos

hi Fullham,

i just simulated again AGR_HIER with SAP_GUID = query technical name in BI 7.0 and it works fine. your query has been assigned to certain role ?

try to assign query to certain role (PFCG - menu tab - bw report).

hope this helps.

Former Member
0 Kudos

Hi AHP.

Great answer. So, my query has not been assigned to any role. That's why table AGR_HIER return such an error.

Many thanks to you!

Sergiu
Contributor
0 Kudos

This worked RSRREPDIR-GENUNIID = AGR_HIER-SAP_GUID to finde the role from transaction PFCG.

Answers (1)

Answers (1)

susuang
Explorer
0 Kudos

Hello All,

To identify which role is assigned to specific query you can use below SQL statement (use fields OBJ_FROM, OBJ_TO).

 

SELECT DISTINCT 
	ROLES.AGR_NAME AS COMPOSITE_ROLE, 
	ROLES.CHILD_AGR AS SINGLE_ROLE, 
	UNAME AS USER, 
	ROLE_CONTENT.REPORT, 
	ROLE_CONTENT_QUERY.FIELD AS OBJ_TYPE, 
	ROLE_CONTENT_QUERY.LOW AS OBJ_FROM, 
	ROLE_CONTENT_QUERY.HIGH AS OBJ_TO
FROM AGR_AGRS AS ROLES
LEFT JOIN AGR_USERS AS USERS ON USERS.AGR_NAME = ROLES.AGR_NAME
LEFT JOIN AGR_HIER AS ROLE_CONTENT ON ROLE_CONTENT.AGR_NAME = ROLES.CHILD_AGR
LEFT JOIN AGR_1251 AS ROLE_CONTENT_QUERY ON ROLE_CONTENT_QUERY.AGR_NAME = ROLES.CHILD_AGR;