on 03-18-2015 7:02 PM
Can someone suggest me a query to find the reports having freehand SQL?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rishav,
You can use Query build to find out list of ALL WebI reports NOT using Universes.
SELECT TOP 2000 * FROM CI_INFOOBJECTS
WHERE SI_KIND='WEBI' AND SI_UNIVERSE.SI_TOTAL=0
You can also see link to Query Builder Clean-up Blog
Regard,
Ajay
Hi Rishav,
You can use query builder
Please check also this KBA which can fulfill your request :
http://service.sap.com/sap/support/notes/1928829
1928829 - How to retrieve the the entire list of Desktop Intelligence Reports based on freehand SQL ...
Kind Regards
Ameni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.