Skip to Content

Identify Webi report by SQL query

Hi,

our DBA team has perfomance issues in DWH(Oracle DB).

They identified SQL query (text) which load system perfomance. This SQL text (select big table) comes from SAP BI platform server.

We have many Webi reports and universes.

Is it possible to identify Webi report by SQL query?

BI 4.1 SP2, Audit enabled (default events).

Thanks...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 27, 2017 at 07:08 AM

    Have you tried using BEGIN_SQL or END_SQL in universe? Basically you could add something like the below for BEGIN_SQL

    /*Universe: eFashion , UserID: @variable('BOUSER'), Document: @variable('DOCNAME') */

    Every SQL generated would have the user and document name attached to it. This would help tracking sql back to the report and user

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26, 2017 at 08:46 PM

    You can use some 3rd party tools like 360 by GB & Smith to extract the SQL.

    Add comment
    10|10000 characters needed characters exceeded