Skip to Content
avatar image
Former Member

Which BO Workbooks use my BEx-Query?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 28, 2017 at 12:35 PM
    Add comment
    10|10000 characters needed characters exceeded

    • 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