New Announcements and Updates




Implementing SAP HANA

Price:
Starting From $59.99
Product Code:
H3293
Average Rating:
( 11 product reviews )
Availability:
In stock!
Format:
Quantity:


Write your own product review

Product Details

ISBN:
978-1-59229-856-3
Author:
Don Loden, Jonathan Haun, Chris Hickman, and Roy Wells
Type:
Hardcover, 838 pages
Year:
2013

Product Description and Table of Contents

• Implement SAP HANA as a standalone data warehouse
• Integrate SAP Data Services and the SAP BusinessObjects BI tools with SAP HANA
• Benefit from step-by-step instructions, technical details, and downloadable data for every step

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.

Data Storage
See how SAP HANA has fundamentally changed data storage with column store tables that improve compression and, consequently, performance.

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.

SAP HANA Studio
Dive into SAP HANA-specific data modelling components like the attribute, analytic, and calculation views that produce quality multidimensional models.

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.

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

• 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


The Authors

Jonathan Haun, Chris Hickman, Don Loden, and Roy Wells bring over 40 cumulative years of SAP BusinessObjects BI consulting and implementation insight to the table, and have been working with SAP HANA since its debut. Predictive analytics expert Hillary Bliss also contributed to this book.

Table of Contents

  • ... 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.2.1 ... SAP NetWeaver Business Warehouse 7.3 Powered by SAP HANA ... 36
  • 1.2.2 ... SAP HANA Native ... 40
  • 1.3 ... Running the SAP Business Suite on SAP HANA ... 54
  • 1.4 ... Traditional EIM with Data Services ... 56
  • 1.4.1 ... Align IT with the Business ... 57
  • 1.4.2 ... Source System Analysis ... 58
  • 1.4.3 ... Develop a Data Model ... 58
  • 1.4.4 ... Load the Data ... 59
  • 1.5 ... Traditional Business Intelligence with SAP BusinessObjects ... 59
  • 1.5.1 ... The Semantic Layer or Universe ... 60
  • 1.5.2 ... Ad Hoc Reporting ... 61
  • 1.5.3 ... Self-Service BI ... 61
  • 1.5.4 ... IT-Developed Content ... 62
  • 1.6 ... Solution Architectural Overview ... 63
  • 1.6.1 ... SAP Data Services 4.1 ... 63
  • 1.6.2 ... SAP BusinessObjects 4.x ... 67
  • 1.6.3 ... SAP HANA 1.0 SPS5 ... 70
  • 1.7 ... Summary ... 71
  • 2 ... Storing Data in SAP HANA ... 73
  • 2.1 ... How Is Data Stored in SAP HANA? ... 73
  • 2.1.1 ... The Spinning Disk Problem ... 75
  • 2.1.2 ... Technologies Used to Combat the Problem ... 75
  • 2.2 ... SAP HANA Data Storage Components ... 83
  • 2.2.1 ... Schemas and Users ... 83
  • 2.2.2 ... Column Store Tables ... 89
  • 2.2.3 ... Row Store Tables ... 94
  • 2.2.4 ... Use Cases for Both Row and Column Store Tables ... 96
  • 2.3 ... Physical Data Modeling in SAP HANA ... 97
  • 2.3.1 ... Comparing Data Modeling Techniques ... 98
  • 2.3.2 ... Denormalized Data in SAP HANA ... 105
  • 2.3.3 ... Techniques for Denormalizing Data in SAP HANA ... 106
  • 2.4 ... Case Study: Modeling Data for an SAP HANA Project ... 109
  • 2.4.1 ... Create a Schema for the Data Mart ... 109
  • 2.4.2 ... Create the Fact Table and Dimension Tables in SAP HANA ... 111
  • 2.5 ... Summary ... 117
  • 3 ... Preprovisioning Data with SAP Data Services ... 119
  • 3.1 ... Source System Analysis ... 119
  • 3.1.1 ... Why Perform SSA? ... 121
  • 3.1.2 ... What Can Be Achieved by Analyzing a Source? ... 123
  • 3.1.3 ... Avoiding “Fast Trash” in SAP HANA ... 124
  • 3.2 ... SSA Techniques in SAP Data Services ... 124
  • 3.2.1 ... Column Profiling ... 128
  • 3.2.2 ... Relationship Profiling ... 134
  • 3.3 ... SSA: Beyond Tools and Profiling ... 138
  • 3.3.1 ... Establishing Patterns ... 140
  • 3.3.2 ... Looking Across Sources ... 142
  • 3.3.3 ... Treating Disparate Systems as One ... 142
  • 3.3.4 ... Mapping Your Data ... 143
  • 3.4 ... Summary ... 145
  • 4 ... Provisioning Your Data ... 147
  • 4.1 ... Understanding SAP Data Services ... 147
  • 4.1.1 ... Metadata ... 149
  • 4.1.2 ... Datastores ... 151
  • 4.1.3 ... Jobs ... 155
  • 4.1.4 ... Workflows ... 158
  • 4.1.5 ... Data Flows ... 168
  • 4.1.6 ... Custom Functions and Scripts ... 207
  • 4.1.7 ... File Formats ... 210
  • 4.1.8 ... Real-Time Jobs ... 214
  • 4.2 ... SAP Data Services 4.1 Workbench ... 215
  • 4.2.1 ... Supported Features ... 218
  • 4.2.2 ... Porting Data ... 219
  • 4.2.3 ... Options for Data Flow and Job Modification ... 223
  • 4.3 ... Data Provisioning via Real-Time Replication ... 224
  • 4.3.1 ... Benefits of Real-Time Replication ... 224
  • 4.3.2 ... Methods for Real-Time Replication ... 225
  • 4.3.3 ... Challenges of Denormalizing Data in Real Time ... 227
  • 4.4 ... Summary ... 228
  • 5 ... Loading Your Data ... 229
  • 5.1 ... Loading Data in Batch ... 229
  • 5.1.1 ... What Is Batch Data Loading? ... 230
  • 5.1.2 ... Methods for Batch Loading Data ... 239
  • 5.2 ... Loading Data in Real Time ... 246
  • 5.2.1 ... What Is Real-Time Loading? ... 246
  • 5.2.2 ... SAP Data Services for Real-Time Loading ... 246
  • 5.3 ... Methods to Trigger Data Loads ... 252
  • 5.3.1 ... SAP Data Services Scheduling ... 252
  • 5.3.2 ... Integration via Web Services ... 255
  • 5.3.3 ... Integration via Execution Commands ... 257
  • 5.3.4 ... Third-Party Scheduler ... 259
  • 5.4 ... Case Study: Loading Data in Batch ... 260
  • 5.4.1 ... Structure the Job ... 262
  • 5.4.2 ... Try/Catch Block ... 263
  • 5.4.3 ... Initialization ... 264
  • 5.4.4 ... Staging Workflow ... 266
  • 5.4.5 ... Build Dimension Tables in SAP HANA ... 297
  • 5.4.6 ... Build Fact Table ... 308
  • 5.4.7 ... End Script ... 311
  • 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.1.1 ... SAP HANA Studio ... 329
  • 6.1.2 ... Schemas ... 335
  • 6.1.3 ... Packages ... 338
  • 6.1.4 ... Attribute Views ... 343
  • 6.1.5 ... Analytic Views ... 358
  • 6.1.6 ... Calculation Views ... 374
  • 6.1.7 ... Analytic Privileges ... 391
  • 6.2 ... Benefits of SAP HANA Modeling ... 398
  • 6.2.1 ... Business Benefits ... 399
  • 6.2.2 ... Technology Benefits ... 402
  • 6.3 ... Methods for Modeling Analytics in SAP HANA ... 406
  • 6.3.1 ... Modeling and the Challenges Associated with Normalized Data ... 407
  • 6.3.2 ... Data Modeling versus Analytic Modeling ... 412
  • 6.3.3 ... Solutions for Normalized Data in SAP HANA ... 413
  • 6.4 ... Case Study 1: Modeling Sales Data to Produce Robust Analytics ... 416
  • 6.4.1 ... Creating the Supporting Attribute Views ... 417
  • 6.4.2 ... Creating Analytic Views ... 435
  • 6.5 ... Case Study 2: Building Complex Calculations for Executive-Level Analysis ... 443
  • 6.5.1 ... Creating the Package ... 443
  • 6.5.2 ... Creating the Calculation View ... 445
  • 6.6 ... Summary ... 460
  • 7 ... Integrating Predictive Analytics with SAP HANA ... 461
  • 7.1 ... Predictive Analytics Platform ... 462
  • 7.1.1 ... Introducing Predictive Analysis ... 462
  • 7.1.2 ... The Predictive Analysis Process ... 466
  • 7.1.3 ... When to Use Predictive Analytics ... 473
  • 7.1.4 ... Predictive Tools Available in SAP HANA ... 476
  • 7.2 ... Integrating with SAP HANA ... 482
  • 7.2.1 ... Installing the Application Function Libraries ... 482
  • 7.2.2 ... Deploying RServe ... 482
  • 7.2.3 ... Leveraging R and PAL to Produce Predictive Results ... 482
  • 7.2.4 ... Installing SAP Predictive Analysis ... 483
  • 7.2.5 ... User Privileges and Security with SAP Predictive Analysis ... 484
  • 7.3 ... Integrating with SAP BusinessObjects ... 486
  • 7.3.1 ... Exporting Scored Data Back to Databases ... 486
  • 7.3.2 ... Exporting Algorithms ... 487
  • 7.4 ... Case Study 1: Clustering Analysis ... 489
  • 7.4.1 ... Preparing the Data ... 489
  • 7.4.2 ... Performing Clustering Analysis ... 494
  • 7.4.3 ... Implementing the Model ... 502
  • 7.5 ... Case Study 2: Product Recommendation Rules ... 507
  • 7.5.1 ... Preparing the Data ... 508
  • 7.5.2 ... Performing Apriori Analysis ... 508
  • 7.5.3 ... Implementing the Model ... 513
  • 7.6 ... Summary ... 518
  • 8 ... Security in SAP BusinessObjects BI and SAP HANA ... 521
  • 8.1 ... Security Solution Concepts ... 522
  • 8.1.1 ... Authentication ... 522
  • 8.1.2 ... Authorization ... 523
  • 8.1.3 ... Authentication Methods ... 524
  • 8.2 ... Implementing an Access Control Strategy with SAP BusinessObjects BI 4.0 and SAP HANA ... 532
  • 8.2.1 ... Configuring Authentication in SAP HANA ... 532
  • 8.2.2 ... Configuring Authorization in SAP HANA ... 540
  • 8.2.3 ... Provisioning Users in SAP HANA ... 542
  • 8.2.4 ... Configuring Authentication in SAP BusinessObjects BI 4.0 ... 546
  • 8.2.5 ... Configuring Authorization in SAP BusinessObjects BI 4.0 ... 553
  • 8.2.6 ... Provisioning Users in SAP BusinessObjects BI 4.0 ... 554
  • 8.2.7 ... SAP BusinessObjects BI 4.0 End User Tools and Support for SAP HANA Authentication Methods ... 555
  • 8.3 ... Case Study: Implementing an End-to-end Security Solution for Access to Sales Data ... 556
  • 8.3.1 ... Implementing Kerberos Authentication in the SAP BusinessObjects Platform ... 557
  • 8.3.2 ... Implementing Kerberos Authentication in the SAP HANA Server ... 560
  • 8.3.3 ... Implementing Analytic Privileges and Roles ... 561
  • 8.3.4 ... Developing Script to Provision Users to SAP HANA ... 562
  • 8.4 ... Summary ... 562
  • PART III ... Business Concepts ... 565
  • 9 ... Integrating SAP BusinessObjects BI with SAP HANA ... 567
  • 9.1 ... Overview of the Universe in SAP BusinessObjects ... 571
  • 9.1.1 ... Using a Universe to Access SAP HANA Data ... 572
  • 9.1.2 ... The Two Universes in SAP BusinessObjects 4.0 ... 573
  • 9.1.3 ... Using the SAP HANA Client as Middleware ... 577
  • 9.2 ... Building UNX Universes with the Information Design Tool ... 585
  • 9.2.1 ... Creating Relational Connections ... 586
  • 9.2.2 ... Creating OLAP Connections ... 596
  • 9.2.3 ... Testing Connections Using the Local or Server Middleware ... 599
  • 9.2.4 ... Creating Projects ... 600
  • 9.2.5 ... Creating a Relational Connection in Your Project ... 602
  • 9.2.6 ... Designing the Data Foundation ... 604
  • 9.2.7 ... Designing the Business Layer ... 620
  • 9.2.8 ... Publishing the Universe ... 626
  • 9.3 ... Building UNV Universes with Universe Designer ... 628
  • 9.4 ... Understanding the SAP HANA Engines ... 629
  • 9.4.1 ... SAP HANA Join Engine ... 631
  • 9.4.2 ... SAP HANA OLAP Engine ... 632
  • 9.4.3 ... SAP HANA Calculation Engine ... 633
  • 9.5 ... Case Study: Designing a Universe to Support Internet Sales Data ... 635
  • 9.5.1 ... Creating the Universe Connection and Project ... 635
  • 9.5.2 ... Designing the Data Foundation ... 636
  • 9.5.3 ... Designing the Business Layer ... 645
  • 9.5.4 ... Publish the Universe ... 662
  • 9.6 ... Summary ... 663
  • 10 ... Professionally Authored Dashboards Powered by SAP HANA ... 665
  • 10.1 ... Introduction to Professionally Authored Dashboards ... 666
  • 10.1.1 ... Comparing Dashboards ... 668
  • 10.1.2 ... Why Use a PAD Rather Than a Report or Self-Service Dashboard? ... 668
  • 10.1.3 ... Professionally Authored Dashboards Process ... 669
  • 10.1.4 ... Professionally Authored Dashboards Outlook ... 671
  • 10.2 ... Tools for Designing Dashboards with SAP HANA ... 672
  • 10.2.1 ... SAP BusinessObjects Dashboards ... 672
  • 10.2.2 ... SAP BusinessObjects Design Studio ... 684
  • 10.2.3 ... Bringing It All Together ... 693
  • 10.3 ... Case Study: Creating a Dashboard ... 694
  • 10.3.1 ... Gathering Requirements ... 694
  • 10.3.2 ... Storyboarding ... 695
  • 10.3.3 ... Iterative Process ... 696
  • 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.1.1 ... Self-Service Access for General Business and Power Users ... 704
  • 11.1.2 ... Comparing Self-Service and Professionally Authored Content ... 705
  • 11.2 ... Introduction to SAP BusinessObjects Explorer ... 706
  • 11.2.1 ... SAP BusinessObjects Explorer System Architecture ... 707
  • 11.2.2 ... SAP BusinessObjects Explorer Workflows and How They Differ in an SAP HANA Solution ... 710
  • 11.3 ... Introduction to SAP Lumira ... 719
  • 11.3.1 ... Why Use SAP Lumira? ... 720
  • 11.3.2 ... Connecting SAP Lumira to SAP HANA ... 722
  • 11.3.3 ... Analyzing Data with SAP Lumira ... 728
  • 11.3.4 ... Merging Data Sets ... 728
  • 11.3.5 ... Sharing SAP Lumira Visualizations ... 729
  • 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.5.1 ... Business Requirements ... 735
  • 11.5.2 ... Planned Solution ... 736
  • 11.5.3 ... Delivering Data to End Users with SAP BusinesObjects Explorer ... 741
  • 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.5.1 ... Usage of JOIN_BY_SQL ... 757
  • 12.5.2 ... Merged Dimensions versus Analytic/Calculation Views ... 761
  • 12.5.3 ... Implementing Query Drill for SAP HANA ... 762
  • 12.5.4 ... Implementing Query Stripping for SAP HANA ... 764
  • 12.6 ... Sharing Reports within SAP BusinessObjects 4.1 ... 766
  • 12.6.1 ... Sharing Reports for Internal Users ... 766
  • 12.6.2 ... Sharing Reports for External Users ... 769
  • 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.1.1 ... A Tale of Two SAP Crystal Reports ... 783
  • 13.1.2 ... Using SAP Crystal Reports 2011 ... 786
  • 13.1.3 ... Using SAP Crystal Reports for Enterprise ... 794
  • 13.1.4 ... Accessing Analytic Content via ODBC/JDBC and Enterprise Relational Connections ... 800
  • 13.2 ... Sharing SAP Crystal Reports with SAP BusinessObjects Enterprise ... 803
  • 13.3 ... Product Roadmap ... 805
  • 13.3.1 ... Improved SAP HANA Connection Options ... 806
  • 13.3.2 ... Other Miscellaneous Improvements ... 806
  • 13.4 ... Case Study: Delivering Targeted Marketing with SAP Crystal Reports for Enterprise on SAP HANA ... 806
  • 13.4.1 ... Report Design ... 807
  • 13.4.2 ... Building the Report ... 807
  • 13.5 ... Summary ... 813
  • ... Appendices ... 815
  • A ... Source System Analysis with SAP Information Steward ... 815
  • A.1 ... SAP Information Steward Data Insight ... 817
  • A.2 ... Profile Your Data ... 818
  • A.3 ... Summary ... 826
  • B ... The Authors ... 827
  • ... Index ... 829



Product Reviews


Showing reviews 1-4 of 11 | Next

  1. Should be your first book on HANA

    Posted by kavitha on Mar 1st, 2014

    Very nice book .. A first source on HANA.
    A good resource for the folks venturing into HANA.
    This book in addition with several HANA resources like openSAP courses will help in cracking the certification


  2. Focused on BI Perspective,Lacks on Native Hana Development

    Posted by Manas on Feb 8th, 2014

    This book comprehensively explains the basic concepts,but soon diverts the focus on HANA and BI integration.It does explains the various concepts in details but has limited screenshots.
    It Lacks severely on Native HANA development concepts (other than modelling Views) and latest concepts related to lifecycle management,webtools,ABAP on Hana etc.

    Go for it if you are looking for a SAP BI oriented content.


  3. Good Read

    Posted by Chanukya Reddy on Feb 2nd, 2014

    This book is a good read. I would suggest this to someone who wants to have a holistic view on HANA.


  4. Nice Book ...

    Posted by Raj on Feb 1st, 2014

    Nice book..but lacks detailed explanation on various concepts....


Showing reviews 1-4 of 11 | Next

Write your own product review
If you have purchased this book you can share your experience with others!
review guidelines

Recently Viewed