Skip to Content
0

Which BO Workbooks use my BEx-Query?

Sep 28, 2017 at 10:47 AM

43

avatar image
Former Member

Hello

is it possible to get a report of BO workbooks (we are on 4.1) that use certain BEx queries from our BW 7.4?

The BW system is connected via OLAP-Connection.

Best regards

Moritz

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Shwetha Bangera Sep 28, 2017 at 12:35 PM
0
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Shwetha,

I am also struggling to get this information for Analysis workbooks. But the link which you mentioned is for WEBI. I am running the below script

SELECT * FROM CI_INFOOBJECTS WHERE si_kind="AO.WORKBOOK" and si_name='<workbook name on BI platform>'

The output hence is not having any reference to Bex queries used in workbook (like number of Bex queries used, Name / ID of Bex queries).

Regards,

Arpan

0