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

[Former Member]

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.

[former_member205064 · Accepted solution]

IF your Ultimate goal is to get  extract reports connected to a specific universe along with the folder path.

Best option which save time and effort is macro, run on any machine where you

have the CLient tool installed.

http://www.forumtopics.com/busobj/viewtopic.php?t=202819

This works for BI4 as well.

The limitation of select query is you will not get the folder path from there but macro works like a charm.!

[Former Member · Accepted solution]

Hi Raunak,

That's helpful, but when executed it's extracting data for all the universes. I need to then filter under DocDetails tab.

Since there is no option to extract data for specific universe during execution itself, it's been executing for quite a while to pull out the data. It's been tested on a test env, but to extract 600 records it took close to an hour. I have the doubt the amount of time it would take when connected to Prod.

It will be of great help, if there's a select query to retrieve the reports connected to a specific universe along with the folder path so that it could be integrated with a .JSP file... Folder path is definitely required to identify and reach to a conclusion.

Regards,

Diego.

[JohnClark]

If you have BI4.x, you can right click on the universe, choose Tools, and then Relationship Query.  This will give you a list of all of the reports that source against that universe and the folder path.  Unfortunately, you can't export this list.

[Former Member]

John,

You can export the query to excel.. See my post on "

@DeSilva,The BI Support tool also should give you a list of what you were looking to achieve. Search for BI SUPPORT TOOL and Install it. Works like a charm for BO 4.0 and up.

[former_member187093]

As Raunak said, macro is the best option.

it seems people still remember forumtopics 🙂 , Thanks Raunak.