The learning content is designed for anyone who wants to gain SAP knowledge in a simple, compact, and practical way. Our learning platform offers content for beginners, advanced learners, and experts. This enables you to expand your knowledge step by step and continuously develop your skills toward becoming an SAP expert.
First Steps in SAP Business Warehouse (BW)
Flat rate
$19 per month
Single license 1000+ eBooks and video tutorials Instant access 12 months($228per year) Automatic renewal
More Details
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
Reading Example
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.
Our products—whether books, videos, or online training—deliver SAP knowledge concisely and practically, so you can apply it directly in your daily work, even if you have limited time. You benefit from a broad coverage of relevant SAP topics, high-quality content in four languages, and learning formats designed to fit your individual needs. This ensures that you can stay up to date and continuously develop your expertise.
Our books are characterized by a clear practical focus and a compact, easy-to-understand presentation. We explain complex SAP topics concisely—without unnecessary marketing buzzwords—so readers can quickly grasp the essentials and apply the new knowledge directly.
Our print books can be returned within 14 days, in original condition. Return shipping is at your own cost.
We currently only ship books directly within Germany. If you are ordering from outside Germany, we recommend purchasing via Amazon. You can find the link by selecting “Buy eBook” on any product in our webshop and Amazon will then show you both the eBook and print versions available for purchase.
Alternatively, you can access all our content with a digital subscription, starting at $19 per month.
Our team is always happy to help and will respond to your questions as quickly as possible (usually within 1–2 days). You can also contact us if you have questions for one of the authors. Email: contact@espresso-tutorials.com

