BusinessObjects Query builder – What's New in BI 4...

former_member182521 · ‎2013 Jul 26

Continuing with Query builder blog series here is another one with more emphasize on features of BI 4.0. Below are the features of consideration

Users homepage is enhanced to view his/her latest documents and Alert notification.
Connection specific enhancements
Universe enhancements
Monitoring

And here is the respective queries for each consideration

Alert Notification and recent document Query for User

SELECT SI_ID, SI_NAME, SI_RECENT_DOCUMENTS,SI_RECEIVED_ALERTNOTIFICATIONS

FROM CI_SYSTEMOBJECTS WHERE SI_KIND='USER'

This will be extracted for each user in the system.

Probes

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND='MON.Probe' AND SI_INSTANCE =0

Please note I am just extracting probes alone not its instances. To retrive the proble instances you need to use SI_INSTANCE =1 in the where clause.

Connections

SELECT * FROM CI_APPOBJECTS WHERE SI_KIND = 'CCIS.DATACONNECTION'

this will extract all the data connections i.e. Relational and OLAP from the repository

Universe

SELECT SI_ID,SI_NAME,SI_SPECIFIC_KIND, SI_KIND FROM CI_APPOBJECTS WHERE SI_KIND= 'DSL.MetaDataFile'

We can further categorize the individual components of universe using SI_SPECIFIC_KIND and this is the component list for the .unx universe.

Hope this is interesting. Feel free to leave your comments. Thanks for reading.

Query Builder Blog series

Basics

Sample Queries

Use cases

BusinessObjects Query builder – What's New in BI 4.x