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

Disable automatic sorting when uploading data through a dataset

Joshua Co

We have a file and upload the data in FAW through a dataset. Faw automatically sorts the data when creating a workbook

Find more posts tagged with

Declined

Status: Declined

Comments

Bret Grinslade - Oracle Analytics-Oracle

What is the goal here? Sort order is often defined at query time. What do you hope to know or do based on "uploaded" sort order?

Joshua Co

Hello, we need to be able to download the data based on how it was uploaded. The order of which it was downloaded is sensitive for our vendor reports. Using a VLOOKUP can cause errors when extracting the data.

Bret Grinslade - Oracle Analytics-Oracle

The purpose of upload is to use the data in FAW/OAC and the purpose of download is to able to export data from the system. There is no VLOOKUP in OAC -- however you can create joins or blend data between files or tables. FAW and OAC are not file storage system. I would recommend you use another tool such as Oracle Content Management or similar 3rd party product for file storage.

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.