With the understanding of the concept of facts1) the user gets introduced to the key steps, processes and knowledge of how to work with data warehouses and Business Intelligence. The related input and output transactions to the concept of facts and the business processes of its data flow gives the user a basic overview to be able to work with such systems.
Business View – Decription of data flow
From a business view facts mainly is information in the form of data that is moving from input- to output components2) through a system.
To have an example the content of this daily or monthly changing transactional data flow is bookings3), orders, purchases, etc.
Input components4)are used to create transactions that contain these facts e. g. in accounting (SAP FI/CO)5).
Pre-systems6)even before collect prior information, like travel expenses, that is needed to create these accounting transactions in the input components.
With output components7)(BEx Analyzer8)) a user can extract, view, report or analyze the data flow.
In between - input and output components - the data is stored9)in info objects10), cubes11), in tables with the star schema or snow flake schema12) depending on the system.
What a user requires to know is how to move the data correctly through the systems to reach results. So the user needs to analyze and monitor the data flow of all facts.
Finance Function – Process examples for users
In the financial, managerial accounting and consolidation processes balance sheets and profit and loss statements are produced by adding13)
the transactions of the accounts in the input components, e. g. SAP FI/CO. Here you should know the accounting processes and what account to debit. With the related data flow the transactions are stored in info objects and afterwards need to be extracted meaning, viewed or reported with output components like SAP SEM-BPC or SAP BI14)
. Again the dataflow of the facts is designed
according to the logic of how to add a balance sheet or in what steps to consolidate a balance sheet of a concern15)
. Meaning to view the consolidated financial statement in SAP BPC the balance sheet is added and consolidated according to the consolidation steps. To verify your information check whether the right input transactions have reached the right accounts in BPC and are eliminated correctly in the consolidation processes.
the way of the data flow depends on the reports. You create cubes
with certain dimensions and drill down
the data with queries structured by your reporting logic.
In planning and forecasting
it is important to be able to have a data flow with cubes filled with individual planning structures that quickly and flexibly adjust to the strategy, structure and the business of concerns16)
In managerial accounting the hierarchy17)
is relevant to the data flow. Depending on how the units and teams are structured so is data structured and are reports extracted.
Business Cases – Examples for professional users
In the case of a migration
the data flow needs to be transferred. So the old account structure is mapped to the new structure, tested and transferred to the new system.
In the case of installation18)
you have to create and design all accounts and automated transactions new, test it and check the newly designed data flow in a production environment and its processes.
Conclusions for all users
For the user it is important to know that the data flow of the facts is determined by its logic, which is related to the business environment its cases and processes. This concept can be applied to the systems of all functions. Facts is not more than information of the daily business in the systems.