OBIEE 11G Rename Objects Using the Rename Wizard

1 . Select Tools > Utilities > Rename Wizard > Execute to open the Rename Wizard.
Screenshot for Step
 
2 . In the Select Objects screen, click Business Model and Mapping in the middle pane.
Screenshot for Step

3 . Expand the Sample Sales business model.
Screenshot for Step

4 . Expand the D1 Time logical table.
Screenshot for Step

5 . Use Shift+click to select all of the logical columns except for the column you already renamed, Beg of Mth Wid.
Screenshot for Step

6 . Click Add to add the columns to the right pane.
Screenshot for Step

7 . Repeat the steps for the three remaining logical tables so that all logical columns from the Sample Sales business model are added to the right pane. Only the columns from F1 Revenue are shown in the screenshot.
Screenshot for Step

8 . Click Next to move to the Select Types screen.
Screenshot for Step
Notice that Logical Column is selected. If you had selected other object types, such as logical tables, the type would have appeared here.

9 . Click Next to open the Select Rules screen.
Screenshot for Step

10 . In the Select Rules screen, select All text lowercase and click Add to add the rule to the lower pane.
Screenshot for Step

11 . Add the rule Change each occurrence of '_' into a space.
Screenshot for Step

12 . Add the rule First letter of each word capital.
Screenshot for Step

13 . Click Next to open the Finish screen. Verify that all logical columns will be named according to the rename rules you selected.
Screenshot for Step

14 . Click Finish.

15 . In the Business Model and Mapping layer, expand the logical tables and confirm that all logical columns have been renamed as expected. The screenshot shows only the columns in D1 Time.
Screenshot for Step

16 . In the Physical layer, expand the alias tables and confirm that all physical columns have not been renamed. The point here is you can change object names in the BMM layer without impacting object names in the Physical layer. When logical objects are renamed, the relationships between logical objects and physical objects are maintained by the logical column to physical column mappings.
Screenshot for Step

No comments:

Post a Comment

Popular Posts