Index
A
- Administration Console perspective / How it works…
- about / Administering SAP HANA – the Administration Console perspective, How to do it…
- System, adding / Adding a system, There's more…
- Overview tab / Overview
- services category / Services
- Configuration / Configuration
- redistribution operations / Redistribution Operations
- alerts / Alerts
- performance related process / Performance
- Volumes tab / Volumes
- Configuration tab / Configuration
- System Information tab / System Information
- diagnosis files / Diagnosis Files
- Trace Configuration / Trace Configuration
- Administration option / Administration
- aggregation / Creation of a calculation view using GUI
- analytic privileges
- creating / Restricting access to data – creating analytic privileges, How to do it…, How it works…
- URL / See also
- analytic views
- creating / Creating analytic views, How to do it…, There's more…
- appliance solution / Enterprise HANA
- application layer / Architecture
- atomic transaction / Transaction manager
- attribute views
- creating / Creating attribute views, Creating an attribute view, How it works…
- types / Creating an attribute view
- creating, steps for / Creating an attribute view
- attribute views, types
- standard / Creating an attribute view
- time / Creating an attribute view
- copy from / Creating an attribute view
- derived / Creating an attribute view
- authentication
- authorization manager
- about / Authorization manager
- auto-documentation
- about / Preparing documents – Auto Documentation, How to do it…
- model details / Model Details
- model list / Model List
B
- backup
- bottlenecks
- about / Bottlenecks
- Business Analytic Engine (BAE)
- Business Information Warehouse (BW) / Getting ready
- business layer
- creating / How to do it…
C
- Calculation Engine (CE) / Creation of a calculation view using SQLScript (native SQL or CE functions)
- calculation views
- creating / Creating calculation views, How to do it…
- creating, GUI used / Creation of a calculation view using GUI
- creating, SQLScript used / Creation of a calculation view using SQLScript (native SQL or CE functions), How it works…
- CE functions
- used, for creating calculation view / Creation of a calculation view using SQLScript (native SQL or CE functions)
- Central Management Console (CMC) / How to do it…
- CE_AGGREGATION / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_CALC / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_CALC_VIEW / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_COLUMN_TABLE / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_CONVERSION / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_JOIN / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_JOIN_VIEW / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_LEFT_OUTER_JOIN / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_OLAP_VIEW / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_PROJECTION / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_RIGHT_OUTER / Creation of a calculation view using SQLScript (native SQL or CE functions)
- CE_UNION_ALL / Creation of a calculation view using SQLScript (native SQL or CE functions)
- clickstreams / Traditional databases
- clients
- URL / See also
- column / How it works…
- column-based store engine / Further reading
- configuration, DXC / Configuring DXC
- configuration, Import Server / Step 3 – Configuring Import Server from the Quick Launch screen of SAP HANA Studio
- configuration, Sybase replication / Configuring Replication Server to SAP HANA
- Configuration tab / Configuration
- consistent view manager
- control module / Read module, Control module
- currency conversion
- about / Converting different currencies, How to do it…, How it works…
- URL / See also
D
- dashboard
- URL / See also
- data
- access, restricting / Restricting access to data – creating analytic privileges, How to do it…, How it works…
- depth / Depth of data
- broadness / Broadness
- simplicity / Simplicity
- retrieval speed / Retrieval speed
- row storage / Storing data – row storage
- column storage / Storing data – column storage
- data, information composer
- uploading / Uploading data
- source, selecting / Selecting a data source and loading data into Information Composer
- loading / Selecting a data source and loading data into Information Composer
- cleansing / Data cleansing
- saving, in SAP HANA / Saving data into SAP HANA
- database layer / Architecture
- data cleansing, information composer
- values, merging / Merging values
- values, changing / Changing values
- data flow
- creating / Creating a data flow
- designing / Designing the data flow
- validating / Validating the data flow and saving the project
- data foundation
- creating / How to do it…
- Data Foundation section / How to do it…
- data provisioning
- about / Introduction
- methods / Loading data into SAP HANA – data provisioning methods, How to do it…
- strategic considerations / Strategic considerations
- technical considerations / Technical considerations
- from flat files / Uploading data from flat files, Step 3 – field mapping and loading data, How it works…, There's more…
- SLT, used for / Using SLT to load data into SAP HANA, How it works…, Control module, There's more…
- SAP Data Services, using for / Using SAP Data Services as an ETL tool to load data into SAP HANA
- DXC, using for / Loading data into SAP HANA using DXC, Getting ready, Loading data to SAP HANA
- Sybase replication, using / Getting ready, How to do it…, How it works…, There's more…
- data provosioning
- SAP Data Services, using for / How it works…
- data replication
- about / SLT configuration – creating a connection
- architecture / How it works…
- datastore
- creating, in SAP Data Services / Step 1 – Creating a datastore for the source system in SAP Data Services
- creating, for SAP HANA system / Creating a datastore for a target system – SAP HANA in SAP Data Services
- project, creating / Creating a project
- job, creating / Creating a job
- workflow, creating / Creating a workflow
- data flow, creating / Creating a data flow
- data flow, designing / Designing the data flow
- data flow, validating / Validating the data flow and saving the project
- project, saving / Validating the data flow and saving the project
- job, executing / Executing the job
- DataStore Object (DSO) / Getting ready
- Debug perspective / How it works…
- decision tables
- creating / Creating decision tables, How to do it…, How it works…
- URL / See also
- delta merge process
- about / The delta merge process
- depth of data / Depth of data
- derived from table / How it works…
- direct / How it works…
- DXC
- about / Loading data into SAP HANA using DXC
- using, for data provisioning / Loading data into SAP HANA using DXC, Getting ready, Loading data to SAP HANA
- configuring / Configuring DXC, Loading data to SAP HANA
- deployment option / How it works…, An SAP source system on a version below SAP NetWeaver 7.0, using a side-by-side SAP NetWeaver BW system
- implementing, consideration / An SAP source system on a version below SAP NetWeaver 7.0, using a side-by-side SAP NetWeaver BW system
E
- Eclipse perspectives
- about / How it works…
- Modeler / How it works…
- SAP HANA Development / How it works…
- Debug / How it works…
- Administration Console / How it works…
- Lifecycle Management / How it works…
- Enterprise HANA
- about / Enterprise HANA
- technical requisites / Technical requirements
- ExpressConnect for HANA (ECH) / Prerequisites
F
- field mapping
- filters
- creating / Creating filters, How to do it…, How it works…
- Find System option / Find System
- Find Table option / Find Table
- flat files
- data provisioning from / Uploading data from flat files, Step 3 – field mapping and loading data, How it works…, There's more…
- full, join type / How it works…
G
- GRANT statement / See also
- GUI
- used, for calculation view / Creation of a calculation view using GUI
H
- hardware
- innovations / Introducing technology and hardware innovations
- hierarchies
- creating / Creating hierarchies
- leveled hierarchy / Level hierarchy
- parent-child hierarchy / The parent-child hierarchy, How it works…
- URL / See also
- High-Performance Analytic Appliance (HANA)
- about / Introduction
I
- IMCE
- about / Explaining IMCE and its components
- capabilities / Explaining IMCE and its components
- Import Server
- In-Memory DataStore Object (IMDSO) / Configuring DXC
- index / Storing data – row storage
- index server
- information composer
- about / Modeling with Information Composer
- data, uploading / Uploading data
- data source, selecting / Selecting a data source and loading data into Information Composer
- data, loading / Selecting a data source and loading data into Information Composer
- data, cleansing / Data cleansing
- data columns, classifying / Classification of data columns into attributes and measures
- data, saving into SAP HANA / Saving data into SAP HANA
- Information Design Tool (IDT) / How it works…
- information views
- Attribute View / Information views
- Analytic View / Information views
- Calculation View / Information views
- features / SQLScript
- information views, composing
- about / Composing information views
- data sources, selecting / Selecting data sources – Source A and Source B
- data, combining / Combining data
- data, refining / Refining the data
- inner, join type / How it works…
- input parameters
- creating / Creating input parameters, How to do it…
- URL / See also
J
- JavaScript perspective / See also
- job
- creating / Creating a job
- executing / Executing the job
- join / Creation of a calculation view using GUI, Combining data
- join type
- inner / How it works…
- referential / How it works…
- left outer / How it works…
- right outer / How it works…
- full / How it works…
- text / How it works…
K
- Kerberos authentication / How it works…
L
- left outer, join type / How it works…
- leveled hierarchy
- about / Level hierarchy
- Lifecycle Management perspective / How it works…
- Link with Editor option / Link with Editor
- LM-structure
- logging tables / Logging tables
M
- massively parallel processing (MPP)
- Massive Parallel Processing (MPP) / SAP NetWeaver BW powered by SAP HANA
- metadata
- importing, from SAP HANA Studio / Step 4 – Importing metadata from SAP HANA Studio
- metadata manager
- about / Metadata manager
- Microsoft Excel
- used, for creating reports / Creating reports using Microsoft Excel, How to do it…, How it works…, There's more…, See also
- URL / See also
- model details
- about / Model Details, How it works…
- Modeler perspective
- about / How it works…, Modeling SAP HANA Studio – the Modeler perspective, How it works…, There's more…
- diagram / How it works…
- information views / Information views
- SQL Script / SQLScript
- model list
- about / Model List, How it works…
- multi-version concurrency control (MVCC / Metadata manager
- My Data
- about / My Data
- My Information Views
- about / My Information Views
N
- name server
- Navigator Pane
- used, for SAP HANA Studio navigation / Navigating SAP HANA Studio – the Navigator Pane, Getting ready
- system, monitoring / System Monitor
- administration / Administration
- SQL Console option / SQL Console
- Find Table option / Find Table
- Find System option / Find System
- Link with Editor option / Link with Editor
O
- OLAP
- SAP BusinessObjects Analysis, used for creating reports / Creating reports using SAP BusinessObjects Analysis for OLAP, How to do it…
- Online Analytical Processing (OLAP) / Further reading
- Online Analytical Processing (OLAP) engine / How it works…
- Online Transactional Processing (OLTP) / Further reading
- Open Perspective / How to do it…
P
- package
- creating / Creating a package
- package privileges / How it works…
- page manager / Storing data – row storage
- parent-child hierarchy
- about / The parent-child hierarchy, How it works…
- persisted segment / Storing data – row storage
- persistence layer
- about / Persistence layer
- persistent layer
- PlanViz perspective / There's more…
- Plugin perspective / See also
- preprocessor server
- presentation layer / Architecture
- privileges
- about / Getting ready
- SQL privileges / How it works…
- system privileges / How it works…
- package privileges / How it works…
- analytic privileges / How it works…
- procedures
- creating, SQLScript used / Creating procedures using SQLScript, How to do it…, How it works…
- project
- creating / Creating a project
- saving / Validating the data flow and saving the project
- projection / Creation of a calculation view using GUI
Q
- Query as a Web Service (QAWS) / How it works…
R
- Random Access Memory (RAM) / Explaining IMCE and its components
- read module / Read module
- referential, join type / How it works…
- reporting layer / The reporting layer on top of SAP HANA, How to do it…
- reporting tools
- connecting, to SAP HANA / Connecting reporting tools to SAP HANA, How to do it…, How it works…
- URL / See also
- reports
- creating, SAP BusinessObjects Web Intelligence used / Creating reports using SAP BusinessObjects Web Intelligence, How to do it…, There's more…
- creating, SAP BusinessObjects Explorer used / Creating reports using SAP BusinessObjects Explorer, How to do it…, How it works…, There's more…
- creating, SAP BusinessObjects Dashboards used / How to do it…, How it works…
- creating, SAP BusinessObjects Analysis for OLAP used / Creating reports using SAP BusinessObjects Analysis for OLAP, How to do it…, How it works…
- creating, Microsoft Excel used / Creating reports using Microsoft Excel, How to do it…, There's more…, See also
- creating, SAP Lumira used / Creating reports in SAP Lumira, How to do it…, How it works…
- Resource perspective / See also
- right outer, join type / How it works…
- roles
- creating / Creating roles, How to do it…
- assigning, to users / Assigning roles to users, There's more…
- row-based store engine / Further reading
S
- SAP
- about / Introduction
- SAP BO Explorer configuration
- connecting to / How to do it…
- SAP BusinessObjects Analysis
- used, for creating reports / Creating reports using SAP BusinessObjects Analysis for OLAP, How to do it…, How it works…
- URL / See also
- SAP BusinessObjects Dashboards
- used, for creating reports / Creating reports using SAP BusinessObjects Dashboards/Xcelsius, How to do it…
- SAP BusinessObjects Explorer
- used, for creating reports / Creating reports using SAP BusinessObjects Explorer, How to do it…, How it works…, There's more…
- URL / See also
- SAP BusinessObjects Explorer (SAP BO Explorer) / There's more…
- SAP BusinessObjects Web Intelligence
- used, for creating reports / Creating reports using SAP BusinessObjects Web Intelligence, How to do it…, How it works…, There's more…
- SAP Business Suite
- on SAP HANA / Introducing SAP Business Suite on SAP HANA, How it works…
- SAP BWA
- and SAP HANA, comparing / Evolution of SAP BWA and SAP HANA, Comparison
- SAP Data Services
- about / SAP Data Services
- key factors / SAP Data Services
- vs, SLTand Sybase replication / Technical considerations
- using, for data provisioning / Using SAP Data Services as an ETL tool to load data into SAP HANA
- datastore, creating in / Step 1 – Creating a datastore for the source system in SAP Data Services
- table, importing in / Step 2 – Importing tables in SAP DS for the datastore created
- using, for data provosioning / How it works…
- benefits / How it works…
- SAP DS Version 4.0 / Getting ready
- SAP ERP
- URL / See also
- SAP HANA
- URL / See also
- data, saving into / Saving data into SAP HANA
- view, saving to / How it works…
- reporting layer / The reporting layer on top of SAP HANA, How to do it…
- reporting tools, connecting / Connecting reporting tools to SAP HANA, Getting ready, How to do it…, How it works…
- currency conversion / Converting different currencies, How to do it…, How it works…
- users, creating / Creating users, How to do it…, How it works…
- roles, creating / How to do it…
- roles, assigning to users / Assigning roles to users, How it works…
- analytic privileges, creating / Restricting access to data – creating analytic privileges, How to do it…, How it works…
- logging, securing / Securing logging in to SAP HANA – authentication methods, How to do it…, See also, Securing logging in to SAP HANA – privileges, How it works…
- about / Introduction, Describing why you should use SAP HANA
- SAP NetWeaver BW / SAP NetWeaver BW powered by SAP HANA, Introducing SAP NetWeaver BW powered by SAP HANA, How it works…
- server / Server
- RAM / RAM
- log storage / Log storage
- data storage / Data storage
- advantages / Getting ready
- traditional versus in-memory / Traditional versus in-memory, There's more…
- databases versus traditional databases / Traditional versus in-memory, There's more…
- features / Looking into SAP HANA features, Alignment of business and IT, Powerful analytic appliance – real-time insight, Development of current hardware innovations, Leveraging BI capabilities
- SAP in-memory computing engine / Business analytic applications powered by technology
- evolution / Evolution of SAP BWA and SAP HANA
- and SAP BWA, comparing / Evolution of SAP BWA and SAP HANA, Comparison
- architecture / Understanding the SAP HANA architecture
- software update / Understanding the SAP HANA architecture
- column-based store engine / Further reading
- row-based store engine / Further reading
- applications / Introducing flavors on top of SAP HANA, See also
- SAP Business Suite / Introducing SAP Business Suite on SAP HANA, How it works…
- SAP HANA Cloud
- URL / See also
- SAP HANA Development perspective / How it works…
- SAP HANA DXC Implementation Guide
- URL / See also
- SAP HANA modeling
- SAP HANA Modeling Guide
- URL / See also
- SAP HANA studio
- Eclipse perspectives / Getting ready
- SAP HANA Studio
- about / How it works…, How it works…
- supported platform / Platforms supported
- system requirements / System requirements
- installation paths / Installation paths
- navigating, Navigator Pane used / Navigating SAP HANA Studio – the Navigator Pane, Getting ready
- metadata, importing from / Step 4 – Importing metadata from SAP HANA Studio
- SAP HANA Studio repository / Understanding the SAP HANA architecture
- SAP HANA system
- table, creating / Step 1 – creating a table in the SAP HANA system
- target table, selecting / Step 2 – selecting the source file and target table in SAP HANA
- source file, selecting / Step 2 – selecting the source file and target table in SAP HANA
- datastore, creating for / Creating a datastore for a target system – SAP HANA in SAP Data Services
- SAP Host Agent
- SAP in-memory computing engine / Business analytic applications powered by technology
- SAP Lumira
- URL / See also, See also
- reports, creating in / Creating reports in SAP Lumira, How to do it…
- SAP NetWeaver BW
- about / SAP NetWeaver BW powered by SAP HANA
- technical requisites / Technical requirements
- by SAP HANA / Introducing SAP NetWeaver BW powered by SAP HANA, How it works…
- URL / See also
- SAP NetWeaver Version 7.0 / How it works…
- SAP Solution Manager (SAP SOLMAN) / Understanding the SAP HANA architecture
- SAP Solution Manager diagnostic agent
- Security Assertion Markup Language (SAML) / How to do it…
- segments / Storing data – row storage
- Sidecar approach
- about / The Sidecar approach
- SLT
- about / SAP Landscape Transformation
- key factors / SAP Landscape Transformation
- vs, SAP Data Services and Sybase replication / Technical considerations
- using, for data provisioning / Using SLT to load data into SAP HANA, How it works…, Control module, There's more…
- configuration / SLT configuration – creating a connection
- components / How it works…
- SLT, components
- logging tables / How it works…
- read module / How it works…
- control module / How it works…
- write module / How it works…
- source file
- selecting, in SAP HANA system / Step 2 – selecting the source file and target table in SAP HANA
- SQL Console option / SQL Console
- SQL privileges / How it works…
- SQL Script / SQLScript
- SQLScript
- used, for creating calculation view / Creation of a calculation view using SQLScript (native SQL or CE functions)
- used, for creating procedures / Creating procedures using SQLScript, How to do it…, How it works…
- static list / How it works…
- SUSE Linux Enterprise Server (SLES) / Server
- Sybase replication
- about / Sybase replication
- key factors / Sybase replication
- vs, SLTand SAP Data Services / Technical considerations
- using, for data provisioning / Getting ready, How it works…, There's more…
- setup, prerequisites / Oracle to SAP HANA Replication setup, Prerequisites
- configuring / Configuring Replication Server to SAP HANA
- connection, creating / Creating a Replication Server connection to the primary database
- testing / Testing the replication
- Sybase Replication Server 15.7.1 SP100
- URL / See also
- Sybase Replication Server Version 15.7.1 SP100 / Getting ready
- System Information tab / System Information
- System Monitor option / System Monitor
- system privileges / How it works…
T
- table
- creating, in SAP HANA system / Step 1 – creating a table in the SAP HANA system, Creating table in SAP HANA using the import of metadata option
- importing, in SAP Data Services / Step 2 – Importing tables in SAP DS for the datastore created
- target table
- selecting, in SAP HANA system / Step 2 – selecting the source file and target table in SAP HANA
- Team Synchronizing perspective / See also
- technology
- about / Introducing technology and hardware innovations
- multicore CPUs / Multicore CPUs
- parallel processing / Parallel processing
- data compression / Data compression
- text, join type / How it works…
- Text Retrieval and Extraction (TREX) / Storing data – column storage
- traditional databases
- about / Explaining traditional databases and bottlenecks, Traditional databases
- bottlenecks / Bottlenecks
- latency / Latency
- cost / Cost
- architecture / Architecture
- transactional version memory / Storing data – row storage
- transaction manager
- about / Transaction manager
U
- union / Creation of a calculation view using GUI, Combining data
- universe
- creating, IDT used / How to do it…
- users
- creating / Creating users, How to do it…, How it works…
- roles, assigning / Assigning roles to users, How it works…
V
- values
- merging / Merging values
- changing / Changing values
- variables
- creating / Creating variables, How to do it…, How it works…
- URL / See also
- Version Memory Consolidation / Storing data – row storage
- view
- saving, to SAP HANA / Saving the view to SAP HANA and publishing, There's more…
- My Data / My Data
- My Information Views / My Information Views
- Volumes tab / Volumes
W
- WebI
- URL / See also
- WebI document
- creating, universe used / How to do it…
- Window menu / How to do it…
- workflow
- creating / Creating a workflow
- write module / Read module, Write module
- write operations / Storing data – row storage
X
- XS engine