Skip to Content
0

Identify Webi report by SQL query

Apr 26, 2017 at 08:37 PM

80

avatar image

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...

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

2 Answers

Mohanraj Periyasamy Apr 27, 2017 at 07:08 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Jawahar Konduru Apr 26, 2017 at 08:46 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded