Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Sort by column by direct query in obiee

Closed
61
Views
4
Comments
User_BKO8T
User_BKO8T Rank 2 - Community Beginner
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?

Tagged:

Best Answer

  • Gianni Ceresa
    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.).

Answers

  • [Deleted User]
    [Deleted User] Rank 10 - Analytics Guru

    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.

  • User_G9NLS
    User_G9NLS Rank 1 - Community Starter

    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

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics Lead

    @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.

This discussion has been closed.