Keep column reference in Presentation layer when adding folders — Oracle Analytics

Oracle Analytics Cloud and Server

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

Keep column reference in Presentation layer when adding folders

Received Response
1
Views
1
Comments
2981486
2981486 Rank 3 - Community Apprentice

Hello,

We have the following structure created in the presentation layer in the RPD:

Facts

--Measure1

--Measure2

--Measure3

Dimension

--Attribute1

--Attribute2

We have created several analysis using this structure.

Now we want to add sub folders using "Child Presentation Tables" in the presentation layer to better organize the attributes.

Facts

--Folder1

----Measure1

----Measure2

--Folder2

----Measure 3

The problem in doing this is that our existing analysis wont work anymore because they lose reference to the columns in the RPD that were now moved into sub folders. Is there a way to use aliases to reference the columns in the newly created sub folders?

Thanks!

Joao

Answers

  • Hi,

    Why don't you just do a search/replace in the catalog to replace all the old references with the new column name?

    Because the alias in the Admin tool is more for name changes (typos etc.) but doesn't really contains the parent of the column, so it will not be able to keep the old "parent" name.