It’s ‘easy’ to find out which queries have been created “on top of” an infocube or multiprovider.
–> Execute transaction RSA1 and press the “Metadata Repository” button (left bottom of the screen)
–> Within the overview of all repository objects, click on multiprovider or infocube. See screengrab below

–> A list of all multiproviders/infocubes will be displayed and from within this list, select the desired infocube or multiprovider.
–>A new screen will be displayed, containing all information regarding the selected infocube.
–> If you scroll all the way down, you’ll find an overview of all queries created for this infocube or multiprovider.See screengrab below