The SIGN_OFF_DIGEST_STORE 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.
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
DIGEST
STRING
Y
N/A
The string representing the location digest. A digest is a string representation of the form: dimensionName @hierarchyName = … | dimensionName @hierarchyName = … in which hierarchies whose path is “AllMember” are excluded. Example: “Book@Bookings=AllMember\BookA |Trader=AllMember\John”
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
STRING
Y
N/A
The value used to override the measure value.
Unique Key
Columns
ID
MANDATE_ID
AS_OF_DATE
Table creation script
Snowflake
Table creation
create OR REPLACE table SIGN_OFF_DIGEST_STORE(
ID STRING NOT NULL DEFAULT 'N/A',
MANDATE_ID STRING NOT NULL DEFAULT 'N/A',
AS_OF_DATE DATE NOT NULL,
PIVOT_ID STRING NOT NULL DEFAULT 'N/A',
DIGEST STRING NOT NULL DEFAULT 'N/A',
CURRENCY STRING NOT NULL DEFAULT 'N/A',
MEASURE STRING NOT NULL DEFAULT 'N/A',
VALUE STRING NOT NULL DEFAULT 'N/A',
primary key(ID,MANDATE_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.
↩︎