Acknowledgments ... 17§§Preface ...19§§PART I Introduction§§1 SAP HANA, SAP BusinessObjects BI, and SAP Data Services ...27§§1.1 What Is SAP HANA? ...28§§1.2 Business Intelligence Solutions with SAP HANA ...38§§1.3 SAP Business Suite on SAP HANA ...57§§1.4 Traditional EIM with SAP Data Services ...60§§1.5 Traditional Business Intelligence with SAP BusinessObjects BI ...62§§1.6 Solution Architectural Overview ...66§§1.7 Summary ...76§§2 Securing the SAP HANA Environment ...77§§2.1 Configuring the SAP HANA Environment for Development ...78§§2.2 SAP HANA Authorizations ...100§§2.3 User and Role Provisioning ...108§§2.4 SAP HANA Authentication ...131§§2.5 Case Study: An End-to-End Security Configuration ...139§§2.6 Summary ...152§§3 Data Storage in SAP HANA ...155§§3.1 OLAP and OLTP Data Storage ...155§§3.2 Data Storage Components ...165§§3.3 Modeling Tables and Data Marts ...175§§3.4 Case Study: Creating Data Marts and Tables for an SAP HANA Project ... 186§§3.5 Summary ... 194§§PART II Getting Data Into SAP HANA§§4 Preprovisioning Data with SAP Data Services ... 197§§4.1 Making the Case for Source System Analysis ... 197§§4.2 SSA Techniques in SAP Data Services ... 202§§4.3 SSA: Beyond Tools and Profiling ... 215§§4.4 Summary ... 222§§5 Provisioning Data with SAP Data Services ... 223§§5.1 Provisioning Data Using SAP Data Services Designer ... 223§§5.2 Introduction to SAP Data Services Workbench ... 290§§5.3 Data Provisioning via Real-Time Replication ... 305§§5.4 Summary ... 308§§6 Loading Data with SAP Data Services ... 309§§6.1 Loading Data in a Batch ... 309§§6.2 Loading Data in Real Time ... 335§§6.3 Case Study: Loading Data in a Batch ... 340§§6.4 Case Study: Loading Data in Real Time ... 389§§6.5 Summary ... 395§§PART III Multidimensional Modeling in SAP HANA§§7 Introduction to Multidimensional Modeling ... 399§§7.1 Understanding Multidimensional Models ... 400§§7.2 Benefits of SAP HANA Multidimensional Modeling ... 404§§7.3 Summary ... 411§§8 Tools and Components of Multidimensional Modeling ... 413§§8.1 SAP HANA Studio ... 413§§8.2 Schemas ... 420§§8.3 Packages ... 423§§8.4 Summary ... 426§§9 Creating SAP HANA Information Views ... 427§§9.1 Attribute Views ... 427§§9.2 Analytic Views ... 444§§9.3 Calculation Views ... 460§§9.4 Summary ... 478§§10 Multidimensional Modeling in Practice ... 479§§10.1 Data Processing in SAP HANA ... 479§§10.2 Case Study 1: Modeling Sales Data to Produce Robust Analytics ... 490§§10.3 Case Study 2: Building Complex Calculations for Executive-Level Analysis ... 515§§10.4 Summary ... 533§§11 Securing Data in SAP HANA ... 535§§11.1 Introduction to Analytic Privileges ... 536§§11.2 Creating Analytic Privileges ... 540§§11.3 Applying Analytic Privileges ... 561§§11.4 Case Study: Securing Sales Data with Analytic Privileges ... 567§§11.5 Summary ... 581§§PART IV Integrating SAP HANA with SAP Business Intelligence Tools§§12 Building Universes for SAP HANA ... 585§§12.1 SAP HANA and the Universe ... 587§§12.2 Manually Building UNX Universes for SAP HANA ... 600§§12.3 Automatically Generating UNX Universes for SAP HANA ... 642§§12.4 The SAP HANA Engines in Universe Design ... 656§§12.5 Case Study: Designing a Universe to Support Internet Sales Data ... 662§§12.6 Summary ... 689§§13 Predictive Analytics with SAP HANA ... 691§§13.1 Predictive Analysis and SAP HANA: The Basics ... 692§§13.2 Integrating with SAP HANA ... 712§§13.3 Integrating with SAP BusinessObjects BI ... 716§§13.4 Case Study 1: Clustering Analysis ... 719§§13.5 Case Study 2: Product Recommendation Rules ... 738§§13.6 Summary ... 750§§14 Professionally Authored Dashboards with SAP HANA ... 751§§14.1 SAP HANA as a Data Source for SAP BusinessObjects Dashboards ... 754§§14.2 SAP HANA as a Data Source for SAP BusinessObjects Design Studio ... 759§§14.3 Case Study: Explori Skryť popis