BusinessObjects Query builder - Exploring Lumira & Design studio Objects

[former_member182521]

I am just sharing my experience while doing impact analysis for one of my BI 4.1 assessment in a BusinessObjects environment that is running exclusively for SAP BusinessObjects Design Studio and SAP Lumira applications. Here are few of my queries that could be handy for those who are doing similar type of activity. Here you go

     SAP Lumira

     To get the list of Lumira Dashboards published in to BI Platform

     SELECT SI_ID,SI_NAME,SI_KIND,SI_FILES FROM CI_INFOOBJECTS WHERE SI_KIND='VISILums' AND SI_INSTANCE=0

     For Scheduled instances of the Lumira documents

     SELECT SI_ID,SI_NAME,SI_KIND,SI_FILES,SI_PARENTID FROM CI_INFOOBJECTS WHERE SI_KIND='VISILums' AND SI_INSTANCE=1

     To get the Universes and Managed connections used by Lumira documents

     SELECT SI_ID,SI_NAME,SI_LUMS_UNIVERSES,SI_MANAGED_CONNECTION FROM CI_INFOOBJECTS WHERE SI_KIND='VISILums'

     SAP Design Studio

     To get the list of Design Studio dashboards

     SELECT SI_ID,SI_NAME,SI_KIND,SI_FILES FROM CI_INFOOBJECTS WHERE SI_KIND='AAD.AnalysisApplication'

     To get the Bookmarks defined in Design studio Application

     SELECT * FROM CI_APPOBJECTS WHERE SI_KIND ='AAD.AnalysisApplication_Bookmark'

     To get the list of Design studio dashboards with atleast one Bookmark

     SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND='AAD.AnalysisApplication' and SI_BOOKMARKS.SI_TOTAL>0

     To get the bookmark metrics of the individual bookmark along with associated Analysis applications

     SELECT SI_ID, SI_NAME, SI_ANALYSISAPPLICATIONS, BOOKMARK_LAST_VIEW_DATE,BOOKMARK_VIEW_COUNT,

     BOOKMARK_THEME,BOOKMARK_NUMBER_OF_QUERIES, BOOKMARK_NUMBER_OF_SYSTEMS,BOOKMARK_COMPONENT_LIST

     FROM CI_APPOBJECTS WHERE SI_KIND ='AAD.AnalysisApplication_Bookmark'

Analysis Office

     To get the list of Analysis Application for Office docs

     SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND='AO.Workbook'

Hope this is interesting. If you do have any specific requirement, please dont hesitate to comment here. I will try my best to bring the required information for you. Keep reading & Happy blogging!

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