CUBE_LEVEL_ADJUSTMENTS

The CUBE_LEVEL_ADJUSTMENTS table contains data representing the definition of cube-level adjustments. This file is generated when data is exported after the sign-off process or a sign-off process instance is completed. It is an isolated table and not part of any cube facts.

Column Name	Type	Not Null	Default Value¹	Description
ID	STRING	Y	N/A	Execution ID of the adjustment.
TASK_ID	STRING	Y	N/A	The name of the task for which the adjustment was created.
AS_OF_DATE	DATE	Y	N/A	The as-of date for which the adjustment was created
PIVOT_ID	STRING	Y	N/A	The name of the cube for which the adjustment was created
CURRENCY	STRING	Y		The currency used to express the value of the adjustment.
MEASURE	STRING	Y	N/A	The name of the measure to adjust.
VALUE	DOUBLE	Y	N/A	The add-on value used for the adjusted measure.

Unique Key

Columns
ID
AS_OF_DATE

If the default value is marked as empty, it means that the default value is ‘null’ for nullable fields, and that a value needs to be explicitly set for non-nullable fields. ↩

​Unique Key

Footnotes

Unique Key