Auto-Generation of Descriptor ID Columns for Double Columns

In Oracle Analytics, when you create datasets based on subject areas, learn how to work with double columns.

When you add a double column to the selected list in Edit Definition, Oracle Analytics automatically creates the supporting descriptor ID column required by the double column.

When a double column is added:

• A corresponding descriptor ID column is automatically added to the input definition.
• The generated descriptor ID column uses a SQL expression based on the DESCRIPTOR_IDOF function.
• The generated column displays the Enter Logic SQL UI and has an LSQL alias predefined by the system.
• A data preparation step is automatically generated to set the descriptor ID property of the user-selected double column to the system-generated DESCRIPTOR_IDOF column.

You can remove an auto-generated double column in two ways:

• Delete the auto-generated data preparation step first, then delete or hide the associated descriptor column.
• Go to Edit Definition, remove the SQL expression for the descriptor ID column, and click OK. This removes the descriptor logic associated with the auto-generated double column.