OBIEE 12c: Direct Database Request Report Does Not Show Correct Number Of Rows
(Doc ID 2699242.1)
Last updated on AUGUST 10, 2020
Applies to:Business Intelligence Server Enterprise Edition - Version 188.8.131.52.0 and later
Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.0 and later
Oracle Exalytics Software - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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 18.104.22.168
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
Upgraded to 22.214.171.124
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