Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member182521
Active Contributor

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   


35 Comments
Labels in this area