Implementing SAP HANA

Inkl. Download
Mitarbeit: Haun, Jonathan; Hickman, Chris; Loden, Don; Wells, Roy

• Gebundenes Buch

Produktbeschreibung

In the new SAP HANA era, processes that once took weeks now take days, hours, or even minutes. Truly take advantage of this bold jump forward with this resource for a standalone SAP HANA implementation. Master data loading with SAP Data Services, data modeling in SAP HANA, and then SAP HANA integration with SAP BusinessObjects BI for reporting and analytics. From general concepts to specific implementation steps and a real-world case study, this book offers the practical details about implementing SAP HANA that will shift your system into high gear.
1. Data Storage
See how SAP HANA has fundamentally changed data storage with column store tables that improve compression and, consequently, performance.
2. SAP Data Services
Avoid fast trash. Preprovision your data using source system analysis, profiling tools, and mapping to load high-quality data into SAP HANA.
3. SAP HANA Studio
Dive into SAP HANA-specific data modelling components like the attribute, analytic, and calculation views that produce quality multidimensional models.
4. Connecting SAP HANA with BI
Deliver sophisticated data visualization and analysis by integrating SAP BusinessObjects Design Studio, SAP Lumira, SAP Predictive Analysis, and more with SAP HANA.
5. Hands-On Case Study
Take SAP HANA for a test drive. Download the data for the fictitious AdventureWorks Cycle Company s implementation and follow along every step of the way.
Highlights include:

Source system analysis
SAP Data Services
Analytic, attribute, and calculation views
SAP HANA Studio
Columnar database technology
Denormalization
Information Design Tool
SAP Information Steward
SAP Predictive Analysis
SAP BusinessObjects BI toolset
SAP Lumira

Produktdetails

• SAP Press
• Verlag: Rheinwerk Verlag
• Seitenzahl: 837
• Erscheinungstermin: 15. November 2013
• Englisch
• Abmessung: 230mm x 169mm x 54mm
• Gewicht: 1636g
• ISBN-13: 9781592298563
• ISBN-10: 1592298567
• Artikelnr.: 37775265

Autorenporträt

Jonathan Haun is a consultant for Decision First, an SAP Partner that implements and configures SAP solutions. He is a regular writer for BI Expert and a regular presenter at SAP conferences.

Inhaltsangabe

Preface ... 17
Acknowledgments ... 23

PART I: Data Modeling and Provisioning ... 25

1. SAP HANA, SAP BusinessObjects Business Intelligence, and SAP Data Services ... 27

1.1 ... What Is SAP HANA? ... 28

1.2 ... Business Intelligence Solutions with SAP HANA ... 36

1.3 ... Running the SAP Business Suite on SAP HANA ... 54

1.4 ... Traditional EIM with Data Services ... 56

1.5 ... Traditional Business Intelligence with SAP BusinessObjects ... 59

1.6 ... Solution Architectural Overview ... 63

1.7 ... Summary ... 71

2. Storing Data in SAP HANA ... 73

2.1 ... How Is Data Stored in SAP HANA? ... 73

2.2 ... SAP HANA Data Storage Components ... 83

2.3 ... Physical Data Modeling in SAP HANA ... 97

2.4 ... Case Study: Modeling Data for an SAP HANA Project ... 109

2.5 ... Summary ... 117

3. Preprovisioning Data with SAP Data Services ... 119

3.1 ... Source System Analysis ... 119

3.2 ... SSA Techniques in SAP Data Services ... 124

3.3 ... SSA: Beyond Tools and Profiling ... 138

3.4 ... Summary ... 145

4. Provisioning Your Data ... 147

4.1 ... Understanding SAP Data Services ... 147

4.2 ... SAP Data Services 4.1 Workbench ... 215

4.3 ... Data Provisioning via Real-Time Replication ... 224

4.4 ... Summary ... 228

5. Loading Your Data ... 229

5.1 ... Loading Data in Batch ... 229

5.2 ... Loading Data in Real Time ... 246

5.3 ... Methods to Trigger Data Loads ... 252

5.4 ... Case Study: Loading Data in Batch ... 260

5.5 ... Case Study: Loading Data in Real Time ... 313

5.6 ... Summary ... 319

PART II: Multidimensional Modeling in SAP HANA ... 321

6. Modeling Data for Analytic Consumption in SAP HANA ... 323

6.1 ... SAP HANA Modeling Main Components ... 328

6.2 ... Benefits of SAP HANA Modeling ... 398

6.3 ... Methods for Modeling Analytics in SAP HANA ... 406

6.4 ... Case Study 1: Modeling Sales Data to Produce Robust Analytics ... 416

6.5 ... Case Study 2: Building Complex Calculations for Executive-Level Analysis ... 443

6.6 ... Summary ... 460

7. Integrating Predictive Analytics with SAP HANA ... 461

7.1 ... Predictive Analytics Platform ... 462

7.2 ... Integrating with SAP HANA ... 482

7.3 ... Integrating with SAP BusinessObjects ... 486

7.4 ... Case Study 1: Clustering Analysis ... 489

7.5 ... Case Study 2: Product Recommendation Rules ... 507

7.6 ... Summary ... 518

8. Security in SAP BusinessObjects BI and SAP HANA ... 521

8.1 ... Security Solution Concepts ... 522

8.2 ... Implementing an Access Control Strategy with SAP BusinessObjects BI 4.0 and SAP HANA ... 532

8.3 ... Case Study: Implementing an End-to-end Security Solution for Access to Sales Data ... 556

8.4 ... Summary ... 562

PART III: Integrating SAP BusinessObjects BI with SAP HANA ... 565

9. SAP BusinessObjects Universe Design ... 567

9.1 ... Overview of the Universe in SAP BusinessObjects ... 571

9.2 ... Building UNX Universes with the Information Design Tool ... 585

9.3 ... Building UNV Universes with Universe Designer ... 628

9.4 ... Understanding the SAP HANA Engines ... 629

9.5 ... Case Study: Designing a Universe to Support Internet Sales Data ... 635

9.6 ... Summary ... 663

10. Professionally Authored Dashboards Powered by SAP HANA ... 665

10.1 ... Introduction to Professionally Authored Dashboards ... 666

10.2 ... Tools for Designing Dashboards with SAP HANA ... 672

10.3 ... Case Study: Creating a Dashboard ... 694

10.4 ... Summary ... 700

11. Data Exploration and Self-Service Analytics with SAP HANA ... 703

11.1 ... What Is Data Exploration and Self-Service Analytics? ... 703

11.2 ... Introduction to SAP BusinessObjects Explorer ... 706

11.3 ... Introduction to SAP Lumira ... 719

11.4 ... Mobilizing Content with SAP BusinessObjects Explorer and SAP Lumira Based on SAP HANA Data ... 734

11.5 ... Case Study: Exploring Sales Data with SAP Lumira and SAP Busines