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
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
Manikandan Elumalai Hi Mani,
Is there any way out for this..?
Regards,
Arpan
Just to bump this topic...
Be great if the community can share how to get Bex query <-> Analysis Office Workbook mapping.
Not sure in BI 4.2 but in BI 4.1, CMS data doesn't maintain the query details for AO workbooks.
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
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?