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
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,
FROM CI_APPOBJECTS WHERE SI_KIND ='AAD.AnalysisApplication_Bookmark'
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