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   

[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

[former_member182521]

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. :lol:

[jyotijain]

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 ?

[Former Member]

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?

[arpangupta]

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

 

[arpangupta]

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

 

[arpangupta]

manikandan.elumalai2 Hi Mani,

Is there any way out for this..?

Regards,

Arpan

 

[Former Member]

Just to bump this topic...

 

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

 

[former_member189164]

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

[former_member204732]

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

[kevin_ray2]

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?

[Markus_Schueco]

Dear all,

with the Query Builder it is possible to obtain information about when and how often an application was used (time stamp) ? 

Regards, Markus