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.

Semantic Modeler can use one or both of these methods to rename logical columns:

• Generative AI service - The logical column rename uses a large language model (LLM) that is registered and activated in your Oracle Analytics environment. Your administrator registers and activates the gen AI service, and when activated, you can't exclude it when you run the column rename process.

• Semantic model rename actions - 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.

If the generative AI service is enabled and rename object actions are declared, Semantic Modeler runs the generative AI service first to provide business-friendly names and then applies the specified object actions to the names.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical Layer .
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 .
6. In Suggest Column Names, deselect any columns you don't want to rename. Click Suggest Names.
7. Click a column's suggested new name to modify it.
   
   
   Description of the illustration suggest_col_names.jpg
   
   
8. Click Apply, and then click Save.