Source information

Budgeting and forecasting of sales within M3 BE are based on data sets which are defined on a set of available key-fields and measures. The Sales Budget model requires the usage of specially configured data sets. The data contained in the model for Sales vs. Budget can be of the two major types:

  • Actual sales driven by invoice statistics in OSBSTD
  • Budget or forecast stored in selected Budget-versions

To facilitate the usage of the Sales Budget model, a template with predefined levels and dimensions has been defined. The template requires that products are budgeted down to item number level, and budget customers should also be set up to represent the required customer dimension.

The Version dimension is what makes the Sales Budget cube unique. This dimension is used to compare scenarios such as actual sales versus budget or forecasts version. We have created predefined calculations inside the cube that facilitate comparisons of KPIs and measures between actual and budget or forecast.

Sales Budget period dimension is used to analyze the statistics by the year level to the period level.