Hello all,
Please go through the steps below and let me know if im right.
You need to have access to BW system to follow the below steps.
Go to Transaction RSZDELETE.(This T Code is used to delete Queries in BW)
My requirement is i have to delete 1000's of Queries,
After execution of the above transaction, u will get a Pop Up to enter the Query names,
"Technical Name" is in where u have to enter the Query name.
And then pressing the execute button will delete the particular query.
But the problem here is under "Technical Name" there are no multiple options available to delete 1000's of Queries.
Right now i have those Query names in an excel sheet, So using BDC can we write a program to automatically loop into that excel file and get the Query names one by one and to put it under "Technical Name" of RSZDELETE Transaction and automatically delete them???
If so please let me know all the steps from basics on how to create the BDC for this requirement.
As im not much into ABAP and i know very very basics of ABAP.
Please give me the appropiate links to study and accomplish this.
Thanks in Advance,
Sowrabh