Oracle Analytics Cloud and Server Idea Lab

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

DV Admin Functionality - Replace the alias of a column with its current name

Needs Votes
62
Views
2
Comments

Organization Name

GSO

Description

When a column name is changed in the RPD this is what happens in a DV Project:

1) the change is reflected in the Subject Area (Data pane)

2) the change is not reflected in the calculations and expression filters where the column is used (an alias is used instead)

3) the change is not reflected in the objects (visualizations and filters) where that column was added before (an alias is used instead)

 

We need the possibility to replace the alias of a column with its current name at the server level (all projects in the DV Catalog).

Use Case and Business Need

Column names are frequently changed in the RPD.

The effect is that their aliases are being used in the Projects where they were used before the name change.

It would be really helpful to have the possibility to replace the alias of a column with its current name at the server level.

I'm thinking at an option in the Console tab that will be available only for Administrators.

Original Idea Number: 63efd64284

Current Column Name vs Alias.png

6
6 votes

Needs Votes · Last Updated

Comments

  • jagadeesh ramasamy
    jagadeesh ramasamy Rank 3 - Community Apprentice

    Following

  • Pradip Pithiya
    Pradip Pithiya Rank 1 - Community Starter

    The current functionality per-supposes that the folder and field names will be correct first time, every time.

    However, that is invariably not the case, and tweaks are required for naming consistency, etc.

    Currently, if any folder and field name changes are done, then DV Developers need to update those projects that use the changed folders and fields manually.