Skip to Content
0
Sep 04, 2019 at 01:38 PM

How to find all documents that uses a OLAP connection

252 Views

How can I e.g. using AdminTools (Query Builder) to get a list of reports that uses a specific OLAP connection?

I know I can get some of the information here:

SELECT * FROM CI_APPOBJECTS WHERE SI_KIND = 'CommonConnection'

And I know I can query each individual report like this:

SELECT SI_NAME, SI_DOC_COMMON_CONNECTION FROM CI_INFOOBJECTS WHERE SI_NAME='report_name'

But I can't figure out how to get a complete list of documents by name, that uses a speciffic OLAP connection

[Unless I use the BI Platform Support Tool, which unfortunately is not at option here]