Queries without infoprovider

[Former Member]

Hi, I have some queries in my BW system that are not relied to an infoprovider ( May be deleted ). I tried to delete them with Query designer and transaction "rszdelete" but they are not listed. So, I wanna know if they are still in the system because there is records about these queries in the table "rsrrepdir".

Thanks

[Former Member]

Olivier,

Yes, first you have to delete from table rsrrepdir with the technical name of the query. Check in your favourites whether this query is displayed. After you delete the entry from rsrrepdir table, goto bw in favourites folder, right click on the query that you want to delete and click on delete. Now if you goto BEx your query should no longer visible.

GSM.

[Former Member]

Take a look a Notes <a href="https://websmp201.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_OBJECT=012006153200001604712004">792779</a>. This Note documents a pgm that identifes many query inconsistecies and allos for correction/deletion. See if it is what you're looking for.

A couple of related Notes that might also be helpful -

<a href="https://websmp201.sap-ag.de/_{form/sapnet?_FRAME=CONTAINER&_OBJECT=012003146900000314472005">859086</a>and [url=https://websmp201.sap-ag.de/}form/sapnet?_FRAME=CONTAINER&_OBJECT=012003146900000460362004]776385[/url]

[Former Member]

Hi,

As per my knowledge you can't delete an infoprovider if there is any query on that. It means if you are sure that infoprovider has been deleted that means these queries are also deleted.

Regards,

Rohit