Automatically Rename Logical Columns

You can choose a logical table and automatically rename all or selected logical columns to business-friendly names.

Renaming columns in logical tables rather than presentation tables is a best practice for model maintainability. Using friendly names for logical columns ensures reuse in multiple subject areas and that the names persist even when you need to delete and re-create subject areas to incorporate changes to your business model.

The logical column rename applies the rename actions you specified in the Automatically rename objects when added to the logical layer user preference. For example, Change each underscore (_) to a space. By default, this option is disabled in user preferences. See Automatically Rename Logical Layer Objects.


Description of rename_actions_rules.jpg follows
Description of the illustration rename_actions_rules.jpg

  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Logical Layer Logical layer icon.
  4. In the Logical Layer pane, browse for and double-click the table with the column you want to rename.
  5. In the logical table, click the Columns tab and click Rename Columns Rename column icon.
  6. In Suggest Column Names, deselect any columns you don't want to rename. Click Suggest Names.
  7. Click Apply, and then click Save.