I can run the following query to find the list of report and list of universes, but I have not been able to build a query that can give me a list of universes associated to a specific report.
Get the list of all universes
SELECT SI_ID, SI_NAME, SI_KIND, SI_SL_UNIVERSE_TO_CONNECTIONS FROM CI_APPOBJECTS
WHERE SI_SPECIFIC_KIND=‘DSL.Universe’
Get the list of all WebI documents
SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND=‘WEBI’
Can anyone help with this?
hi
there are many topics with this – please try to search first
e.g. BO Query Builder - general discussion - BusinessObjects Board (bobj-board.org)
T.
I have looked through them all. There is no article relating to Webi reports with universe names. As you can see in my original message, the codes I listed I got them from here.
well . from that link step 1 returns universes (incl names) and SI_IDs of the webi reports
and Step2 reports. Ive tried it in the morning…
btw you dd not mention the BOversion but at least from BO 4.2 tere is the CMS driver + BI analysis universe where you can build such a report with link Report - > universe… I think
Thanks, Tom.
Yes. we are using 4.2 sp6. I will definitely try the steps provided. Appreciate it.
I do have the Auditing universe which I use to pull all sorts of activity information, but it does not return reports with associated universe.
If I do want to pull the universe data, it runs forever and times out.
What CMS + BI Analysis. Is that same as Auditing?
no - the universe is called: BI platform CMS system database.unx
during installation among the supported DB there is also a CMS driver (DataAccess.CMSDBDriver in response file) whis is used by that universe to access the BO system db data…
how to create a query is quite tricky - see screenshot (by JohnBClark) with available fields:
Reports Based on unx universe from BI platform CMS system database Universe - general discussion - BusinessObjects Board (bobj-board.org)
I had somewhere some tutorial how to use it - I will look for it.
something tells me I am unable to put here a link to official SAP site but it is KBA 2399962
yeah the trouble with auditing is there are too many records and any query must be always limited
I am more an admin than a developer - but recently Ive promised to create some overview with report - universe - usage so I will have to create some report as well anyway … probably next week
Thanks. I will try all the steps mentioned and update here.
I also already have the Auditing universe in BO 4.2 sp6 configured and can easily find the BO reports activity, history and usability etc.
But when I try to find the universe using auditing, the query never finishes and times out.
auditing universe (db) is related to events which were recorded to audit DB based CMC - Auditing settings - we have Default level, 90 days but its good idea to limit the result by some date e.g 3 days back… but to setup the query is not easy as e.g IMHO universe field is not in direct relation to events so combination of these field returns nothing to me
regarding using that BI CMS db universe: if I use something like that
I get:
which is the basic relation report → universe
