New Announcements and Updates




SAP HANA: An Introduction

Price:
Starting From $59.99
Product Code:
H3256
Average Rating:
( 18 product reviews )
Availability:
Discontinued THIS PRODUCT HAS BEEN REPLACED BY A NEW EDITION! CLICK HERE TO VIEW THE LATEST VERSION.


Write your own product review

Product Details

ISBN:
978-1-59229-434-3
Author:
Bjarne Berg and Penny Silvia
Type:
Hardcover, 428 pages
Year:
2012

Product Description and Table of Contents

  • 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

    

    Product Reviews


    Showing reviews 1-4 of 18 | Next

    1. Posted by Anonymous on Apr 27th, 2013

      My first HANA book, and it's a good choice for the beginner.


    2. Newest Technology

      Posted by Srivastava.G on Apr 27th, 2013

      More information on the newest technology by SAP Experts themselves. Must for HANA Consultants.


    3. Outstanding

      Posted by sapelk on Apr 26th, 2013

      This is the best book on HANA. I struggled to understand the concept, but when i read this book..... I'm beginning to feel like a guru.


    4. Resourceful

      Posted by Rosario on Apr 3rd, 2013

      I am glad that I invested on this book recently. This book narrates the emerging technology in a simple language. It was very helpful to understand and put HANA in its correct perspective in the Corporate IT Landscape. Though I've finished only a few chapters so far, I am sure that this book is much resourceful.


    Showing reviews 1-4 of 18 | Next

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

    Find Similar Products by Category


    Recently Viewed