The Demand cube captures demand and revenue plans at the customer/geography product/fiscal-calendar level of granularity.
Demand quantities or demand volumes
This information is maintained in the cube by users or is loaded from external data sources. Examples of external data sources: demand planning tools such as Oracle Demantra or equivalent, Oracle Hyperion Planning, Fusion Edition, and Excel spreadsheets.
Average selling prices per customer, geography, and product
This information is currently set to be loaded from external systems such as ERP. The information can be altered to compute based on historical information.
Actuals or historical information
Target revenues by product family and geography
Simulate change in volumes and average selling prices
Assess impact in terms of financial desirability and operational feasibility
Demand revenue projections that feed the Financials cube
Demand volumes that feed the Transportation cube
Table 6. Predefined Information in the Demand Cube
| Dimensions | Measures | Constraints | Allocation Maps | Related Objects |
|---|---|---|---|---|
| Customers Fiscal Geography Product | Adjusted Demand Plan Quantity Demand Plan Adjustment % Demand Plan Quantity Demand Plan Revenue Demand Plan Revenue - Local Market Share Open Sales Orders Quantity Open Sales Orders Revenue Parent Quantity Parent Revenue Quantity Mix % Revenue Forecast Accuracy % Revenue Mix % Revenue Variance Revenue Variance % Shipped Sales Order Quantity Shipped Sales Order Revenue TAM-previous Target Market Share Target Revenue Total Addressable Market | Revenue_Shortfall | allocate-Adjustment-Customers allocate-Adjustment-Geography allocate-Adjustment-Product | Cubes
Dimensions
Row Sources
|