Presentation Layer Alias

Alias in Presentation Layer

OBIEE automatically create Alias in presentation layer to avoid report failure whenever a source column or source table name changes in the repository.

How it works

Let say you have rename a presentation column/table in presentation catalog. How will OBIEE respond when you run the report that contain original column?

OBIEE automatically create an Alias in presentation layer when column name is changed, to avoid report failure that reference the original column. You can see the created aliases in the Aliases tab.

As you can see in below image that when we change the name of table name from"Products" to "Products1" an alias is automatically created in  "Aliases tab".

However,In Answers only the name defined in the presentation layer will be shown.

Physical Alias

Please Share your Feedback and keep me posted.

Have a nice day.:)

Thanks