SAP BW он же SAP NetWeaver Business Warehouse

SAP NetWeaver Business Warehouse

 SAP Business Warehouse (SAP BW) is the cornerstone of SAP’s strategic Enterprise Data Warehouse solutions and runs on industry standard RDBMS and SAP's HANA in-memory DBMS. It delivers reporting, analysis and interpretation of business data that is crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to respond quickly to meet market opportunity. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data.

AP's BI products have layers:

• Extract, transform, load (ETL) layer - responsible for extracting data from a specific source, applying transformation rules, and loading it into the Data Warehouse Area.
• Data Warehouse Area - responsible for storing the information in various types of structures (e.g. Data Store Objects, InfoObjects and multidimensional structures called InfoCubes that follows star schema design).
• Reporting - for accessing the information in data warehouse area and presenting it in a user-friendly manner to the analyst or business user.
• Planning and analysis - Provides capabilities for the user to run simulations and perform tasks such as budget calculations.

SAP BW contains pre-defined business content in the form of InfoCubes, Info Objects, authorization roles, and queries. The business content can be modified to meet an organization's specific requirements; however, this requires a longer process of customization of the pre-defined elements.