Is it possible to find out for one universe in which reports is used?

[Former Member]

Hi,

Can we find out for one universe in which reports is used?

We have universes that we used to create different reports, InfoView reports. And we need to find out in which of them.

Regards,

[Former Member]

Thank you guys for your help.

I can find now for one universe to which report is linked. But, does somebody know to write query for finding all universes to which reports are linked, but reports to be with its name, not ID?

I used below query, but this is showing based on the ID of report:

SELECT si_name,si_webi FROM CI_AppObjects

WHERE si_kind = 'Universe'

[Former Member]

Hi Valdette,

If you're going with Query Builder, the result will be the Object IDs.

You'll have to re-query these object IDs to get the report names.

Recommend:

//For searching for names of Reprots for one universe

select si_name, si_id from ci_infoobjects where si_id IN('ID1', 'ID2', etc.)

You could query ci_appobjects, using the "IN" filter for several Universes also to modify the query in my last output.

But this is how QB will display the result.

-Sid

[Former Member]

1. go to CMC

2. go to Universe

3. select your universe and right click

4. select tools

5. select check relationships

[nscheaffer]

Very nice Mauricio!

[former_member182521]

Without complicating this, lets utilize the Relationship queries. Refer here http://scn.sap.com/community/bi-platform/blog/2013/09/13/businessobjects-administration--relationshi...

[pavan_k11]

You could use metadata management tool for this.

[Former Member]

Hi Valdete,

You can run a query for the universe using QueryBuilder:

http://servername:port/AdminTools

You can find out the CUID of the universe by viewing its properties. Note this CUID down.

CUID is the longer, alpha-numeric value.

In query builder, run the following:

select si_name, si_webi from ci_appobjects where si_cuid='Cuid of the Universe'

OR

select * from ci_appobjects where si_cuid='Cuid of the Universe' (then look for SI_WEBI.

SI_WEBI stores the object IDs of all the reports that this universe points to.

You can then query the table ci_infoobjects, using si_id to find details of the report.

I would also recommend you to go through the links that Ajay has posted as this provides a better insight into QB.

Hope this helps.

-Sid

[CdnConnection]

Valdete,

      The information you need can be accessed via Audit Database by deploying the sample Audit UNX and Crystal Enterprise reports &/or using Query Builder.

Link to Using Query Builder

Link to download Audit UNX & Crystal Reports

Regards,

Ajay