Oracle Analytics Cloud and Server Idea Lab

Products Banner

Find and Replace Subject Area Columns in DV

Submitted
54
Views
2
Comments

Organization Name

GSO

Description

For Admins

Find all the DV Projects where a Subject Area Column is being used.

Offer the possibility to export the list.

 

Replace a Subject Area column with another Subject Area column (this includes the request raised on https://cloudcustomerconnect.oracle.com/posts/63efd64284).

Offer the possibility to select the DV Projects (All or Selected ones) where the replace will be performed.

 

For Developers

In a DV Project, find all the objects (visualizations, calculations, filters) where a Subject Area Column is being used.

Replace this Subject Area Column with another Subject Area Column.

Offer the possibility to select the objects (All or Selected ones) where the replace will be performed.

Use Case and Business Need

For Admins

FIND

The values of a column are changed in the Database.

The OLD values are used in Calculations (hardcodings) and Filters.

We want to announce our DV Developers about this change so we need to create a list with the DV Projects where this column is being used.

The Find Functionality will allow us to generate this list and export it.

 

REPLACE

A column name was changed in the RPD.

Its ALIAS is being used in the calculations, visualizations and filters where the column was used before the name change.

We want to replace the ALIAS (OLD NAME) with the NEW NAME in all these objects.

 

 

For Developers

Scenario 1

A DV Developer was informed that the values of a column were changed in the Database.

The OLD values are used in one of his/her DV Projects Calculations (hardcodings) and Filters.

He/she wants to know which are the Calculations and Filters that are using the OLD values.

With the FIND functionality the Developer will be able to generate this list.

(The possibility to REPLACE the OLD Values directly from the Find menu will be an extra valuable functionality)

 

Scenario 2

A DV Developer wants to replace Measure X with Measure Y in some of his visualizations.

With the FIND functionality the Developer will be able to generate this list of Visualizations where Measure X is being used.

With the REPLACE functionality the Developer will be able to replace Measure X with Measure Y (in selected visualizations).

More details

This functionality can include the request performed in https://cloudcustomerconnect.oracle.com/posts/63efd64284

Original Idea Number: fee1a8e7db

7
7 votes

Submitted · Last Updated

Comments

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

  • The way to do it today is by changing the project JSON, you just need to be careful when doing find and replace on the file as any formatting issues will be hard to troubleshoot (in short, backup your project before doing that).