Hi,
SAP BW consists among other things of components for data management (Data Warehousing Workbench), extensive data modeling capabilities, an embedded analytical engine, a suite of rich front-end analytical tools refererred to as Business Explorer (BEx), and operational tools used for importing the most current transactional data into the system. It may be helpful to consider layers that make up the structure of SAP's BI solution:Extraction, Transformation and Load (ETL) layer - responsible for extracting data from a specific source, applying transformation rules, and loading it into SAP BW system. Data warehouse area - responsible for storing the information in various types of structures, including multidimensional structures called InfoCubes. Reporting - responsible for accessing the information in data warehouse area and presenting it in a user-friendly manner to the analyst or business user. Planning - Provides capabilities for the user to run simulations and perform tasks such as budget calculations
A data warehouse is the main repository of an organization's historical data, its corporate memory. It contains the raw material for management's decision support system. The critical factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis, such as data mining, on the information without slowing down the operational systems
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.