Change the Column Type of Measures and Attributes

When you edit a dataset in the transform editor, you can use recommendations provided by Oracle Analytics to change the column type of measures and attributes. For example, if the semantic profiler initially identifies a column with numeric IDs such as 1078220 as a measure, you can change the column to an attribute.

1. On the Home page, open a dataset or workbook.
   • Hover over the dataset, click Actions, and then select Open. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
   • Hover over the workbook that contains the dataset, click Actions, then select Open, then click Data. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.

   Note:

   Oracle Analytics displays a Data Diagram for single-table datasets or a Join Diagram for multi-table datasets.
2. Click Review auto Treat-as recommendations ().
3. Select columns to change from the type specified under Current to the type specified under New.
   
   
   Description of the illustration treat-setting.png
   
   
4. Click Apply.