SAP HANA Cookbook -- Table of Contents -- SAP HANA Cookbook -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. SAP HANA Studio - Look and Feel -- Introduction -- Understanding SAP HANA Studio -- How it works… -- There's more… -- Platforms supported -- System requirements -- Installation paths -- See also -- Switching between different views - perspectives -- Getting ready -- How it works… -- How to do it… -- There's more… -- See also -- Navigating SAP HANA Studio - the Navigator Pane -- Getting ready -- How it works… -- System Monitor -- Administration -- SQL Console -- Find Table -- Find System -- Link with Editor -- There's more… -- See also -- Administering SAP HANA - the Administration Console perspective -- Getting ready -- How to do it… -- Adding a system -- There's more… -- Overview -- Landscape -- Services -- Configuration -- Redistribution Operations -- Alerts -- Performance -- Volumes -- Configuration -- System Information -- Diagnosis Files -- Trace Configuration -- See also -- Modeling SAP HANA Studio - the Modeler perspective -- Getting ready -- How it works… -- There's more… -- Information views -- SQLScript -- See also -- 2. Data Provisioning -- Introduction -- Loading data into SAP HANA - data provisioning methods -- Getting ready -- How to do it… -- How it works… -- SAP Landscape Transformation -- SAP Data Services -- Sybase replication -- There's more… -- Strategic considerations -- Technical considerations -- See also -- Uploading data from flat files -- Getting ready.

How to do it… -- Step 1 - creating a table in the SAP HANA system -- Step 2 - selecting the source file and target table in SAP HANA -- Step 3 - field mapping and loading data -- How it works… -- There's more… -- See also -- Using SLT to load data into SAP HANA -- Getting ready -- How to do it… -- SLT configuration - creating a connection -- How it works… -- Logging tables -- Read module -- Control module -- Write module -- There's more… -- See also -- Using SAP Data Services as an ETL tool to load data into SAP HANA -- Getting ready -- How to do it… -- Creating table in SAP HANA using the import of metadata option -- Step 1 - Creating a datastore for the source system in SAP Data Services -- Step 2 - Importing tables in SAP DS for the datastore created -- Step 3 - Configuring Import Server from the Quick Launch screen of SAP HANA Studio -- Step 4 - Importing metadata from SAP HANA Studio -- Creating a datastore for a target system - SAP HANA in SAP Data Services -- Creating a project -- Creating a job -- Creating a workflow -- Creating a data flow -- Designing the data flow -- Validating the data flow and saving the project -- Executing the job -- How it works… -- There's more… -- See also -- Loading data into SAP HANA using DXC -- Getting ready -- How to do it… -- Configuring DXC -- Loading data to SAP HANA -- How it works… -- An SAP source system on SAP NetWeaver Version 7.0 or higher, using the embedded SAP NetWeaver BW system -- An SAP source system on a version below SAP NetWeaver 7.0, using a side-by-side SAP NetWeaver BW system -- There's more… -- The Sidecar approach -- See also -- Loading data using SAP Sybase Replication Server -- Getting ready -- How to do it… -- Oracle to SAP HANA Replication setup -- Prerequisites -- Configuring Replication Server to SAP HANA -- Creating a Replication Server connection to the primary database.

Testing the replication -- How it works… -- There's more… -- See also -- 3. Modeling -- Introduction -- Approaching SAP HANA modeling -- Getting ready -- How to do it… -- How it works… -- See also -- Creating attribute views -- Getting ready -- How to do it… -- Creating a package -- Creating an attribute view -- How it works… -- There's more… -- See also -- Creating analytic views -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating calculation views -- Getting ready -- How to do it… -- Creation of a calculation view using GUI -- Creation of a calculation view using SQLScript (native SQL or CE functions) -- How it works… -- See also -- Preparing documents - Auto Documentation -- How to do it… -- Model Details -- Model List -- How it works… -- Modeling with Information Composer -- Getting ready -- How to do it… -- Uploading data -- Selecting a data source and loading data into Information Composer -- Data cleansing -- Merging values -- Changing values -- Classification of data columns into attributes and measures -- Saving data into SAP HANA -- Composing information views -- Selecting data sources - Source A and Source B -- Combining data -- Refining the data -- Saving the view to SAP HANA and publishing -- How it works… -- There's more… -- My Data -- My Information Views -- See also -- 4. Reporting -- Introduction -- The reporting layer on top of SAP HANA -- How to do it… -- How it works… -- There's more… -- See also -- Connecting reporting tools to SAP HANA -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating reports using SAP BusinessObjects Web Intelligence -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating reports using SAP BusinessObjects Explorer -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also.

Creating reports using SAP BusinessObjects Dashboards/Xcelsius -- Getting ready -- How to do it… -- How it works… -- See also -- Creating reports using SAP BusinessObjects Analysis for OLAP -- How to do it… -- How it works… -- There's more… -- See also -- Creating reports using Microsoft Excel -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating reports in SAP Lumira -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- 5. Advanced Features in SAP HANA -- Introduction -- Converting different currencies -- How to do it… -- How it works… -- See also -- Creating hierarchies -- How to do it… -- Level hierarchy -- The parent-child hierarchy -- How it works… -- See also -- Creating variables -- Getting ready -- How to do it… -- How it works… -- See also -- Creating input parameters -- Getting ready -- How to do it… -- How it works… -- See also -- Creating filters -- How to do it… -- How it works… -- There's more… -- Creating procedures using SQLScript -- Getting ready -- How to do it… -- How it works… -- See also -- Creating decision tables -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- 6. User Management -- Introduction -- Creating users -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating roles -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Assigning roles to users -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Restricting access to data - creating analytic privileges -- Getting ready -- How to do it… -- How it works… -- See also -- Securing logging in to SAP HANA - authentication methods -- How to do it… -- How it works… -- See also -- Securing logging in to SAP HANA - privileges -- Getting ready -- How to do it… -- How it works….

A. Introduction to SAP HANA -- Introduction -- Explaining traditional databases and bottlenecks -- How it works… -- Traditional databases -- There's more… -- Bottlenecks -- Latency -- Cost -- Architecture -- See also -- Introducing technology and hardware innovations -- How it works… -- Depth of data -- Broadness -- Real time -- Simplicity -- Retrieval speed -- There's more… -- Multicore CPUs -- Parallel processing -- Data compression -- See also -- Looking into versions and technical requirements -- How it works… -- Enterprise HANA -- Technical requirements -- SAP NetWeaver BW powered by SAP HANA -- Technical requirements -- There's more… -- Server -- RAM -- Log storage -- Data storage -- See also -- Describing why you should use SAP HANA -- Getting ready -- How it works… -- Traditional versus in-memory -- There's more… -- See also -- Looking into SAP HANA features -- Getting ready -- How to do it… -- Alignment of business and IT -- More efficient data processing -- Business analytic applications powered by technology -- Powerful analytic appliance - real-time insight -- How it works… -- A multi-engine query processing environment -- Representation of application-speci c business objects -- Development of current hardware innovations -- Direct access to ERP -- Direct access to other (non-SAP) systems -- There's more… -- Leveraging BI capabilities -- Comparing BWA and SAP HANA -- Evolution of SAP BWA and SAP HANA -- How it works… -- Comparison -- See also -- B. Architecture -- Understanding the SAP HANA architecture -- Explaining IMCE and its components -- Further reading -- Session management -- Transaction manager -- Metadata manager -- Persistence layer -- Authorization manager -- Storing data - row storage -- Storing data - column storage -- The delta merge process -- Consistent view manager and transaction manager.

Understanding the persistence layer.