Skip to Content
Author's profile photo Manikandan Elumalai

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   

Assigned tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Manikandan Elumalai
      Manikandan Elumalai
      Blog Post Author

      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. ­čść

      Author's profile photo Jyoti Jain
      Jyoti Jain

      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 ?

      Author's profile photo Gaurav Deshpande
      Gaurav Deshpande

      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?

      Author's profile photo Arpan Gupta
      Arpan Gupta

      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

       

      Author's profile photo Arpan Gupta
      Arpan Gupta

      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

       

      Author's profile photo Arpan Gupta
      Arpan Gupta

      Manikandan Elumalai Hi Mani,

      Is there any way out for this..?

      Regards,

      Arpan

       

      Author's profile photo Iksit Gadhia
      Iksit Gadhia

      Just to bump this topic...

       

      Be great if the community can share how to get Bex query <-> Analysis Office Workbook mapping.

       

      Author's profile photo Gopal Nagothu
      Gopal Nagothu

      Not sure in BI 4.2 but in BI 4.1, CMS data doesn't maintain the query details for AO workbooks.

      Author's profile photo D D
      D D

      Dear Manikandan,

       

      Is possible to get statistic on the report usage ?

      Could we know who executed the lumira report and when with the query builder tool ?

       

      Thanks

      Author's profile photo Kevin Ray
      Kevin Ray

      So I tried the

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

      on our server and it returned zero objects, even though I know we have a few Lumira (Lumx Document) dashboards.  Any idea why I am not getting any results?