Currently customer can modify the columns 1 by 1 using "Rename" option on column. Customer is looking for an option to rename multiple columns at a time like replacing "_" with " " in the column names, making the names Proper Case, etc.
@Pushpa-Oracle If you have examples of common reasons for the renames in addition to the replacing of underscores with spaces, that would help us with requirements. For example, do they also lowercase, or proper case column names? what else. thanks.
Creating a dataset from a DB table should have the same automatic column renaming as the Semantic Modeler and Client tool. In those tools you can set preferences to remove underscores, change to lower case, capitalize first letter of each word.
This makes the dataset and visualizations more easily consumed by the business analyst instead of seeing database column names.
We need to automate the tedious task of relabeling every column name when creating a dataset from a database table.
We are happy to announce this feature has been delivered with the added benefit of AI Assisted beautification. Please review my blog post: https://blogs.oracle.com/analytics/post/aidriven-column-names-where-human-readability-meets-ai-understanding it includes a link to an e2e video flow as well at the end.
@Luis E. Rivas -Oracle Since you marked this Idea as "Delivered" pointing to new feature launched in OAC September 2025 release : "LLM-Based Column Name Recommendations in Oracle Analytics" I would like to ask : Is this feature (as it relies on LLM) going to be available in OAS as well? My guess is that the answer will be no. In this case this Idea cannot be marked as delivered and required feature "Option to rename multiple column names of Dataset" should be elaborated for both "flavor" of Oracle Analytics - thus OAC and OAS as well. Thanks.
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…
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…
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.…
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…
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.
