Skip to Content
0
Jul 01, 2016 at 09:28 AM

Retrive Web Intelligence reports connected to a Universe without using a Parent relationship

163 Views

Hi Experts,

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.

Regards,

Diego.