OBIEE 11G Rename Presentation Columns

1. In the Presentation layer, expand the Products presentation table.
Screenshot for Step
 
2. Double-click the Lob presentation column to open the Presentation Column dialog box. On the General tab notice that "Use Logical Column Name" is selected. When you drag a logical column to a presentation table, the resulting presentation column inherits the logical column name by default. In this example the Lob presentation column inherits the name of the logical column "Sample Sales"."D2 Product"."Lob".
Screenshot for Step

3 . Deselect Use Logical Column Name. The Name field is now editable.
Screenshot for Step
4 . Enter Line of Business in the Name field.
Screenshot for Step
5 . Click OK to close the Presentation Column dialog box. Notice that the presentation column name is now changed to Line of Business in the Presentation layer.
Screenshot for Step
6 . In the BMM layer, expand D2 Product. Notice that the Lob logical column name is not changed. The point here is you can change object names in the Presentation layer without impacting object names in the BMM or Physical layers.
Screenshot for Step
7 . In the BMM layer, rename the Prod Dsc logical column to Product. Notice that the name change is inherited by the corresponding presentation column.
Screenshot for Step
8 . Make the following name changes to logical objects in the BMM layer so that the names of the corresponding presentation columns are also changed:
For the D3 Customer logical table:
Change Cust Key to Customer Number.
Change Name to Customer Name.
Screenshot for Step
9 . Confirm that the corresponding presentation column names are changed.
Screenshot for Step

No comments:

Post a Comment

Popular Posts