My Oracle Support Banner

OAC: A Graph Fails With An Insufficient Data Error Due to the Numeric Column Being Treated As An Attribute (Doc ID 2462028.1)

Last updated on OCTOBER 10, 2019

Applies to:

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


A Data Flow merges two (2) Data Sets from Excel file sources and saves the data locally. For example:

   Dataset_1 + Dataset_2 > Merge (Union All) step > Save Data step ... where Save Data to = Data Set Storage, Data Set name = Final_Dataset

A Project on the Final_Dataset contains a graph visualization with the Employee Name column in Category (Y-Axis) and the Global Amount column in Values (X-Axis).

After upgrading to OAC 18.3.3 (with OAC5/DV5 functionality), opening the Project will fail to render the graph visualization and the following error is observed:

Insufficient Data
Values (X-Axis): Missing Data
Category (Y-Axis): Employee Name

In Data > Data Sets > Final_Dataset > Inspect > Data Elements page, see the Global Amount column has Data Type = Number, and Treat As = Measure.

In Data > Data Sets > Final_Dataset > Open > Results page, see the # icon precedes the Global Amount column name; click on the Global Amount column, and see Data Type = Double and Treat As = Measure.

Create a new Project and add the Global Amount column to the Values property of a visualization ... see the "Only measure data is allowed" error is thrown. Click on the Global Amount column and change the Treat As property from Attribute to Measure, and then the visualization can be successfully created.

Run / execute the Final_Dataflow, and see the issue is again encountered where existing and new Projects consider the Global Amount column to be an Attribute.




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.