to know the OLAP connection of the report

[Former Member]

Dear Team,

Please help me here to find the connection name of a report. Here I have created around 10 connections for around 200 reports.

All the reports built on the top of Bex queries. I would like to know which connection belongs to which report .Through which connection, the data coming from bex query.

Thank you in advance.

Warm Regards,

Mohan.

[rishabh_singhania]

Hi Mohan,

Have you tried using query builder.

I guess we can get the complete detail using the following query:

SELECT * FROM CI_APPOBJECTS, CI_INFOOBJECTS WHERE PARENTS("SI_NAME='WEBI-UNIVERSE'", "CHILDREN('SI_NAME=''DATACONNECTION-UNIVERSE'' ', 'SI_NAME=''TEST'' ')")  AND SI_KIND='WEBI'

Here just replace test with your connection name.

there is a  excelent blog series regarding query builder which you can refer:

Hope it helps.

Thanks

RS