Ability to define whether a field is an attribute or measure in OAC workbook

Jon Priest

Currently there is no way to manually define whether or not a field should be treated as a measure or attribute in an OAC workbook. Which leads to a lot of issues when using custom calculation in the workbook, (e.g case statements that results in numeric outputs needing to be aggregated). This is feature which was available in OBIEE but not in OAC. This is a foundation feature in my opinion that should be added.

This formula results in an attribute:

There are no options to aggregate in the same way that a normal data set field would when using custom calculations

As you can see in the below example, this aggregation option is present for an attribute column that is not a result of a custom calculation:

Jon Priest

For example you used to be able to treat columns as attributes, but we would also need to be able to treat something defined as a 'attribute' as an 'measure'.