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 AI and Analytics

Child Item

Sort Order

User_Q8Z9U

Hello,

We noticed that the sort order in our faw visuals/ adw queries is in ASCII order. Per our business use case, it should be alphabetical order. See current sort format in our graph.

1- Legend_SortOrder_ASCII.png

2-Legend_SortOrder_ASCII-SORTBY_Option.png

Find more posts tagged with

Planned

FDI

ADW

Status: Planned

Comments

Gabby Rubin-Oracle

SQL and SQL-based tools are usually sorted based on ASCII order, where the uppercase letters come before the lowercase letters. The solution is usually to create a calculated field that uniforms the case and is used as a sort key. A feature coming shortly to workbooks will allow you to use a sort key in visualization while presenting only the 'display value' with the correct case (i.e. hidden columns).

Gabby Rubin-Oracle

Hidden columns are currently planned for the January 2025 update.

Top Leaders

Tarik Branković 45

User_IG5IB 32

Michal Zima 32

Siva Pratap Nellipudi-Oracle 29

SantoshChandrasekaran 18

Top Ideas

Increasing Report Results limit from 5000 to the full report results data set
OAS Classic Report Results display the first 5000 rows and the OAS user needs to click the next button for the next 5000 rows and so on. The 5000 row limit is the maximum allowed to be setup in the OAS Console. OBIEE Report Results support display of the entire report results data set. Our users would like this feature in…
Provide proactive notification of bug fixes/patches that change API response behavior, before deploy
Background We recently identified an issue through an inconsistency in the number of records returned in an API response. This allowed us to notice, after the fact, that a fix had been applied that changed the behavior of an existing API. Problem We understand that information about resolved bugs is eventually made…
Granular permission for Session and Query Logs (Manage Sessions) independent of BI Service Administr
We need a way for non-admin users to view the backend/physical SQL queries executed by reports (via Session and Query Logs) without granting them full administrator access. OAC's custom Application Role model (Console > Roles and Permissions) allows selecting fine-grained permissions instead of assigning predefined roles.…
OAS Certified Data Source (DB2) Enhancement Request
Customer would like to request that IBM DB2 12.x be added as a supported data source for Oracle Analytics Server. They hope that it will be included as a certified and supported data source in the next(Year 2027 ) OAS release. Background: The customer is currently operating a reporting and analysis platform using Oracle…
MCP restriction/ tool restrictions to OAC user groups
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.