Deleting queries on deleted infocubes..

[Former Member]

Hi,

Does anyone know how to delete queries that were built on infocubes that have been deleted? It seems that the queries weren't deleted first and so they still come up as existing queries.

Do they still actually exist?

Is there a way to delete them?

Thanks,

Allan

[Former Member]

Hi,

There are several ways to identify the Queries. You could check out statistics table to see access history of the cube (if stats acitivate) RSDDSTAT or better search for the Query (cubename/*) and delete them in RSRT.

[Former Member]

Thanks Peter!

I had a look at RSRT, but I couldn't see a way of deleting the query. How do you do this?

[Former Member]

We had a similar problem.

SAP recommended transaction RSZDELETE and select Type REP

and enter the InfoProvider name, then execute

The queries are selected, that are based on this infoprovider. Set the flag and press 'Copy' -> The queries will be deleted.

Thanks,

Mark