Keep column reference in Presentation layer when adding folders

Question

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

Gianni Ceresa · Answer

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.