Deleting Queries from a role

[Former Member]

Guys,

Is there a way to delete Work books and Queries from a role menu from front end rather doing it from back end using PFCG? can some one share their knowledge..

Thanks,

KK

[Former Member]

No, as far as I can recall, you cannot delete queries using Query Designer - you can move them though, but the ability to delete is not there. It has to be done in PFCG.

[Former Member]

You can delete both queries and workbooks from BEX Analyzer. In the main menu go to Business Explorer->Query or Business Explorer->Workbook and select the delete option.

However you should also have access to the authorization S_RS_COMP auth object (activity 06, type of rep comp REP and the correct values for InfoArea and InfoCube on which the query is defined>) in your roles.

[Former Member]

You can remove any Reporting component from a role menu from BEX, WADand PFCG.

For a security person, PFCG would be the best interface to do it. S_USER_AGR with change ability allows you to play with the role menu.

and for ur powerusers(developers) who has to maintain the reporting components in the role menu. they can use BEX and WAD. these users should haveS_USER_AGR and also access to the role menu. and also Node types in S_USER_TCD for web tempaltes(SAP_BW_WEBTEMPLATE)

when it comes to actual deletion of the queries and workbooks from ur system, you should be using BEX or Query Designer. ANINDA already mentioned the technical part of it. You can't delete the Reporting components from the system using PFCG. For this purpose you have to use BW components not BC components. you can just remove the object entry from the role with PFCG.