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
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.
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.
SELECT * FROM CI_APPOBJECTS WHERE SI_KIND = ‘CCIS.DATACONNECTION’
this will extract all the data connections i.e. Relational and OLAP from the repository
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