How to find out which WebI Reports are using which Universes

[system]

Hello,

We have about 400+ WebI reports and about 12 Universes. How do I get a list of all these WEBI Reports and what universes they are using in a single file?

something like this:

QUERY ON CMS TO GET ALL WEBI REPORTS USING A UNIVERSE OBJECT

Hi, I am using BO XIR2. i want to get all webi reports that are using a particulor Universe object(object). Is there any way to get above information by querying on CMS database(Query Builder) Thanks PP ppbo (BOB member since 2006-11-05)

thanks

---

exile (BOB member since 2008-05-03)

[SebastienGoiffon]

Hi,

You cannot use the Query builder because you must run several queries.

Make a search on BOB there is a tool call webi scanner…

[system]

i have not yet tested myself so do let us know how it goes:

Return Webi Reports Connected to a Specific Universe

 SELECT
SI_NAME, SI_WEBI, SI_DATACONNECTION
FROM
CI_APPOBJECTS
WHERE
SI_KIND = ‘universe’ and SI_NAME = ‘Universe Name’  

The query above returns all the WEBI documents assigned to the Universe by specifying the following information:

SI_NAME: The name of the Universe.
SI_WEBI: The list of Webi documents assigned to the Universe by SI_ID.
SI_DATACONNECTION: The data connection assigned to this Universe.

To list the Webi report names run the following query:

 SELECT
SI_NAME
FROM
CI_INFOOBJECTS
WHERE
SI_ID IN (ID from SI_WEBI, ID from SI_WEBI) 

---

twenty5 (BOB member since 2008-01-22)

[system]

R bhai? mu-hahah (ahem guys, sorry)

Thanks.

These query can get you what you need.

[1] To get everything:

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND = ‘WebI’

[2] Partially important stuff

SELECT

SI_ID, – WebI Report ID
SI_NAME, – WebI Report Name
SI_DESCRIPTION, – WebI Report Description, if any
SI_UNIVERSE, – Universe ID
SI_OWNER, – Report Created By
SI_CREATION_TIME, – Created ON
SI_UPDATE_TS, – Last Updated ON
SI_LAST_RUN_TIME, – Last Run ON, if ever
SI_CHILDREN – Instances, if any

FROM CI_INFOOBJECTS

WHERE SI_KIND = ‘WebI’

GROUP BY SI_UNIVERSE

– ONLY Other problem is SI_UNIVERSE has 4 cells and the actually Universe ID is not the 1st cell, but on the 4th cell and thus the Group BY doesn’t really work very well.

---

exile (BOB member since 2008-05-03)

[system]

Hi Twentyfive,
I ran the same query (SELECT
SI_NAME, SI_WEBI, SI_DATACONNECTION
FROM
CI_APPOBJECTS
WHERE
SI_KIND = ‘universe’ and SI_NAME = ‘Universe Name’ ) but everytime it is telling me that ‘this is not a vlid query’. Could you please help me?

---

Philip (BOB member since 2006-03-02)

[system]

Try this query submitted by Mak 1. Works like a charm.

---

BoB LoblaW (BOB member since 2007-10-23)