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
DataSources
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
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
Opening a BW Object in another Project
Creating a Copy of a BW Object
Managing Favorites
Adding Objects to Favorites Using the BW Repository Tree
Adding Objects to Favorites Using the Favorites Tree
Removing Objects from the Favorites
Removing Objects from the Favorites
Linking a Selection in Project Explorer View with the Active Editor
Sharing Links to BW Objects
Reference
Keyboard Shortcuts for BW Modeling Tools
Display Options for BW Modeling
Settings for BW Modeling
Concepts
Modeling with Fields Instead of InfoObjects
InfoArea
Transporting InfoAreas
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
InfoObject
Characteristic
Attribute
High Cardinality
Master Data
Master Data Types: Attributes, Texts and Hierarchies
Characteristic as InfoProvider
Characteristics of Type Integer
Key Figures
Reference InfoObjects
Unit
XXL InfoObject
Authorizations for InfoObjects
Transporting InfoObjects
InfoSource
Recommendations for Using InfoSources
Authorizations for InfoSources
Transporting InfoSources
DataStore Object (Advanced)
Structure of the DataStore Object
Modeling Properties
Templates for Modeling the Data Warehousing Layers
Enterprise Data Warehouse Architecture
Data Acquisition Layer
Corporate Memory - Compression Capabilities
Corporate Memory - Reporting Capabilities
Data Warehouse Layer - Delta Calculation
Data Warehouse Layer - Data Mart
Classic Objects
Standard DataStore Object
Write-Optimized DataStore Object
InfoCube
DataStore Object (advanced) for Direct Update
Currency Translation and Unit Conversion
APIs for the DataStore Object (advanced)
Transporting DataStore Objects (advanced)
Semantic Groups
Comparison with Semantically Partitioned Object
Authorizations for Semantic Groups
Transporting Semantic Groups
CompositeProvider
Supported Providers
Supported Scenarios
Temporal Join
Possible Assignments of Data Types
Scenarios for Using CompositeProviders in CompositeProviders
Query Properties
Names for CompositeProvider Fields in the Query
Authorizations for CompositeProviders
Transporting CompositeProviders
Recommendations for Modeling CompositeProviders
Aggregation Level
Simple Aggregation Level
Complex Aggregation Level
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
SAP HANA Exit
Authorization
Display Area
FEMS
Transporting Queries
Tasks
Creating InfoAreas
Moving InfoAreas and Objects in the InfoArea Hierarchy
Deleting InfoAreas
Creating an Open ODS View
Creating an Open ODS View Using the Wizard (Defining Semantics and Source)
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 InfoObjects
Creating Characteristics
Editing General Settings
Editing the Properties of Master Data/Texts
Editing Properties of Hierarchies
Editing Attributes
Editing the Settings for BI Clients
Editing Various Settings
Creating Key Figures
Editing Non-Cumulative Key Figures
Editing the Stock Coverage
Creating a Unit
Creating XXL InfoObjects
Creating a Copy of an InfoObject
Creating and Changing Hierarchies
Hierarchy Attributes
Creating InfoSources
Creating InfoSources Using the Wizard
Adding InfoObjects
Adding Fields
Creating DataStore Objects (advanced)
Creating DataStore Objects Using the Wizard (advanced)
Adding InfoObjects
Adding Fields
Defining Keys
Using Non-Cumulative Key Figures
Creating Partitions
Creating Indexes
Managing DataStore Objects (advanced)
Default Settings and Personalization
Cleaning Up Requests Using Process Chains
Remodeling DataStore Objects (Advanced)
Creating Semantic Groups
Example of the Definition of a Semantic Group
Changing the Semantic Group and Its Objects
Creating a Copy of a Semantic Group
Deleting Semantic Groups
Creating CompositeProviders
Creating CompositeProviders Using the Wizard
Using a CompositeProvider as a Provider in Other CompositeProviders
Creating Union Assignments
Creating Join Assignments
Using Temporal Joins
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
Creating a Copy of a CompositeProvider
Supplying Data to 0INFOPROV
Processing Joins
Settings for CompositeProviders
Using CompositeProviders for BW Integrated Planning
Creating Aggregation Levels
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 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
Using Global Structures
Using Global Structures
Locally Overwriting a Global Structure
Defining Global Filters
Using Global Filters
Overwriting Global Filters
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"
Changing Query Runtime Properties (Runtime Properties tab)
General Runtime Properties
Calculating Key Figures with High Accuracy
Not Using Parallel Processing
Processing Queries
Calculating Commutative Formulas After Aggregation
Using a Query as an InfoProvider
Query as InfoProvider
Generation Log
OLAP Effort
Runtime Profile Properties
Changing the Data Integrity Profile
Data Integrity Profile
Changing Read Mode for Existing Queries
Read Mode
Changing Cache Mode for Existing Queries
Cache Mode
Setting the Cache Usage Mode
Cache Usage Mode
Specifying Data Integrity and Access to Data Stored in Near-Line Storage
Using the Delta Cache Process
Delta Caching
Specifying the InfoProvider Grouping for Delta Caching
Performing Operations in SAP HANA/BWA
Operations in SAP HANA/SAP NetWeaver BW Accelerator
Materializing the Intermediate Result of the Query
Using the Selection of Structure Elements
Reading Child Members with Hierarchy Structure Nodes
Optimization Mode
Optimization Periods
Statistic Details Display
Open Hub Destination: Distributing Data from the BW System
Creating Open Hub Destinations
Selecting Database Tables as Destinations
Selecting Files As Destinations
SAP Data Services and Third-Party Tools as Destinations
Extracting Data to a Third-Party Tool
APIs for Third-Party Tools as Destinations
API: RSB_API_OHS_DEST_SETPARAMS
API: RSB_API_OHS_3RDPARTY_NOTIFY
API: RSB_API_OHS_REQUEST_SETSTATUS
API: RSB_API_OHS_DEST_GETLIST
API: RSB_API_OHS_DEST_GETDETAIL
API: RSB_API_OHS_DEST_READ_DATA_RAW
API: RSB_API_OHS_DEST_READ_DATA
Edit Fields
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
Creating a SAP HANA 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
Mixed Modeling (SAP BW and SAP HANA)
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
SAP HANA Views for Hierarchies
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 the Generation of SAP HANA Views
Managing SAP HANA Views from BW Objects
Check the Consistency of the Framework for Generating SAP HANA Views
Replicating BW Analysis Authorizations to SAP HANA
Assigning DBMS Users the Required Standard Database Authorizations
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
Creating Database Statistics for Virtual Tables
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
Supported Objects
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