A Practical Guide to SAP NetWeaver Business Warehouse 7.0

1. Auflage 2010
ISBN: 978-1-59229-323-0
Verlag: Rheinwerk Verlag

Buch, Englisch, 702 Seiten, Format (B × H): 152 mm x 229 mm

Reihe: SAP PRESS: englisch

This book provides a comprehensive and practical understanding of SAP NetWeaver BW 7.0, utilizing a real-world, scenario-based approach to detail the core, fundamental components and features. You'll learn about the primary features and functions of SAP NetWeaver BW 7.0, including architecture, data modeling, data extraction, data staging, and more. Then, delve into the specifics of data modeling with SAP NetWeaver BW. Coverage includes InfoObjects, working with master data, InfoCubes, MultiProviders, and Infosets. The authors take an in-depth look at data sources in SAP NetWeaver BW 7.0, extracting data from flat files, working with generic extractors, and extracting data from SAP NetWeaver BW.

Plus, find out what's important regarding data transformation and staging. Topics covered include the data transfer process, real-time data acquisition, typical staging architectures, etc. Finally, you'll explore an overview of administration and monitoring topics within SAP NetWeaver BW 7.0, including process chains, data upload monitoring, the BW administration cockpit, and working with aggregates.

Autoren/Hrsg.

Patel, Bharat

Palekar, Amol

Shiralkar, Shreekant

Fachgebiete

• Mathematik | Informatik EDV | Informatik Business Application Unternehmenssoftware SAP
• Wirtschaftswissenschaften Betriebswirtschaft Wirtschaftsinformatik, SAP, IT-Management
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Data Warehouse

Inhaltsverzeichnis

. Preface. 17. An Introduction to Business Intelligence. 211. The Business Scenario: ABCD Corp. 27

. 1.1. ABCD Corp.: Company Overview. 27

. 1.2. Marketing Network. 28

. 1.3. The Sales and Billing Process. 29

. 1.4. Business Intelligence Requirements. 32

. 1.5. The Business Planning Scenario. 33

. 1.6. Summary. 34

2. SAP NetWeaver Business Warehouse -- Overview. 35

. 2.1. Evolution of SAP NetWeaver BW. 35

. 2.2. Layers of SAP NetWeaver BW. 38

. 2.3. Basic Navigation in SAP NetWeaver BW. 43

. 2.4. Data Warehousing Workbench Functions. 53

. 2.5. Activation of SAP Business Content. 56

. 2.6. Implementation/Architecture Options with SAP NetWeaver BW. 64

. 2.7. Avenues of SAP NetWeaver BW Learning. 66

. 2.8. Summary. 67

3. InfoObjects and Master Data. 69

. 3.1. Types of InfoObjects. 70

. 3.2. Creating an InfoArea. 71

. 3.3. Creating an InfoObject Catalog. 73

. 3.4. Creating a Characteristic InfoObject. 76

. 3.5. Configuring a Characteristic InfoObject. 78

. 3.6. Creating a Key Figure InfoObject. 98

. 3.7. Configuring a Key Figure InfoObject. 100

. 3.8. Creating a Unit InfoObject. 112

. 3.9. Summary. 114

4. DataStore Objects. 115

. 4.1. Introduction to DataStore Objects. 115

. 4.2. Architecture of the Standard DSO. 119

. 4.3. Designing a DSO. 125

. 4.4. Configuration of the Standard DSO. 128

. 4.5. Configuration of Write-Optimized DSOs. 135

. 4.6. Configuration of Direct Update DSOs. 137

. 4.7. Usage Scenarios for DSOs. 138

. 4.8. Summary. 140

5. InfoCubes. 141

. 5.1. Modeling InfoCubes. 141

. 5.2. Types of InfoCubes. 150

. 5.3. Creating a Standard InfoCube. 152

. 5.4. Provider-Specific Properties. 168

. 5.5. Summary. 172

6. InfoProviders. 173

. 6.1. Introduction to MultiProvider. 173

. 6.2. Designing a MultiProvider. 175

. 6.3. InfoSets. 188

. 6.4. Creating an InfoSet. 191

. 6.5. Additional Navigation Capabilities. 199

. 6.6. Global Properties. 203

. 6.7. Left Outer Join in an InfoSet. 208

. 6.8. Introduction to VirtualProviders. 210

. 6.9. Summary. 211

7. Extraction, Transformation, and Loading. 213

. 7.1. Introduction to ETL. 213

. 7.2. Loading Master Data from a Flat File Source System to an InfoObject. 219

. 7.3. Loading Transaction Data from a Source System to a DSO. 260

. 7.4. Loading Data from a DSO to an InfoCube. 279

. 7.5. Temporary Storage Areas and Error Stacks. 286

. 7.6. Data Extraction from Non-SAP systems. 293

. 7.7. Summary. 296

8. Extraction from an SAP Source System. 297

. 8.1. Settings in SAP ERP. 298

. 8.2. Activating Business Content DataSources. 298

. 8.3. Data Extraction Using the Logistic Cockpit. 299

. 8.4. Generic DataSources. 304

. 8.5. Making Generic DataSources Delta Capable. 311

. 8.6. Extractor Checker. 314

. 8.7. Summary. 316

9. BEx Query Designer. 317

. 9.1. BEx Tools Landscape. 317

. 9.2. Example Scenario. 319

. 9.3. BEx Query Designer. 320

. 9.4. Create a Simple BEx Query. 324

. 9.5. OLAP Variables. 333

. 9.6. Variable Editor. 338

. 9.7. Filters -- Selection Objects. 351

. 9.8. Structures. 356

. 9.9. Selections and Formulas. 3

Über Autor(innen)

Shiralkar, Shreekant
Shreekant Shiralkar’s career, spanning more than 22 years, reflects his ability to manage transformation and innovation for growth. Currently he is a senior executive in a global management consulting, technology services, and outsourcing company — overseeing its growth and innovation across technologies in India. Previously, he held various leadership roles in Tata Consultancy Services Ltd. in their Energy, Resources, & Utilities Industry Solution unit (ERU-ISU) and SAP Practice, where he grew its business, acquiring new clients in new geographies and adding new service offerings. Earlier, he made significant contributions in varying capacities such as the launch of the “Shell Gas” business in India, leading major transformation projects, and development of a supply chain strategy generating high-value cost optimization for a Fortune 500 oil company. Shreekant has published many technical articles on SAP APO, SAP NetWeaver BW, and RFID, including a book on SAP NetWeaver BW. He has presented papers at many international conferences. You can contact him at [e-mail].

Patel, Bharat
Bharat Patel is a Post Graduate in Computer Applications and has extensive experience managing data warehouse technology. He is SAP BW certified and an ABAP consultant. He has presented papers at Business Intelligence India Group (BIIG) conferences and currently manages a large BW system for a fortune 500 company in India.

Palekar, Amol
Amol Palekar has been engaged in BI consulting for eight years and has worked on a variety of SAP NetWeaver BW implementations for customers in manufacturing, automotive, CPG, and telecom domains across geographies. His recent work focuses on expanding the BI footprint within an enterprise to help the business achieve maximum value from analytics and planning capabilities offered by information technology. Amol has made significant contribution in competency building for the organizations he has worked for or served. He has trained many IT professionals on SAP NetWeaver BW and regularly publishes articles and blogs on the subject. He is currently a lead consultant for business analytics in a major IT services company. You can reach Amol at [e-mail].