QVolume ODS

Technical Name: 0RC_DS06

Use

The QVolume ODS is used to stage the data prior to loading into the QVolume InfoCube primarily to allow for overwrite functionality to filter out multiple data loads.

InfoSources

0RC_CI_6 QVolume

Key Fields

Key Field

Description

0RC_STORE

Store

0RC_VOLIND

Volume Indicator

0RC_RT_FDY

Retail Fiscal Date

0RC_RT_QHR

Quarter Hour Indicator

0RC_RT_FQH

Retail Fiscal Quarter Hour

0RC_RT_FYR

Retail Fiscal Year

0RC_RT_FMO

Retail Fiscal Month

0RC_RT_FWK

Retail Fiscal Week

0RC_RT_FDIW

Retail Fiscal Day in Week

0CALDAY

Calendar day

Data Fields

Update rules for Qvolume ODS will evaluate master data looking up 0RC_VISTY to determine if the number found in the communication structure represents a quantity or an amount. Amounts will be placed in 0RC_VIAMT and quantities will be placed in 0RC_VIQTY.

Additionally, the master data will be queried to determine if there is a department or job associated with this Volume Indicator, and if there is, those corresponding characteristic fields will be populated in the ODS object.

Data Field

Description

0RC_VIQTY

Volume Indicator Quantity

0UNIT

Unit of measure

0RC_VIAMT

Volume Indicator Amount

0CURRENCY

Currency key

Delta Update

This ODS object is designed for a delta update with a flat file DataSource.