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

[former_member182521]

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.

• DSL.BusinessLayer
• DSL.DataFoundation
• DSL.Connection
• DSL.Universe
• DSL.DataSecurityProfile
• DSL.DataSecurityOptions
• DSL.BusinessSecurityOptions
• DSL.ConnectionShortcut

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

Query Builder Blog series

Basics

             BusinessObjects Query builder - Basics

               BusinessObjects Query builder – Best practices & Usability

Sample Queries

             BusinessObjects Query builder queries

               BusinessObjects Query builder queries - Part II

               BusinessObjects Query builder queries - Part III

               BusinessObjects Query builder queries - Part IV

               BusinessObjects Query builder – Exploring Visualization Objects

              BusinessObjects Query builder – Exploring Monitoring Objects

              BusinessObjects Query builder - Exploring Lumira & Design studio Objects

Use cases

               BusinessObjects Environment assessment using Query builder

               BusinessObjects Environment Cleanup using Query builder

               BusinessObjects Query builder – What's New in BI 4.0