Skip to Content

BusinessObjects Query builder – Exploring Lumira & Design studio Objects

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   

7 Comments
You must be Logged on to comment or reply to a post.
  • Hi Manikandan,

    thanks for the introduction on how to query on the “new” BO application documents on the BI plattform.

    One query I until never was successful with (I’m a beginner), was to get the query name (BW query) used in the application documents. Those can be 1 or more per document and it could help us, track which queries are currently actively used in case of changes.

    For your understanding: We give the user the whole BW system as an OLAP connection on the BI plattform and the authorizations are restricted only in the BW itself, so we only have one OLAP connection in the system overall.

    It would be great if there’s a way to query on this.

    Thanks in advance,

    Philipp

    • Hi Philipp,

      Let me take a look at your scenario and come back to you once I have a valid answer from my side. I think I should go with another blog in Query builder with SAP datasources and connection. Thanks for your Idea. ­čść

  • Hi Manikandan,

    Thanks for introduction on how to query on the “new” BO application documents on BI platform.

    One query, we are trying to find  list of all connections and universes used in Design studio Applications based on Universe as data source . Is there any way that we can find these details ?

  • Hi Manikandan,

    This is great document. Thanks.

    Question – AFO workbook – how to get their base BEX query information? For WEBI, we’ve to check in┬áSI_WEBI_DOC_PROPERTIES (XML) and get it from┬áDSNAME. But this is not available for AFO workbook.

    Is there any way to get this?

  • Hi Mani,

    i have a list of Bex queries, I want to know which Bex query is used in which analysis-workbook. I know Its possible in BW with Bex workbooks with the help of tables.

    Regards,

    Arpan

     

  • Hi Mani,

    i have a list of Bex queries, I want to know which Bex query is used in which analysis-workbook. I know Its possible in BW with Bex workbooks with the help of tables. Can I get the list of analysis-workbooks in BO where a Bex query is being used?

    Regards,

    Arpan