Oracle Analytics Cloud and Server Idea Lab

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

Option to rename multiple column names of Dataset

Delivered
101
Views
4
Comments

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.

7
7 votes

Delivered · Last Updated

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-understandingError it includes a link to an e2e video flow as well at the end.

Comments

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

  • Norma Penson-Oracle
    Norma Penson-Oracle Rank 1 - Community Starter

    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.

  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

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