OBIEE 12c: Direct Database Request Report Does Not Show Correct Number Of Rows
(Doc ID 2699242.1)
Last updated on JULY 18, 2023
Applies to:
Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 and laterBusiness Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Oracle Exalytics Software - Version 2.0.0.1.0 and later
Information in this document applies to any platform.
Symptoms
Direct Database Request report does not show correct number or rows
Have a report based in Direct Database Request. The Table view has a Sections field. When you change the layout and move a column to Section field ,DDR is not showing the results.
This worked fine in OBIEE 11g and 12.2.1.0
Steps to Reproduce:
1. Create a DDR report (Direct Database report) Using the below query
select table_name, tablespace_name, initial_extent, next_extent, degree from all_tables;
2. Click on the results tab.You can see the results correctly with the correct rows.
3. Edit the Table >> From the Layout >> Move the TABLESPACE_NAME column in to the Sections. It will show some less records.
4.In this test case >> In place of USERS place , it should display more than two records which is wrong
Changes
Upgraded to 12.2.1.4
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |