OBIEE 11G Check the Query Log
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