Deleting variables and queries

[Former Member]

Apart from RSZDELETE what is the best alternative to delete variables and/or queries? Thanks

[former_member188325 · Accepted solution]

To delete Queries:

Apart from RSZDELETE, you can delete Queries from RRMX.

Execute the transaction RRMX->open>Queries>click on infoarea->navigate to youe infocube>expand it->you will see all the existing Queries under that infoProvider...from here also you can delete...

or

RRMX->open>Queries->Click on roles>slect Query->delete (by right clciking)->it will ask you whether Query to be deleted from role or delete object>choose delete object>Query will be deleted from server...

Hope this helps!

[Former Member]

Hi Niten,

Try this link.

Also see the replies of Siegi and Roberto in this thread for the same issue.

Cheers,

Aravindhan

[former_member188325]

U can try to display the Queries where one variable is being used from RSZGLOBV table the remove this variable from all Queries and delete the variable.

thanks

[former_member188325]

Hi Niten,

I am not sure about Tcode to delete variables....But you can delete all unnecessary variables from Query designer itself...But before deleting variables make sure you don't need them anymore and these varaibles are not being used in any other Queries...

If you try to delete a variable which is being used in other Query,it will display a message 'Variable being still used...etc....if you click on details...it will show you where it is being used....

To delete variables:

Open any Query-->expand Characteristic->expand charactristi value variables->right click->delete.

hope this helps

[Former Member]

Thanks have done a where used analysis so ok with that. With the queries just delete from the Open Dialog menu?

[former_member188325]

Yes niten,

you can delete Queries from Open dilog menu as i said above.

Thnaks