My Oracle Support Banner

Adding a Calculated Column to a Graph Visualization in an Oracle Analytics Project Fails with: Only Measure Data is Allowed (Doc ID 2811372.1)

Last updated on OCTOBER 01, 2021

Applies to:

Oracle Analytics Cloud - Version 106.2.0 and later
Information in this document applies to any platform.


On Oracle Analytics Cloud (OAC) ...

A Project is created from a Dataset where some columns have numeric values but are Attributes (not Measures).
   For example: See "A" (and not a "#" symbol) next to the column in the Dataset pane.

Adding such a column to a Graph visualization fails with the message: Only Measure Data is Allowed.
   For example: Drag the column to the Values (Y-Axis) section of a Bar visualization.

A Calculation is added to try to create a Measure column that can be graphed, but the calculated column is still seen as an Attribute (See "A" next to the column under My Calculations).
   For example: CASE WHEN "Numeric Rating" = 1 THEN 500*0.01 ELSE (CASE WHEN "Numeric Rating" = 2 THEN 500*0.02 ELSE 500*0.03 END) END


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.