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]