Core
BPCMAIN
This is the main cube of the Budgeting & Planning application.
Data integration with source systems is implemented with the main cube. Approved budget can be provided by the main cube for source system purposes as process control, for example, cap of budget.
| Dimensions | Description |
|---|---|
| BPDTIME | Time |
| BPDCYCLE | Configuration set definition |
| BPDVERSION | Data versions such as actuals, projection, budget, and forecast |
| BPDLEVEL | Includes hierarchies and elements to differentiate |
| BPDSTEP | Reflects the changes made based on the workflow for one level (element of the Levels dimension) |
| BPDENTITY | Legal company / entity structure of the organization |
| BPDINTERCOMPANY | Reflects the internal organizational structure enhanced by an external structure |
| BPDORGANIZATION | Organization or cost center structure within the legal entities |
| BPDACCOUNT | Chart of accounts and additional figures / measures of sub plans |
| BPDCURRENCY | Currencies of the organization |
| Detail dimensions (finance): | |
| BPDDETAIL | Schedules, sub plan-specific details, asset categories, detail and custom lines |
| BPDPSEGMENT | Primary segment for financial purposes |
| BPDSSEGMENT | Secondary segment for financial purposes |
| BPDTSEGMENT | Tertiary segment for financial purposes |
| Analysis dimensions: | |
| BPDANALYSIS_01 – BPDANALYSIS_12 | Customer or industry-specific dimensions that offer additional analysis for individual customer requirements |
CPCMAIN
This cube is used for storing financial data related to Capital Planning.
Note: This cube is not
used at this time.
| Dimensions | Description |
|---|---|
| BPDTIME | Time |
| BPDCYCLE | Configuration set definition |
| BPDVERSION | Data versions such as actuals, projection, budget, and forecast |
| BPDSTEP | Reflects the changes made based on the workflow for one level (element of the Levels dimension) |
| BPDENTITY | Legal company / entity structure of the organization |
| BPDINTERCOMPANY | Reflects the internal organizational structure enhanced by an external structure |
| BPDORGANIZATION | Organization or cost center structure within the legal entities |
| BPDACCOUNT | Chart of accounts and additional figures / measures of sub plans |
| BPDCURRENCY | Currencies of the organization |
| BPDDETAIL | Schedules, sub plan-specific details, and flexible detail lines |
| BPDPSEGMENT | Primary segment for financial purposes |
| BPDSSEGMENT | Secondary segment for financial purposes |
| BPDTSEGMENT | Tertiary segment for financial purposes |
| BPDANALYSIS 01 - 12 | Customer or industry-specific dimensions that offer additional analysis for individual customer requirements |
| CPDREQUESTTYPE | Used to specify request types |
| CPDFUNDTYPE | Used to specify fund types. |
| CPDREQUEST | Placeholder dimension |
| CPDITEM | Placeholder dimension |
WBCMAIN
This cube is used for storing detailed Workforce Budgeting data and projections.
| Dimensions | Description |
|---|---|
| WBCPERIOD | Periods, can be defined as year, quarter, month, week or pay period |
| BPDTIME | Time |
| BPDCYCLE | Configuration set definition |
| BPDVERSION | Data versions such as actuals, projection, budget, and forecast |
| BPDLEVEL | Includes hierarchies and elements to differentiate |
| BPDSTEP | Reflects the changes made based on the workflow for one level (element of the Levels dimension) |
| BPDENTITY | Legal company / entity structure of the organization |
| BPDINTERCOMPANY | Reflects the organizational structure enhanced by an internal/external structure |
| BPDACCOUNT | Chart of accounts plus additional figures / measures of sub plans |
| BPDCURRENCY | Currencies of the organization |
| BODDETAIL | Schedules, sub plan-specific details, and flexible detail lines |
| BPDPSEGMENT | Primary segment for financial purposes |
| BPDSSEGMENT | Secondary segment for financial purposes |
| BPDTSEGMENT | Tertiary segment for financial purposes |
| BPDANALYSIS_01 - 12 | Customer or industry-specific dimensions that offer additional analysis for individual customer requirements |
| WBDJOB | Job classes |
| WBDPOSITION | Positions |
| WBDEMPLOYEE | Employees |