How we can view the WebI report SQL query?

building semantic layer
1

Can anybody explain, how can we view the WebI reports SQL query??

NirmalKumar.S (BOB member since 2006-01-13)

2

I think we have option only in Fullclient reports and more over they r in XIR2.

Rajasekar :india: (BOB member since 2004-07-16)

3

If I want to view means? How can I?
I need to retrieve from webI reports through BO?
Is it possible??

Thanks for quick reply

NirmalKumar.S (BOB member since 2006-01-13)

4

Can you insert a cell and use the function =DataProviderSQL()???

ie if you have a dataprovider called Query 1 then it would be

=DataProviderSQL(“Query 1”)???

Steve

snakeboy :uk: (BOB member since 2003-12-02)

5

Which version are you on?

In 5.x and 6.5 SPx, you can turn on “View SQL” in Supervisor…

Select a user you want to view the SQL with, click on “Configuration” tab, double click “WebIntelligence”, then click on “Query and Web Panel”. There is a value, “View SQL” - that needs to be enabled.

Log in as that user, in 6.5, use the java query panel, there will be a button with “sql” on it… Click that and it will display the SQL used for the query. The query will show the prompt text and such…

The other way would be to monitor the sql at the database - we trap actual sql ran and start - end time for all queries ran and insert into another DB. We analyze - to find queries that take longer to run etc… DBA support is required though.

Patrick

Patrick McDonough (BOB member since 2002-08-20)

6

I don’t remember how it was in the previous versions but in 6.5 you can edit the report and in the Edit Query Panel there is a SQL button.

Kashif Saeed :pakistan: (BOB member since 2004-06-02)