User Tools

Site Tools


concepts:facts
  • Bookmark "Facts" at del.icio.us
  • Bookmark "Facts" at Digg
  • Bookmark "Facts" at Furl
  • Bookmark "Facts" at Reddit
  • Bookmark "Facts" at Ask
  • Bookmark "Facts" at Google
  • Bookmark "Facts" at Netscape
  • Bookmark "Facts" at StumbleUpon
  • Bookmark "Facts" at Technorati
  • Bookmark "Facts" at Live Bookmarks
  • Bookmark "Facts" at Yahoo! Myweb
  • Bookmark "Facts" at Facebook
  • Bookmark "Facts" at Newsvine
  • Bookmark "Facts" at Yahoo! Bookmarks
  • Bookmark "Facts" at Twitter
  • Bookmark "Facts" at myAOL
  • Bookmark "Facts" at Slashdot
  • Bookmark "Facts" at Mister Wong

Facts

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 and integrated 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.
  • In reporting the way of the data flow depends on the reports. You create cubes with certain dimensions and drill down or extract 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.

Further Information

1) Dobler, Michael, Hetzer, Hanno, Schmitz, Ursula. Konsolidierte Abschlüsse mit SAP SEM-BCS. Bonn, Galileo Press, 2008. 53. Print.
2) , 4) , 6) , 7) Meier, Marco, Sinzig, Werner, Mertens, Peter. Enterprise Management with SAP SEMTM/Business Analytics. Berlin, Heidelberg, Springer-Verlag, 2003. 69-169. Print.
3) Meier, Marco, Sinzig, Werner, Mertens, Peter. Enterprise Management with SAP SEMTM/Business Analytics. Berlin, Heidelberg, Springer-Verlag, 2003. 70. Print.
5) Bachmann, Ronald, Kemper, Guido. Raus aus der BI-Falle. Heidelberg, München, Landsberg, Frechen, Hamburg, mitp, 2009. 79-101. Print.
8) Meier, Marco, Sinzig, Werner, Mertens, Peter. Enterprise Management with SAP SEMTM/Business Analytics. Berlin, Heidelberg, Springer-Verlag, 2003. 83. Print.
9) Bachmann, Ronald, Kemper, Guido. Raus aus der BI-Falle. Heidelberg, München, Landsberg, Frechen, Hamburg, mitp, 2009. 99-101. Print.
10) Dobler, Michael, Hetzer, Hanno, Schmitz, Ursula. Konsolidierte Abschlüsse mit SAP SEM-BCS. Bonn, Galileo Press, 2008. 54-56,88-90. Print.
11) Dobler, Michael, Hetzer, Hanno, Schmitz, Ursula. Konsolidierte Abschlüsse mit SAP SEM-BCS. Bonn, Galileo Press, 2008. 54-56,88-90. Print.
12) Lehmann, peter, Freyburger, Klaus, Seufert, Andreas. Modellierung und Reporting mit SAP BW. Stuttgart, Berlin, Steinbeis-Edition, 2005. 58-65. Print.
13) Dobler, Michael, Hetzer, Hanno, Schmitz, Ursula. Konsolidierte Abschlüsse mit SAP SEM-BCS. Bonn, Galileo Press, 2008. 83-417. Print.
14) Dobler, Michael, Hetzer, Hanno, Schmitz, Ursula. Konsolidierte Abschlüsse mit SAP SEM-BCS. Bonn, Galileo Press, 2008. 425-447. Print.
15) , 18) Dobler, Michael, Hetzer, Hanno, Schmitz, Ursula. Konsolidierte Abschlüsse mit SAP SEM-BCS. Bonn, Galileo Press, 2008. 323-417. Print.
16) Meier, Marco, Sinzig, Werner, Mertens, Peter. Enterprise Management with SAP SEMTM/Business Analytics. Berlin, Heidelberg, Springer-Verlag, 2003. 88-107. Print
17) Meier, Marco, Sinzig, Werner, Mertens, Peter. Enterprise Management with SAP SEMTM/Business Analytics. Berlin, Heidelberg, Springer-Verlag, 2003. 79-114. Print.
  • Bookmark "Facts" at del.icio.us
  • Bookmark "Facts" at Digg
  • Bookmark "Facts" at Furl
  • Bookmark "Facts" at Reddit
  • Bookmark "Facts" at Ask
  • Bookmark "Facts" at Google
  • Bookmark "Facts" at Netscape
  • Bookmark "Facts" at StumbleUpon
  • Bookmark "Facts" at Technorati
  • Bookmark "Facts" at Live Bookmarks
  • Bookmark "Facts" at Yahoo! Myweb
  • Bookmark "Facts" at Facebook
  • Bookmark "Facts" at Newsvine
  • Bookmark "Facts" at Yahoo! Bookmarks
  • Bookmark "Facts" at Twitter
  • Bookmark "Facts" at myAOL
  • Bookmark "Facts" at Slashdot
  • Bookmark "Facts" at Mister Wong
concepts/facts.txt · Last modified: 2014/10/19 13:38 (external edit)