Implementing SAP HANA
1st Edition
Published on 21. October 2013
Book
Hardback
837 pages
978-1-59229-856-3 (ISBN)
Description
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
More details
Other editions
New editions
Jonathan Haun | Chris Hickman | Don Loden
Implementing SAP HANA
Book
02/2015
2nd Edition
SAP PRESS
€79.95
Article is exhausted; no reprint
Content
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 BusinessObjects Explorer. 735
11.6. Summary. 747
12. SAP BusinessObjects Web Intelligence Powered by SAP HANA. 749
12.1. The Road to SAP BusinessObjects Web Intelligence. 749
12.2. Comparing SAP BusinessObjects Web Intelligence and SAP Crystal Reports. 751
12.3. Manual Construction of an SQL Statement. 752
12.4. Connecting SAP BusinessObjects Web Intelligence to SAP HANA. 754
12.5. Report Optimization Features with SAP HANA. 757
12.6. Sharing Reports within SAP BusinessObjects 4.1. 766
12.7. Case Study: Exploring Sales Data with SAP BusinessObjects Web Intelligence. 773
12.8. Summary. 779
13. SAP Crystal Reports Powered by SAP HANA. 781
13.1. Implementing Solutions with SAP Crystal Reports. 783
13.2. Sharing SAP Crystal Reports with SAP BusinessObjects Enterprise. 803
13.3. Product Roadmap. 805
13.4. Case Study: Delivering Targeted Marketing with SAP Crystal Reports for Enterprise on SAP HANA. 806
13.5. Summary. 813
Appendices. 815
A. Source System Analysis with SAP Information Steward. 815
B. The Authors. 827
Index. 829