The Financial Forecast folder in the Global Sales Business Warehouse (BW) provides self-service functionality to users for loading financial forecast data into the BW cube, for reporting purposes. It represents a functionality in itself, rather than a report. The financial forecast includes data determining how much we aim to sell for each product to which customer, specifying quantity, value, and contribution margin. The primary objective of the financial forecast data is to compare the budgeted figures with the achieved results, identifying gaps in terms of products and customers.
Finance team
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 27.11/2023 | Azadeh Nasiri | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
2.0 Business Process
GBUs define the annual budget at the end of the year, and this budget is considered fixed and not open to alterations. Nevertheless, every quarter, modifications and changes to the budget are made through a separate process and maintained in distinct files. (Note: it's worth mentioning that currently, majority of GBUs rely on Dynasys as their source for budgeting, while in the past, this was a manual process.
GBUs are expected to load their budgets into the BW reporting system, making it visible to reports and dashboards. Access to this process is limited to specific users. Forecast part of the Global sales folder in BW has been developed to support these processes. This application allows to load FINANCIAL FORECAST in BW : BUDGET and BFR (Business Forecast Review).
3.0 Application Feature Overview
Loading Forecast Data to BW
This application allows to load financial forecast in BW:
- BUDGET,
- BFR (Business Forecast Review) & MTP
The loading is done using an Excel file.
The BW transaction to be used is ZBW_SD_PC
Forecast in Global Sales
Forecasts are used after and combined with sales in global sales reporting solutions including orderbook.
Note about Forecast in Dynasys
- GBUs in DYNASYS will have the choice to work with BW transaction or with Dynasys-Forecasts
- GBUs not in DYNASYS should only use the BW transaction.
4.0 Functional Specification
4.1 General Data/Calculations
This section will approach the concepts/definitions that will be used in all the reports and required to understand the data from the reports.
Could be specific fields, closing activities, additional information to work and understand the reports.
4.2 Process Detail
4.2.1. Report/Process Definition
This section represents the process with detail information for the application. Can include specific or special cases, complex logics , calculations, flows, among others.
5.0 Non-functional Descriptions
Please populate the relevant section and delete those that are not applicable.