Using the SAP HANA Database
Using the SAP HANA Database
Content
Using the SAP HANA Database
Data Modeling When Using a SAP HANA
Object Type for Modeling
SAP HANA-Optimized Objects
Modeling with the BW Modeling Tools in Eclipse
Getting Started: Working with BW Modeling Tools
Basic Concepts
"BW Modeling" Perspective
Editors
Views
Project Explorer View
Favorites
BW Repository
Properties View
Problems View
History View
BW Reporting Preview View
InfoProvider View
Basic Tasks
Working with BW Projects
Creating BW Projects
Attaching SAP HANA to a BW Project
Adding Objects to Favorites
Removing Objects from the Favorites
Closing BW Projects
Deleting BW Projects
Working with BW Metadata Objects
Opening BW Metadata Objects
Searching for and Opening Objects with the Open BW Object Dialog Box
Searching for BW Objects
Creating a Where-Used List for BW Objects
Linking a Selection in Project Explorer View with the Active Editor
Reference
Keyboard Shortcuts for BW Modeling Tools
Display Options for BW Modeling
Settings for BW Modeling
Concepts
Modeling with Fields Instead of InfoObjects
Open ODS View
Components of the Open ODS View Definition
Supported Sources for Open ODS Views
Structure of the Open ODS View Editor
InfoObject Names for Fields in Open ODS Views
Authorization Behaviour for Fields of Open ODS Views
Transporting Open ODS Views
Transformation of Data from External Sources for Open ODS Views
DataStore Object (Advanced)
Structure of the DataStore Object
Modeling Properties
Templates for Modeling the Data Warehousing Layers
Data Acquisition Layer
Corporate Memory
Data Propagation Layer
Reporting Layer
Currency Translation and Unit Conversion
API for Loading Data
CompositeProvider
Names for CompositeProvider Fields in the Query
Supported Providers
Supported Scenarios
Recommendations for Modeling CompositeProviders
Transporting CompositeProviders
Query
Characteristic
Structure
Structure Element
Selection
Formula
Cell, Exception Cell and Help Cell
Filter
Condition
Exception
Input-Ready Query
Reusable Query Components
Restricted Key Figure
Calculated Key Figure
Global Structure
Global Filter
Variable
Overview of Variable Types and Processing Types
Variable Type
Processing Type
Manual Entry/Default Value
Replacement Path
Replacement from Characteristic Value
Calculating with Formula Variables
Offset for Text Variables
Replacement from CURRENT MEMBER Variable
Replacement from Query
Replacement from Variable
Customer Exit
Dependencies in Customer Exit Variables
SAP Exit
Authorization
Display Area
FEMS
Tasks
Creating an Open ODS View
Specifying Semantics and Source for Open ODS View
Specifying the Structure of the Open ODS View
Displaying Initial Properties for Open ODS View Fields
Changing Properties for Fields of Type "Characteristic"
Changing Properties for Fields of Type "Key Figure"
Adding Texts or Attributes
Replacing the Source of an Open ODS View
Creating a Data Flow for Open ODS Views
Creating DataStore Objects (advanced)
Creating DataStore Objects Using the Wizard (advanced)
Adding InfoObjects
Adding Fields
Using Non-Cumulative Key Figures
Creating Partitions
Creating Indexes
Managing DataStore Objects (advanced)
Default Settings and Personalization
Remodeling DataStore Objects (Advanced)
Creating CompositeProviders
Creating CompositeProviders Using the Wizard
Using a CompositeProvider as a Provider in Other CompositeProviders
Creating Union Assignments
Creating Join Assignments
Editing Groups
Editing Properties
Changing Properties for Fields of Type "Characteristic"
Activating Navigation Attributes
Changing Properties for Fields of Type "Key Figure"
Changes to Used Objects
Supplying Data to 0INFOPROV
Processing Joins
Settings for CompositeProviders
Using CompositeProviders for BW Integrated Planning
Defining Queries
Including Characteristics
Properties of the Characteristic
Tab: General
Tab: Hierarchy
Creating a Structure
Structure Properties
Defining Structure Elements
Defining Selections
Selection Properties
Tab: General
Tab: Conversion
Tab: Calculations
Calculate Results As
Example: Calculate Results As
Calculate Single Values As
Examples: Calculate Single Values As
Tab: Planning
Restricting Key Figures
Defining a Formula
Formula Properties
Tab: General
Tab Page: Aggregation
Tab: Calculations
Calculate Results As
Example: Calculate Results As
Calculate Single Values As
Examples: Calculate Single Values As
Tab: Planning
Defining Exception Cells and Help Cells
Defining Cell References
Defining Help Cells
Defining Priorities
“Priorities” Tab
Defining Filters
Restricting Characteristics
Restricting Characteristics by Characteristic Values
Restricting Characteristics on Hierarchy Nodes
Specifying a Key Figure as a Filter
Defining Conditions
Tab: General
Tab Page: Assignments
Defining Exceptions
Tab: General
Tab Page: Definition
Tab Page: Cell Restriction
Defining Input-Ready Queries
Saving Queries
Opening and Changing Existing Queries
Using Reusable Query Components
Defining Calculated Key Figures
Using Calculated Key Figures
Overwriting Calculated Key Figures Locally
Defining Restricted Key Figures
Using Restricted Key Figures
Overwriting Restricted Key Figures Locally
Defining the Structure
Using Structures
Locally Overwriting a Structure
Defining Filters
Reusing Filters
Overwriting Filters Locally
Defining Variables
Example: Using a Variable with Replacement from Query
Variable Properties
Tab: General
Additional Tabs Available for Specific Processing Types
Query Properties (General Tab)
Screen Area: General
Screen Area: Output Settings
Screen Area: Remote Access
Screen Area: Variables Order
Screen Area: Result Location
Screen Area: Zero Suppression
Screen Area: Universal Display Hierarchy
Screen Area: Planning
Screen Area "Extended"
More Information
Rules for Standard Aggregation and Exception Aggregation
Formula Calculation
Basic Functions
Percentage Functions
Data Functions
FIX Operator
FIX Operator and Various Aggregations
FIX Operators and Various Constant Selections and Aggregations
FIX Operator and Restricted Key Figures
FIX Operator and Restricted Constants
Mathematical Functions
Trigonometric functions
Boolean Operators
Input-Ready Query
Creating Input-Ready Queries
Input-Ready Queries at Runtime
Displaying All Valid Characteristic Combinations
Disaggregation (Top-Down Distribution)
Defining Inverse Formulas
Examples: Inverse Formula
Inverse Formulas at Runtime
Percentage Functions at Runtime
Examples: Inverse Formulas at Runtime
Editing Short Texts in Queries
Example: Classification in a Query
Example: Entering Comments in a Query
Security Aspects
User Authentication on the Front End Client
Authorizations for Modeling with BW Modeling Tools
Protecting Resources on the Front End Client
Installing Third-Party Plug-Ins
What's New in the BW Modeling Tools
Version 1.13
Locale Favorites (Deleted)
Version 1.11
Reusable Query Components (New)
Creating a Query (Enhanced)
Where-Used List for SAP HANA Views in CompositeProviders (New)
Version 1.8
Creating a Query (Enhanced)
Defining Cells in the Query (New)
Creating Input-Ready Queries (New)
Making Data Integrity Settings in the Query (New)
Defining Exception Cells and Help Cells in Queries (New)
Open ODS View (Enhanced)
Version 1.7
DataStore Object (advanced) (Enhanced)
CompositeProvider (Enhanced)
Creating a Query (Enhanced)
Version 1.6
Editing Queries with the BW Modeling Tools (New)
Generating SAP HANA Views (Enhanced)
Version 1.5
DataStore Object (advanced) (New)
Version 1.4
CompositeProvider (Enhanced)
Open ODS View (Enhanced)
Search and Where-Used List (New)
SAP HANACreating an Analysis Process
Selecting the Components of the Analysis Process
Registering Procedures
Defining the Details for the Data Source
Defining the Details for the Data Analysis
Editing Generated Procedures
Defining the Details for the Data Target
Using Expert Mode
Editing Analysis Types
Deleting Administrative Data
Authorizations for SAP HANA Analysis Processes
Modeling and Analysis for Business Users
Merging Data from BW and SAP HANA (Mixed Scenarios)
Generating SAP HANA Views from the BW System
Generating SAP HANA Views for InfoCubes and (classic) DataStore Objects
Generating SAP HANA-Views for DataStore Objects (advanced)
Generating SAP HANA Views for InfoObjects
Generating SAP HANA Views for Local CompositeProviders from BW Workspace
Generating SAP HANA Views for CompositeProviders
Generating SAP HANA Views for Queries as InfoProviders
Generating SAP HANA Views for Queries
Supported BW Functions
Ignored BW Functions
Unsupported BW Functions
Comparison of the Two Methods for Creating Views in SAP HANA for BW Objects
Comparison of the Two Methods for Creating Views in SAP HANA for BW Queries
Authorizations for Generating SAP HANA Views
Administration of SAP HANA Views from BW Objects
Storing Generated SAP HANA Views
Authorizations for BW and SAP HANA (Mixed Scenarios)
Performance Optimization with SAP HANA
Indexing BW Data in the SAP HANA Database
Tab: SAP HANA/BWA Index Settings
Planning When Using the Database
Using SAP HANA Platform Functions in SAP BW
SAP HANA Smart Data Access
Operation and Administration of the SAP BW on SAP HANA
Multi-Temperature Data Management
Multi-Temperature Categories and BW Architecture (LSA)
SAP HANA SAP HANA Dynamic Tiering for Using Extended Tables
Generating Extended Tables for BW Objects
Transporting BW Objects with Extended Tables
Changing the Multi-Temperature Category for BW Objects
Handling Non-Active Data to Optimize the Usage of the Main Memory in SAP HANA
Activating the Handling of Non-Active Data During Main Memory Bottlenecks
Monitoring the Handling of Non-Active Data
Triggering a Delta Merge
Triggering Delta Merge via Process Chain
Statistics for Maintenance Processes in SAP HANA Indexes
Tracing in the SAP HANA Database
Using DBA Cockpit with SAP HANA