Can not delete the query

[gunesbt]

Hi all,

I have a query and a workbook including that query.However, now, I decide to change the name of the query.So I save it as another name and try to delete the old one.But I can not delete it.I change the data provider of the tables in the workbook as new named query to stop using the old named query.Although I did that, I still get the message:"The query can not be deleted." because it is still seen as if it is used in the workbook.

Regards,

Sunny

[Former Member · Accepted solution]

Hi,

Please check the link:

http://help.sap.com/saphelp_nw70/helpdata/en/f1/0a5680e09411d2acb90000e829fbfe/content.htm

In this there is a point mentioned.

3. You can also delete the query. In the Query Designer menu bar, choose Query ® Delete. You can delete the query only if it is no longer being used (that is, if it is not being used in any workbooks, Web templates, report, or broadcast settings).

Regards,

Amit

[gunesbt · Accepted solution]

Dear Amit,

I know how to delete the query.The problem is that although I do NOT use the query, I get a message shortly saying that "you are using query in the workbook, so you can not delete it".But as I told you, I checked the workbook and I do NOT use the query in the workbook.I used to use the query in the workbook but it is no longer being used now.

[Former Member · Accepted solution]

Hi,

1) Check if some of your old query elements are still being used in the workbook (like for text elements, Navigation Panes etc.)

2) If you goto metadata repository in RSA1 and select Query - you can find your query there. Click on it and you will get the list of workbooks where the query (or any of its elements) are being used.

3) If you have changed the data provider value with a new query for each of your tables, just goto the workbook settings once and see if there is only one data provider with the new query assigned. If not, change it.

[former_member356574 · Accepted solution]

Hi.

All

For Delete the Query . ( BEX 7.0)

First chk your InfoArea ,Favourite,History,Roles if the Query is Available there.

Go to Query Designer << History << find it >>>> delete the query .

after that if it is available <<<<<then Go to your Favourite <<<<<Search Query,<<< delete it.

Again check InfoArea <<<<<<<<chk quey there <<<<<< open it,<<< saveas( RENAME) it.

Thanks,

Asit

[arvind_doomra · Accepted solution]

Dear Sunny,

Did you try below as it seems your system is closed for changes. In that case you can follow the below steps to

make the changes without opening the system.

a. RSA1 -> Transport Connection

b. Object Changeability button

c. Object ELEM (Query Element) is set to 'Not changeable'. Right-click

and change to 'All changeable'

d. Now ELEM object type is set to changeable -> try to delete the

query again.

Regards,

Arvnd

[gunesbt · Accepted solution]

Thank you very much Shruti.Thanks to your 3rd suggestion, I found a very small but important detail.I realised that the query is still in the workbook although I do not use it now(the query is not used but in the list of the data providers).Displaying the data provider list in the workbook settings solved my problem.