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, hover over a dataset that you own, click Actions, and then select Open.
   If the dataset contains a single table, you'll see the transform editor. If the dataset contains multiple tables, you'll see the Join Diagram. In the Join Diagram, right-click a data source and click Open to display the transform editor.
   

   
   Description of the illustration data-preparation-toggle-options.png

   
   
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.