cancel
Showing results for 
Search instead for 
Did you mean: 

Transaction for overview of Queries published in Roles via Query designer

Former Member
0 Kudos

Hi Guru's,

in Query designer I have the possibility to publish Queries in roles.

I have the problem that some Queries have been published twice or more in different folders, so I want to clean it. But I don't know how to delete the Queries via BEx Analyzer as they are there again as soon as I log in again.

Isn't there any transaction in Backend that I can use to structure my Queries in roles?

Thanks in advance!

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Ok, probably this is the problem. I did this in the productive system as we do not have every Query in the development system...

Ok, thanks!

Former Member
0 Kudos

One way to delete unneeded duplicates....

Go to Query designer, in development

Instead of loading the query you want to delete, find it in the folder/role

Click on the "Trash Can" icon

Then we have 2 more options to consider....

- Delete object ...will TOTALLY delete it in the development system.... caution with this one, unless you really do want it to permanently go-away.

- Delete only the object reference from the Role/Favorites... will delete the one instance in the folder, but leaves it everywhere else, useful when deleting a duplicate report in the folder

After choosing one of the 2 options above, then click on the 'continue' button.

"Refresh" to check what was done in development = Menu / Refresh

When done... transport the role to Q and Production.

Similar process if the query is located inside of web template and there are multiple instances of the same web template in the roles/folders that need to be cleaned up in the web application designer.

Former Member
0 Kudos

Transaction to delete queries is

RSZDELETE

You can also manually delete queries by goin into the query designer.

What do you mean by u201CPublish queries in Rolesu201D

I am not sure what you are looking for when you say Roles. Try the transaction PFCG which enlists all roles and queries under it.

try to explore there and let me know if it helps you determine what you want to do.

If I am talking different language please explain in detail what u want to do in simple terms

Abhijit.

Former Member
0 Kudos

Hi,

ok I used Query Designer -> Query -> Publish -> to Role. You can use a file structure hear with folders and so on, while the highest level is the role.

This is just a link to the real Query, but it's easier for the user to search for a query via roles than info areas (in Bex Analyzer).

But transaction ZSDDELETE is for really deleting Queries. I just want to have like an overview of this role structure, where Queries are published and there also the possibility to rearrange it or even to delete a query link out of a folder.

Do you know what I mean?

Former Member
0 Kudos

Transaction PFCG should be helpful in re-arranging the order, etc. and deleting or adding the query's menu item/link inside that role/folder. The role still needs to be transported thru the systems, or else the items still appear in the folders, etc.

Edited by: Sharon West on Dec 8, 2008 12:53 PM