Being active on a global SAP BW roll-out, I’d to find out which queries had already been created on a dataprovider (DSO, Cube, MultiProvider,….) before creating new ones.
As all roads lead to Rome, I’m herewith sharing the road I’d taken today.
- Execute transaction RSRT
- Within the ‘Menu bar’, select ‘Environment’ and then select ‘Query Mass Maintenance’
- Enter the name of the dataprovider within the ‘InfoCube’ selection field
- After the name of the dataprovider has been entered, press the ‘Check’ button
- The result will be a list of all queries, as shown below, which have been created on the dataprovider