WDCDRIVER cube

This cube is for driver records.

• The staging table is DAT_WDCDRIVER_STAGE.
• The stored procedure to validate staged data is depm_integration_wp_driver_prepare_staging.
• The stored procedure to process staged data is depm_integration_wp_driver.
• The output table is ATT_WDCDRIVER (calculations cube data table).

The table describes DAT_WDCDRIVER_STAGE:

Field	Type	Required	Description
WDDPERIOD	nvarchar(2000)	Y	Data version.
WDDFORECAST_PERIOD	nvarchar(2000)	Y	Actual dates represented by a planning period with start and end date.
WDDDRIVER	nvarchar(2000)	Y	Driver ID must exist in OLAP database.
BPDENTITY	nvarchar(2000)	N	Must exist in DIM_BPDENTITY_ELEMENTS. If empty, replaced by N.A.
BPDORGANIZATION	nvarchar(2000)	N	Must exist in DIM_BPDORGANIZATION_ELEMENTS. If empty, replaced by N.A.
WBDJOB	nvarchar(2000)	N	Must exist in DIM_WBDJOB_ELEMENTS. If empty, replaced by N.A.
BPDQUANTITY_UNIT	nvarchar(2000)	Y	Quantity unit ID must exist in OLAP database.
BPDANALYSIS_nn	nvarchar(2000)	N	Must exist in DIM_BPDANALYSIS_nn_ELEMENTS. If empty, replaced by N.A.
BPDPSEGMENT	nvarchar(2000)	N	Must exist in DIM_BPDPSEGMENT_ELEMENTS. If empty, replaced by N.A.
BPDSSEGMENT	nvarchar(2000)	N	Must exist in DIM_BPDSSEGMENT_ELEMENTS. If empty, replaced by N.A.
BPDTSEGMENT	nvarchar(2000)	N	Must exist in DIM_BPDTSEGMENT_ELEMENTS. If empty, replaced by N.A.
VALUE	nvarchar(2000)	N	Must be numeric.