Index
A
- AFL
- about / Application Function Library
- Analysis for Office
- about / Analysis for Office
- tasks / Analysis for Office
- HANA Artifacts, accessing / Analysis for Office
- analytical privileges
- using / Analytical privileges
- analytical view
- creating / Creating analytical views
- application lifecycle manager, SAP HANA / SAP HANA application lifecycle manager
- attribute
- defining / Defining attribute and key attribute
- attribute view
- creating / Creating attribute views
- copy from / Creating attribute views
- derived / Creating attribute views
B
- BFL
- about / Business Function Library
- prerequisites / Business Function Library
- functions / Business Function Library
- block iteration
C
- calculated measure
- CALCULATION engine
- calculation view
- creating / Creating calculation views
- classical SQL
- about / Classical SQL
- versus SQL script in SAP HANA / How different is an SQLscript in SAP HANA from classical SQL queries?
- column storage
- compression
- connectivity choices, SAP HANA
- BI Consumer Services (BICS)Topicn / Connecting to the SAP HANA database
- Open Database connectivity (ODBC)Topicn / Connecting to the SAP HANA database
- Java Database connectivity (JDBC) / Connecting to the SAP HANA database
- ODBO / Connecting to the SAP HANA database
- currency conversion
- in SAP HANA / Currency conversion in SAP HANA
- analytical view, creating / Currency conversion in SAP HANA
D
- Data from Local File / Loading data from Flat file in SAP HANA
- Data Services Workbench
- used, for loading data in SAP HANA / Loading data in SAP HANA with Data Services Workbench
- data types
- about / Classical SQL
- decision table
- about / What is a decision table?
- using / Why use decision tables?
- capabilities / Why use decision tables?
- usage, extending to SAP HANA / Why use decision tables?
- delivery unit
- about / Delivery units
- creating / Delivery units
- transporting, in HALM / Transporting a delivery unit with HALM
- Delta Merge
- about / Choosing the right table
E
- elements, SQL
- identifiers / Classical SQL
- data types / Classical SQL
- expressions / Classical SQL
- functions / Classical SQL
- operators / Classical SQL
- predicates / Classical SQL
- engines, SAP HANA
- JOIN engine / Basic architecture of the SAP HANA engine
- OLAP engine / Basic architecture of the SAP HANA engine
- CALCULATION engine / Basic architecture of the SAP HANA engine
- expressions
- about / Classical SQL
- extensions, SQLScript
- datatype extension (create/drop type) / Why SQLscript?
- procedural extension (create procedure) / Why SQLscript?
- functional extension (create function) / Why SQLscript?
F
- features, SAP HANA
- partitioning / Choosing the right table
- Insert only on Delta / Choosing the right table
- filters
- creating / Creating filters
- creating, steps / Steps for creating a filter
- flat file, SAP HANA
- data, loading from / Loading data from Flat file in SAP HANA
- folder structures, for system view
- Catalog / The system view
- Content / The system view
- Provisioning / The system view
- Security / The system view
- Backup / The system view
- Full Text Search
- creating / Creating and using Full Text Search
- using / Creating and using Full Text Search
- Text Analysis / Creating and using Full Text Search
- about / Creating and using Full Text Search
- Fuzzy Search / Creating and using Full Text Search
- score() function / Creating and using Full Text Search
- use cases / Creating and using Full Text Search
- capabilities / Creating and using Full Text Search
- benefits / Creating and using Full Text Search
- search option, enabling / Enabling the search option
- functions
- about / Classical SQL
- fuzzy search
- applied applications / Creating and using Full Text Search
- data types / Creating and using Full Text Search
H
- HALM
- URL / SAP HANA application lifecycle manager
- delivery unit, transporting / Transporting a delivery unit with HALM
- HANA- supported scenarios
- Standard Analytics / Creating and using Full Text Search
- search-based applications / Creating and using Full Text Search
- HANA views
- accessing, on Microsoft / Using Microsoft Excel as a reporting tool
- hierarchies
- level based / Defining attribute and key attribute
- parent-child / Defining attribute and key attribute
- creating / Creating hierarchies
- level hierarchy / Creating hierarchies
- parent-child hierarchy / Creating hierarchies
- level hierarchy, creating / Creating a level hierarchy
- parent-child hierarchy, creating / Creating a parent-child hierarchy
I
- identifiers
- about / Classical SQL
- input parameters
- creating / Creating input parameters and variables
J
- JOIN engine
- joins
- versus unions / Unions versus JOINS
- joins, in SAP HANA
- about / JOINS in SAP HANA
- referential join / JOINS in SAP HANA
- text join / JOINS in SAP HANA
- temporal join / JOINS in SAP HANA
- star join / JOINS in SAP HANA
- spatial join / JOINS in SAP HANA
K
- key attribute
- defining / Defining attribute and key attribute
L
- late materialization
- about / Row and column storage in SAP HANA
- advantages / Row and column storage in SAP HANA
- load balancing / Choosing the right table
M
- Microsoft Excel
- using, as reporting tool / Using Microsoft Excel as a reporting tool
- modeling artifacts, SAP HANA
- about / Different modeling artifacts in SAP HANA
- principles / Modeling principles
O
- OLAP
- SAP Business Objects Analysis / SAP Business Objects Analysis for OLAP
- OLAP engine
- operators
- about / Classical SQL
P
- packages
- about / Creating package and delivery unit
- creating / Creating package and delivery unit
- deleting / Deleting packages
- PAL
- about / Predictive Analysis Library
- prerequisites / Predictive Analysis Library
- functions, calling / Calling PAL functions
- PAL functions
- calling / Calling PAL functions
- URL / Calling PAL functions
- parallelism
- parallelization / Choosing the right table
- parameters, for creating procedures
- Reads SQL Data / Creating with the SQL editor (in SAP HANA Studio)
- Language / Creating with the SQL editor (in SAP HANA Studio)
- With result view / Creating with the SQL editor (in SAP HANA Studio)
- partitioning
- about / Choosing the right table
- performance optimization factors, column storage
- compression / Row and column storage in SAP HANA
- block iteration / Row and column storage in SAP HANA
- support for parallelism / Row and column storage in SAP HANA
- late materialization / Row and column storage in SAP HANA
- perspectives, SAP HANA Studio
- about / Perspectives in SAP HANA Studio
- SAP HANA Administration Console / Perspectives in SAP HANA Studio
- SAP HANA Modeler / Perspectives in SAP HANA Studio
- predicates
- about / Classical SQL
- preferences
- adjusting, steps / Steps to adjust preferences
- procedures
- about / Procedures
- creating / Procedures
- creating, with SQL editor / Creating with the SQL editor (in SAP HANA Studio)
- creating, with wizard / Procedure creation using the wizard
Q
- Quick Launch / Creating time attribute views
R
- referential join / JOINS in SAP HANA
- related elements
- creating / Creating other elements
- calculated attribute, creating / Calculated attribute
- calculated measures, creating / Calculated measures
- calculated columns, creating / Calculated columns
- variables, creating / Creating variables
- restricted measure
- row storage
S
- SAP Business Objects Analysis
- for OLAP / SAP Business Objects Analysis for OLAP
- SAP Direct Extractor (DXC)
- SAP HANA
- tables, creating in / Classical SQL
- features / Choosing the right table
- modeling artifacts / Different modeling artifacts in SAP HANA
- data, loading from flat file / Loading data from Flat file in SAP HANA
- data, loading with Data Services Workbench / Loading data in SAP HANA with Data Services Workbench
- feature / Why use decision tables?
- transport management / Transport management in SAP HANA
- application lifecycle manager / SAP HANA application lifecycle manager
- content, exporting / Export and import – moving SAP HANA content manually
- content, importing / Export and import – moving SAP HANA content manually
- landscape / Export and import – moving SAP HANA content manually
- tables / Export and import – moving SAP HANA content manually
- currency conversion / Currency conversion in SAP HANA
- reporting tools / Reporting tools for SAP HANA
- SAP HANA Administration Console / Perspectives in SAP HANA Studio
- SAP HANA database
- connecting to / Connecting to the SAP HANA database
- SAP HANA engine
- architecture / Basic architecture of the SAP HANA engine
- SAP HANA Modeler / Perspectives in SAP HANA Studio
- SAP HANA SQL
- about / Introducing SAP HANA SQL
- SAP HANA SQL script
- about / The SAP HANA SQLscript
- need for / Why SQLscript?
- SAP HANA Studio
- about / SAP HANA Studio
- perspectives / Perspectives in SAP HANA Studio
- system, adding to / Adding our system to SAP HANA Studio
- SAP Replication Server
- features / SAP Replication Server
- SAP SLT (System Landscape Transformation) Replication Server
- real-time application / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- DB trigger / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- logging table / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- application table / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- read module / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- replication server / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- controller / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- RFC connection / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- DB connection / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- features / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- use case scenarios / Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
- schemas, SAP HANA
- about / Different schemas in SAP HANA
- user defined / Different schemas in SAP HANA
- SLT derived schemas / Different schemas in SAP HANA
- system defined / Different schemas in SAP HANA
- working with / Different schemas in SAP HANA
- Smart Data Access
- about / Smart Data Access
- supported databases / Smart Data Access
- parameter, changing / Smart Data Access
- remote source, adding / Smart Data Access
- virtual tables, accessing / Smart Data Access
- spatial join / JOINS in SAP HANA
- SQL
- elements / Classical SQL
- about / Why SQLscript?
- SQL editor
- procedures, creating with / Creating with the SQL editor (in SAP HANA Studio)
- SQLScript
- extensions / Why SQLscript?
- SQL script, in SAP HANA
- versus classical SQL / How different is an SQLscript in SAP HANA from classical SQL queries?
- star join / JOINS in SAP HANA
- supported variables, types
- single value / Creating variables
- interval / Creating variables
- range / Creating variables
- system
- adding, to SAP HANA Studio / Adding our system to SAP HANA Studio
- system defined schemas, SAP HANA
- _SYS_BIC / Different schemas in SAP HANA
- _SYS_REPO / Different schemas in SAP HANA
- _SYS_BI / Different schemas in SAP HANA
- _SYS_STATISTICS / Different schemas in SAP HANA
- _SYS_XS / Different schemas in SAP HANA
- system view, SAP HANA
- about / The system view
T
- table
- selecting / Choosing the right table
- tables
- creating, in SAP HANA / Classical SQL
- temporal join / JOINS in SAP HANA
- text join / JOINS in SAP HANA
- time attribute view
- creating / Creating time attribute views
- transport management
- in SAP HANA / Transport management in SAP HANA
- use cases / Transport management in SAP HANA
U
- unions
- versus joins / Unions versus JOINS
- use cases, partitioning
- parallelization / Choosing the right table
- load balancing / Choosing the right table
V
- variables
- creating / Creating input parameters and variables
W
- wizard
- procedures, creating with / Procedure creation using the wizard