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

Dear Folks,

Again this is the continuation of my previous blogs on Query builder.

BusinessObjects Query builder queries

BusinessObjects Query builder queries - Part II

BusinessObjects Query builder queries - Part III

Have listed few more interesting queries below

To list all the servers and their status with server category

            SELECT SI_NAME, SI_SERVER_IS_ALIVE, SI_DISABLED, SI_SERVER_KIND,

            SI_FRIENDLY_NAME, SI_EXPECTED_RUN_STATE FROM CI_SYSTEMOBJECTS

            WHERE SI_KIND='SERVER'

    

            Below are the possible values for SI_EXPECTED_RUN_STATE object

                -1 ->  Server is currently in an invalid state due to a configuration error.

                0  ->  The expected state of the server is stopped.

                1  ->  The expected state of the server is running.

                2  ->  The expected state of the server is restarting.

                3  ->  The server is not being managed by the Server Intelligence Agent.

                4  ->  The expected state of the server is immediate shutdown.

To list all hosted services for each server

           SELECT SI_ID, SI_NAME, SI_HOSTED_SERVICES FROM CI_SYSTEMOBJECTS WHERE SI_KIND='SERVER'

To list all the metrics description

           SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND='MetricDescriptions'

To list all the program objects without their instances

           SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND='PROGRAM' AND SI_INSTANCE=0

To list all the personal and corporate category details of the report

           SELECT SI_ID, SI_NAME, SI_PERSONAL_CATEGORIES, SI_CORPORATE_CATEGORIES

           FROM CI_INFOOBJECTS WHERE SI_KIND='WEBI' AND SI_NAME = <Name of the Report>

Relationship queries

To list the Usergroups associated with a particular User

           Select SI_ID, SI_NAME From CI_SYSTEMOBJECTS Where PARENTS("SI_NAME='UserGroup-User'","SI_NAME='Administrator'")

To list the Universes associated with a particular Data connection

           Select SI_ID,SI_NAME,SI_KIND From CI_APPOBJECTS

           where CHILDREN("SI_NAME='DataConnection-Universe'","SI_NAME='efashion-webi'")

           The list of relationship objects and their relationship types are given below

              

               Relationship Objects           Relationship Types

               Profile-Principal                   ->   PARENT-CHILDREN

               DataConnection-Universe  ->  CHILD-PARENT

               Category-Document            ->  PARENT-CHILDREN

               User-Inbox                            ->  PARENT-CHILDREN

               Webi-Universe                      ->  PARENT-CHILDREN

               User-Favorites                      ->  PARENT-CHILDREN

               UserGroup-User                   ->  PARENT-CHILDREN

               Universe(Core)-Universe    ->  CHILD-PARENTS

               EnterpriseData-Flash           ->  CHILD-PARENTS

               Universe-UserGroup            ->  PARENT-CHILDREN

               CustomRole-Object              ->  CHILD-PARENTS

               User-PersonalCategory        ->  PARENT-CHILDREN

Hope you find this Interesting. 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   

67 Comments
Labels in this area