nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Sort by column by direct query in obiee

User_BKO8T

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?

Find more posts tagged with

OBIEE

Accepted answers

Gianni Ceresa

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

All comments

[Deleted User]

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

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

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

Gianni Ceresa

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