Is there a way to change the DV Project column name(Using subject area as Source) when the presentation column name is changed/renamed in RPD ? (Doc ID 2585831.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Symptoms

When a column name or table name or subject area name  is changed/Renamed in the RPD subject area . A general procedure is to open the catalog using catalog manager  in offline/online mode and use the option "Search and Replace XML " in order to replace the table name or column name or subject area name changes which are referenced in the analysis and dashboards.

When doing the search and replace XML for the changed column/table names the Analysis in OBIEE works fine with no issues. The issue persist for the DV projects where the source( Data connection ) of the project is from the BI subject area. The  "search and replace XML" option does not work for the Data Visualization projects .

Changes

 Rename column/table names or subject area name in the Repository  - Presentation layer.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.