I'm looking for a query to retrieve Web Intelligence reports connected to a Universe without using a Parents relationship.
SELECT * FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS
WHERE PARENTS("SI_NAME='WEBI-UNIVERSE'","SI_NAME =’EFASHION’")
My ultimate goal is to extract reports connected to a specific universe along with the folder path.
The script for extracting reports with folder path is unable to accept the "Parent", hence a workaround to fetch the data is required.
Thanks in advance.