Automatically Rename Logical Layer Objects

Use the Automatically rename objects when added to logical layer user preference to automatically rename the physical tables and columns that you add to the logical layer.

Note:

Setting Automatically rename objects when added to logical layer preferences applies to all semantic models that you work with, not just the semantic model that was open when you set this preference.

When you select this option, you also specify how you want the tables and column renamed. For example, choose the Change each underscore(_) to a space rename action and then choose the All lowercase rename action. So now when you drag SAMP_CUSTOMER_D to the logical layer, its name is changed to samp customer d.

By default the Automatically rename objects when added to logical layer user preference is set to off. So when you drag and drop tables and columns from the physical layer to the logical layer, the resulting logical table and column names match the corresponding physical table and column names.

  1. On the Home page, click Navigator and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Page Menu and then click Preferences.
  4. In the Users Preferences dialog box, scroll to Logical Layer and then click the Automatically rename objects when added to logical layer checkbox to enable the user preference.
  5. Select which physical objects you want to automatically rename when you drag them to the logical layer.
  6. In Rename Actions, click Add rules and select a rule.
  7. Optional: Click Add rules Add rules icon to add another rule.
  8. Click Apply.