Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
 Search:   
Call our store: 9955 5567 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
 
Browse by Subject
 TAFE Accounting
 TAFE I.T./Computing
 TAFE - Other
I.T
 .NET
 Windows 8
 Adobe CS6
 Cisco
 CCNA 2012
 CCNP 2012
 Java
 VB
 ASP
 Web Design
 E-Commerce
 Project Management
 ITIL
 Macintosh
 Mobile Devices
 Linux
 Windows Server 2012
 SQL Server 2012
 SAP
Certification
 MCITP
 MCTS
Economics and Business
 Accounting
 Business Information Systems
 Economics
 Finance
 Management
 Marketing
 TAX
 Human Resources
Academic
 Law
 Nursing
 Medical
 Psychology
 Engineering

SAP HANA: An Introduction

by: Bjarne Berg and Penny Silvia

Notify me when in stock

On-line Price: $101.95 (includes GST)

Paperback package 428

15%Off Retail Price

You save: $18.00

This is an old edition. There is a new edition of this book available. In many cases publishers substitute to newer editions automatically...

Only order if you require this exact edition.

Retail Price: $119.95

Publisher: SAP Press,10.10.12

Category: SAP Level:

ISBN: 1592294340
ISBN13: 9781592294343

Add to Shopping Cart

THIS IS AN OLD EDITION. FOR THE CURRENT EDITION, PLEASE PERFORM A NEW SEARCH USING THE FOLLOWING ISBN13: 9781592298655

What SAP HANA is, whether it's the right fit for your business, and how to plan an installation
Detailed, step-by-step instructions for data modeling with SAP HANA Studio and Information Composer
Data provisioning with SAP Data Services and other tools

With any new product, it's not always easy to get straightforward information. Is SAP HANA a database or an appliance? Can you use it with non-SAP BI tools? How do you build views and replicate data? In this book, get the information you need with advice and instruction from SAP HANA experts who have demonstrable knowledge, practical experience, and no agenda. Here's your chance: Separate the hype from the facts, and the roadmap from the reality.

Scenarios and Business Strategies
Learn what SAP HANA is and the flavors it comes in. Then learn how to build a business strategy with advice about skills requirements, budgeting, and how it all fits in with your existing landscape.

Planning an Installation
Know the information you need to plan an SAP HANA installation: sizing, hardware and software requirements, and migration considerations.

Data Modeling with Information Composer and Studio
Dive deep into the main SAP HANA tools, with step-by-step directions and hundreds of screenshots that will have you building views, hierarchies, and more.

Data Provisioning
Master data provisioning with specific instructions on trigger-based replication, ETL-based replication, log-based replication, and the Direct Extraction Connection.

Administration
Take a look into the SAP HANA Administration Console and understand the most important administrative tasks in an SAP HANA system.
Highlights


  SAP HANA scenarios and use cases


  BWA vs. SAP HANA


  Hardware and software requirements


  Sizing


  SAP HANA-optimized InfoProviders


  SAP BusinessObjects BI 4.0


  Information Composer


  SAP HANA Studio


  SAP Data Services


  SAP System Landscape Transformation


  Sybase Replication Server


  DXC


  SAP HANA Administration Console

The Authors

Dr. Berg teaches at Lenoir Rhyne University and is VP at ComeritLabs, where he has tested and developed SAP HANA implementations. Penny Silvia is IBM's go-to-market leader for SAP Analytics, and helps clients understand and develop SAP HANA strategies and implementation plans.
Table of Contents


  ... Foreword ... 15


  ... Preface ... 17li>


  ... Acknowledgments ... 19


  PART I ... What, Why, and When ... 21


  1 ... In-Memory Computing, Big Data, and SAP HANA ... 23


  1.1 ... Introduction to In-Memory Computing and Big Data ... 23


  1.1.1 ... In-Memory Computing and Analytics ... 23


  1.1.2 ... Big Data ... 26


  1.2 ... Introduction to SAP HANA ... 30


  1.2.1 ... SAP HANA as in In-Memory Computing Solution ... 31


  1.2.2 ... SAP HANA as an Enabler of Big Data Solutions ... 35


  1.2.3 ... SAP HANA Capabilities ... 38


  1.2.4 ... SAP HANA Adoption Drivers ... 41


  1.3 ... Getting Started with SAP HANA ... 42


  1.4 ... Summary ... 46


  2 ... SAP HANA Versions ... 47


  2.1 ... SAP HANA Standalone Version ... 47


  2.1.1 ... Technical Requirements ... 48


  2.1.2 ... Skills Requirements ... 51


  2.1.3 ... Project Plan Steps ... 55


  2.2 ... SAP HANA for SAP NetWeaver BW ... 57


  2.2.1 ... Technical Requirements ... 58


  2.2.2 ... Skills Requirements ... 60


  2.2.3 ... Project Plan Steps ... 64


  2.3 ... Summary ... 66


  3 ... SAP HANA Use Cases ... 67


  3.1 ... Do Something New ... 68


  3.2 ... Do Something Faster ... 71


  3.3 ... Which SAP HANA Version Is Right for You? ... 74


  3.3.1 ... Choosing SAP HANA as a Standalone System ... 76


  3.3.2 ... Choosing SAP HANA for BW ... 77


  3.3.3 ... Final Thoughts ... 78


  3.4 ... Summary ... 78


  4 ... SAP HANA and Your Business Strategy ... 79


  4.1 ... Identifying Transformational Opportunities ... 81


  4.2 ... Understanding Your Needs ... 84


  4.2.1 ... Enterprise Needs ... 84


  4.2.2 ... Data Needs ... 86


  4.3 ... Working with Existing Solutions: SAP HANA versus SAP NetWeaver BWA ... 90


  4.3.1 ... Does SAP HANA Replace BWA? ... 90


  4.3.2 ... Pros and Cons of BWA ... 92


  4.3.3 ... Pros and Cons of SAP HANA ... 94


  4.3.4 ... Conclusion ... 97


  4.4 ... Writing a Business Case, Budgeting, and Staffing for SAP HANA ... 98


  4.4.1 ... Writing a Business Case ... 99


  4.4.2 ... Budgeting for an SAP HANA Implementation ... 103


  4.4.3 ... Staffing an SAP HANA Implementation ... 106


  4.4.4 ... Building a Roadmap ... 108


  4.5 ... Frequently Asked Questions about SAP HANA ... 111


  4.5.1 ... Is SAP HANA a Database, Hardware, or a Solution? ... 111


  4.5.2 ... What Type of Customer is Looking at SAP HANA Solutions? ... 112


  4.5.3 ... What Are the Problem Statements that Identify a Need for SAP HANA? ... 112


  4.5.4 ... What Is the Differentiator for SAP with SAP HANA? ... 112


  4.5.5 ... What Is SAP Envisioning for the Future of SAP HANA? ... 113


  4.5.6 ... Is SAP HANA Plug and Play? ... 113


  4.5.7 ... Can Non-SAP Business Intelligence Tools Work on Top of SAP HANA? ... 113


  4.5.8 ... What Does a Customer Need to Buy to Use SAP HANA? ... 114


  4.5.9 ... How Much Does SAP HANA Cost? ... 114


  4.5.10 ... Does SAP HANA Replace BWA for Customers? ... 115


  4.5.11 ... Is SAP HANA Just Another SAP Fad That Will Not Have a Long Lifespan-Like mySAP? ... 115


  4.6 ... Summary ... 115


  PART II ... How ... 117


  5 ... Planning an SAP HANA Installation ... 119


  5.1 ... In-Memory Computing Engine (IMCE) ... 119


  5.2 ... Sizing Your System ... 120


  5.2.1 ... SAP Quick Sizer for SAP HANA ... 121


  5.2.2 ... Some Quick Sizing Rules to Follow ... 126


  5.2.3 ... SAP's T-Shirt Sizing Model for SAP HANA ... 127


  5.3 ... Software and Technical Requirements ... 129


  5.4 ... Row versus Column Indexes and the Persistency Layer ... 133


  5.5 ... Hardware Options ... 138


  5.6 ... Special Considerations for Planning an SAP HANA for BW Installation ... 140


  5.6.1 ... SAP HANA-Optimized InfoCubes ... 141


  5.6.2 ... SAP HANA-Optimized Data Store Objects (DSOs) ... 144


  5.6.3 ... The Future of InfoCubes ... 145


  5.7 ... Summary ... 146


  6 ... SAP HANA and the SAP Business­Objects BI Platform ... 147


  6.1 ... Overview of the SAP Business­Objects Tools ... 147


  6.1.1 ... SAP Business­Objects Dashboards (Xcelsius) ... 148


  6.1.2 ... SAP Business­Objects Web Intelligence ... 149


  6.1.3 ... SAP Business­Objects Explorer ... 150


  6.1.4 ... SAP Business­Objects Analysis ... 151


  6.1.5 ... SAP Business­Objects Design Studio ... 153


  6.1.6 ... SAP Crystal Reports ... 153


  6.2 ... Connecting SAP Business­Objects BI Tools to SAP HANA ... 155


  6.2.1 ... Universes with Open and Java Database Connections (ODBC/JDBC) ... 155


  6.2.2 ... IDT Access to Attributes, Calculations, and Analytical Views ... 163


  6.2.3 ... Connecting to Excel with Open Database Objects (ODO) and MDX ... 164


  6.2.4 ... Building a Microsoft Query on SAP HANA ... 168


  6.2.5 ... BICS Connections ... 169


  6.2.6 ... Connectivity Summary ... 169


  6.3 ... Going Mobile with SAP HANA and SAP Business­Objects ... 170


  6.4 ... Summary ... 171


  7 ... Data Modeling with Information Composer ... 173


  7.1 ... Getting Started with Information Composer ... 175


  7.1.1 ... Functionality ... 176


  7.1.2 ... Example Scenario ... 178


  7.2 ... Uploading Data to SAP HANA ... 180


  7.2.1 ... Specifying the Data Source and Loading Data ... 180


  7.2.2 ... Cleansing the Data ... 184


  7.2.3 ... Classifying Data Columns ... 188


  7.2.4 ... Saving the Data ... 190


  7.3 ... Composing Information Views ... 191


  7.3.1 ... Specifying Data Sources ... 192


  7.3.2 ... Combining Data ... 196


  7.4 ... Viewing Uploaded Data and Composed Information Views ... 203


  7.4.1 ... My Data Screen Area ... 203


  7.4.2 ... My Information Views Screen Area ... 204


  7.5 ... Summary ... 205


  8 ... Data Modeling with SAP HANA Studio ... 207


  8.1 ... SAP HANA Studio Overview and Terminology ... 207


  8.2 ... Getting Started with SAP HANA Information Modeler ... 212


  8.2.1 ... Adding a System ... 214


  8.2.2 ... Opening Perspectives ... 217


  8.2.3 ... Using Quick Launch ... 218


  8.2.4 ... Creating a Package ... 219


  8.2.5 ... Example Scenario ... 220


  8.3 ... Building Attribute Views ... 221


  8.3.1 ... Creating an Attribute View ... 221


  8.3.2 ... Defining Table Joins ... 225


  8.3.3 ... Defining Output ... 231


  8.3.4 ... Checking, Saving, and Activating Views ... 233


  8.3.5 ... Creating the Time Attribute View ... 235


  8.4 ... Building Analytic Views ... 237


  8.4.1 ... Creating an Analytic View ... 238


  8.4.2 ... Copying an Analytic View ... 248


  8.5 ... Building Calculation Views Using the Graphical Method ... 249


  8.6 ... SQL and SQLScript ... 260


  8.6.1 ... Using SQL ... 260


  8.6.2 ... Using SQLScript ... 267


  8.7 ... Summary ... 272


  9 ... Advanced Concepts in SAP HANA Studio ... 275


  9.1 ... Derived Attribute Views ... 275


  9.2 ... Calculated Attributes ... 281


  9.3 ... Restricted and Calculated Measures ... 284


  9.4 ... Filter and Variable Operations ... 290


  9.4.1 ... Filters ... 290


  9.4.2 ... Variables and Input Parameters ... 299


  9.5 ... Currency Conversion ... 304


  9.5.1 ... Using an Input Parameter to Specify Target Currency ... 307


  9.5.2 ... Linking Measures with Currencies without Using Conversion ... 308


  9.6 ... Hierarchies ... 309


  9.6.1 ... Creating a Leveled Hierarchy ... 310


  9.6.2 ... Creating a Parent-Child Hierarchy ... 314


  9.7 ... Personalizing Studio ... 317


  9.7.1 ... Model Validation ... 317


  9.7.2 ... Versioning ... 318


  9.7.3 ... Checking Model References ... 319


  9.7.4 ... Customizing Perspectives ... 320


  9.8 ... Summary ... 323


  10 ... Data Provisioning ... 325


  10.1 ... Choosing a Data Provisioning Method ... 326


  10.1.1 ... Strategic Considerations ... 328


  10.1.2 ... Technical Considerations ... 335


  10.2 ... Trigger-Based Replication: SAP Landscape Transformation ... 338


  10.2.1 ... Installation ... 338


  10.2.2 ... How SLT Works ... 340


  10.2.3 ... SLT Configuration ... 342


  10.2.4 ... SLT Administration (Start, Replicate, Stop, Suspend, Resume) ... 343


  10.2.5 ... Extended Features ... 345


  10.3 ... ETL-Based Replication: SAP Data Services ... 349


  10.3.1 ... Configuration Requirements ... 350


  10.3.2 ... Preparing SAP HANA to Receive Data from SAP Data Services ... 350


  10.3.3 ... Loading Data ... 353


  10.4 ... Log-Based Replication: Sybase Replication Server and Load Controller ... 358


  10.4.1 ... Installation ... 360


  10.4.2 ... Running Sybase Replication ... 361


  10.5 ... Direct Extractor Connection ... 361


  10.5.1 ... DXC Technology ... 362


  10.5.2 ... Important Considerations for the Use of DXC ... 365


  10.5.3 ... Preparing SAP HANA for Use with DXC ... 368


  10.5.4 ... Preparing the Source System for Use with DXC ... 370


  10.5.5 ... Loading Data to SAP HANA with DXC ... 370


  10.6 ... Summary ... 371


  11 ... SAP HANA Administration ... 373


  11.1 ... Main Administration Tasks ... 374


  11.1.1 ... Adding Systems ... 375


  11.1.2 ... Exporting and Importing Systems ... 377


  11.1.3 ... Viewing System Installation Details ... 377


  11.1.4 ... Administrator Editor and Diagnosis Mode ... 379


  11.1.5 ... Changing File Locations ... 380


  11.1.6 ... Changing Configurations ... 380


  11.1.7 ... Modifying the Administration Console ... 381


  11.2 ... SAP HANA System Monitoring ... 381


  11.2.1 ... Monitoring Disk Usage ... 383


  11.2.2 ... Performance Monitoring ... 384


  11.2.3 ... Monitoring with Alerts ... 385


  11.2.4 ... Configuring Alerts ... 385


  11.2.5 ... Monitoring Services and Distributed Systems ... 386


  11.2.6 ... Exporting and Importing Table Data and Definitions ... 388


  11.2.7 ... Monitoring Memory Usage ... 389


  11.2.8 ... Moving Files for Load Balancing ... 390


  11.2.9 ... Fixing a Full Disk Event ... 391


  11.2.10 ... Support for Unresponsive Systems ... 391


  11.3 ... Updates ... 392


  11.3.1 ... Updating the SAP HANA Appliance ... 392


  11.3.2 ... Updating SAP HANA Studio ... 392


  11.4 ... Security and License Keys ... 393


  11.4.1 ... System Privileges ... 393


  11.4.2 ... Authentication Security ... 394


  11.4.3 ... Authorization Security ... 395


  11.4.4 ... License Keys ... 400


  11.5 ... Failover and High Availability ... 403


  11.6 ... Summary ... 404


  ... Appendices ... 405


  A ... SAP HANA Rapid Deployment Solutions ... 407


  A.1 ... SAP CO-PA Accelerator ... 407


  A.2 ... Operational Reporting RDS ... 408


  A.3 ... Summary ... 409


  B ... Pre-Configured Data Modeling Content for SAP HANA ... 411


  B.1 ... SAP Business­Objects Rapid Marts ... 411


  B.2 ... Accelerators ... 411


  B.3 ... Rapid Deployment Solutions ... 415


  C ... The Authors ... 419


  ... Index ... 421