Friday, May 24, 2013

[OBIEE 11g] Check The Query Log


 


OBIEE 11G Check the Query Log




1 .
In this set of steps you use another method to check the query log. Click the Administration link in the upper right.


 
2 .
Click OK when you are asked "are you sure you want to navigate away from this page?" 



3 .
On the Administration page, under Session Management, select Manage Sessions.




4.
In the Cursor Cache section, locate your query and select View Log




5 .
Your log entry should look similar to the screenshot.



Note that the division of Revenue by Units is calculated in the outer query block (D1.c2 / nullif ( D1.c1, 0) as c3 in this example). Because you defined the Actual Unit Price calculation using logical columns, the SUM aggregation rule is applied to the Revenue and Units columns first and then the division is calculated.

6 .
Click the browser back button to return to the Administration screen.

7 .

Sign out of Oracle BI. 





No comments:

Post a Comment