First Steps in SAP Business Warehouse (BW)
Flatrate
19 € pro Monat
Einzellizenz 1000+ E-Books und Videos Sofortiger Zugang 12 Monate(228 €pro Jahr) Automatische Verlängerung
Mehr Informationen
Companies are leveraging the power of big data and are tasked with putting an infrastructure in place that will allow for the analysis of this data. One essential piece of that infrastructure is the data warehouse (DWH). This book offers a comprehensive introduction to SAP Business Warehouse (BW). You'll learn about the primary features and functions of SAP NetWeaver BW, including architecture, data modeling, data extraction, data staging, and reporting. Learn about the different types of InfoProviders available in SAP BW and get a detailed understanding of InfoObjects and InfoCubes. Walk through the ETL process and best practices for administering InfoCubes and DataStore objects. Get tips on how to optimize data access using aggregates and statistics. By using practical examples, tips, and screenshots, the author brings readers new to SAP BW up to speed on the fundamentals and best practices for providing reports to users.
- Tips for loading data from a source system to SAP BW with SAP ETL
- How to automate ETL tasks using process chains
- Using SAP BW Business Content to accelerate the design of your BW objects
- Leverage BEx Query Designer and BEx Analyze
Leseprobe
2.1 InfoProviders
InfoProviders are objects that provide data for a query. They can be persistent (data is stored physically and persistently) or non-persistent (they provide only data stored in other objects such as data targets).
Queries and InfoProviders
A query can only be based on a single InfoProvider. The non-persistent InfoProviders are often used to combine data from various persistent InfoProviders and present the results as if they were one source.
2.1.1 The InfoProviders list
The persistent InfoProviders (also called data targets) are mainly the InfoObject, DataStore Object (DSO), and the InfoCube. The non-persistent InfoProviders are the MultiProvider, InfoSet, and the VirtualProvider (see Figure 2.1). From SAP BW 7.3 on, new advanced InfoProviders are available to respond to new technologies (e.g., in-memory database), including: BWA only InfoCube, semantically partitioned objects (SPO), Hybrid Provider, analytical index, Composite Provider, and TransientProvider.
Bewertungen
-. -
21.34.2021
