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.
- 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.
- Click Review auto Treat-as recommendations ().
- Select columns to change from the type specified under Current to the type specified under New.
- Click Apply.