Categories
Sort by column by direct query in obiee
When creating a report by direct query, the arrows to order the table itself by a specific column do not appear next to the name of each column.
On the other hand, when creating the report by subject area, the arrows appear by default.
Is there any way that, by direct query, you can see the sort arrows?
Best Answer
-
This is a 2 years old discussion migrated from a different forum that was abandoned by OP.
If there are question on a similar, related, topic please post a new question (with all the required details like product name and version etc.).
1
Answers
-
By choosing a direct DB request you're choosing to ignore 99% of the platform's functionality.
The correct usage is either Subject Areas or external datasets via DV.
0 -
In Oracle Business Intelligence 10g it is possible to sort direct sql results, In Oracle Analytics Server its not possible. If there is no sorting option, it must be get results direct from direct sql
0 -
@User_BKO8T As this is DDR request ,please see if you could incorporate order by clause in the query and sort it at the query itself.
0
