Workforce Planning
WDCDRIVER
This cube is a mapping table and is used to calculate the number of FTE/HC/Hours based on the company standards. For example, company provides information about production demand such as how many cups must be created.
The cube represents storage for all drivers across all site/location/periods. The drivers are loaded for each period and can be adjusted manually. Drivers can have additional dimensionality which is modeled by one of the analysis dimensions.
| Dimensions | Description |
|---|---|
| BPDCYCLE | Configuration set definition |
| BPDVERSION | Data version such as Actual, Budget1 |
| WDDPERIOD | Period dimension that serves as a timestamp for when the data has been entered |
| WDDFORECAST_PERIOD | Forecast period dimension that defines the planning period |
| WDDDRIVER | Driver dimension, can be base or calculated |
| BPDENTITY | Legal Company / entity structure of the organization |
| BPDORGANIZATION | Organization or cost center structure |
| WBDJOB | Job dimension including hierarchy of jobs |
| BPDLEVEL | Defines the difference between uploaded and user modified values |
| BPDQUANTITY_UNIT | Represents quantity unit of values The family used is defined as an attribute on WDDDRIVER dimension |
|
BPDANALYSIS_1-N BPDSEGMENT 1-3 |
Represents additional data dimensionality For example, data not only for a specific month but also for location/project BPDANALYSIS_1 through BPDANALYSIS_12 are reserved |
| ATDLIST | References the alternate hierarchy, FREQUENCY |
| BPDPARAMETER | Planning parameters Only SUBPLAN_WFD_DRIVER_VALUE is used |
WDCMAP_DRIVER_CATEGORY
This cube defines the relationship between driver and driver category for a specified configuration set and version.
| Dimensions | Description |
|---|---|
| BPDCYCLE | Configuration set definition |
| BPDVERSION | Data version such as Actual, Budget1 |
| WDDDRIVER_CATEGORY | Category of the driver, common, site, and so on |
| WDDDRIVER | Driver |
| BPDPARAMETER | Planning parameters Only SUBPLAN_WFD_IS_MAPPED is used |
| VALUE | 1/0 |
BPCMAP_QUANTITY_UNIT
This cube is used for conversion between unit of measures.
| Dimensions | Description |
|---|---|
| BPDSQUANTITY_UNIT | Quantity unit |
| BPDQUANTITY_UNIT | Represents quantity unit of values The family used is defined as an attribute on WDDDRIVER dimension |
WDCCONFIG
This cube contains all Workforce Planning specific settings per configuration set and version.
| Dimensions | Description |
|---|---|
| BPDCYCLE | Configuration set definition |
| BPDVERSION | Data version such as Actual, Budget1 |
| BPDENTITY | Legal Company / entity structure of the organization |
| WDDCALC_METHOD | Settings that are not dependent on calculation have N.A. |
| BPDPARAMETER | Planning parameters |
WDCASSIGNMENT
This cube contains data related to the driver and assignments.
| Dimensions | Description |
|---|---|
| BPDCYCLE | Configuration set definition |
| BPDVERSION | Data version such as Actual, Budget1 |
| WDDCALC_METHOD | Calculation method |
| WDDPERIOD | Period dimension that serves as a timestamp for when the data has been entered |
| WDDFORECAST_PERIOD | Forecast period dimension that defines the planning period |
| BPDENTITY | Legal Company / entity structure of the organization |
| BPDORGANIZATION | Organization or cost center structure |
| WBDJOB | Job dimension including job hierarchy |
|
BPDANALYSIS_1-12 BPDSEGMENT_1-3 |
Represents additional data dimensionality For example, data not only for a specific month but also for location/project BPDANALYSIS_1 through BPDANALYSIS_12 are reserved |
| WDDDRIVER | Driver |
| BPDQUANTITY_UNIT | Quantity unit |
| BPDPARAMETER | Planning parameters |
WDCCALCULATION
This cube stores actual employee mapping data and calculation results. For example, job to employee mapping.
| Dimensions | Description |
|---|---|
| BPDCYCLE | Configuration set definition |
| BPDVERSION | Data version such as Actual, Budget1 |
| WDDCALC_METHOD | Calculation method |
| WDDPERIOD | Period dimension that serves as a timestamp for when the data has been entered |
| WDDFORECAST_PERIOD | Forecast period dimension that defines the planning period |
| BPDENTITY | Legal Company / entity structure of the organization |
| BPDORGANIZATION | Organization or cost center structure |
| WBDJOB | Job dimension including the job hierarchy |
| WBDPOSITION | Position dimension |
| WBDEMPLOYEE | Employee dimension |
| WDDDRIVER | Driver dimension |
| BPDLEVEL | Defines the difference between uploaded and user modified values |
|
BPDANALYSIS_1-12 BPDSEGMENT_1-3 |
Represents additional data dimensionality For example, data not only for a specific month but also for location/project BPDANALYSIS_1 through BPDANALYSIS_12 are reserved |
| BPDACCOUNT | Chart of accounts. This represents a measure of calculation (FTE, hours, HC) |