SAP_HANA_Modeling_Guide_for_SAP_HANA_Studio_en

PUBLIC

SAP HANA Platform 2.0 SPS 02

Document Version: 1.0 – 2017-07-26

SAP HANA Modeling Guide

For SAP HANA Studio

Content

1 SAP HANA Modeling Guide.....................................................7

2 Introduction to Modeling......................................................8

3 SAP HANA Architecture.......................................................9

4.1 Add a System...............................................................15

4.2 Create an Information View.....................................................16

SAP HANA Studio......................................................... 16

Attributes and Measures.....................................................21

Required Permissions......................................................23

Supported Object Types.................................................... 24

5 Importing Table Definitions and Data............................................25

5.1 Import Table Definitions.......................................................25

5.2 Load Data into Tables.........................................................26

Suspend and Resume Data Load...............................................28

6.1 Set Modeler Preferences.......................................................38

Modeler Preferences.......................................................39

Keyboard Shortcuts....................................................... 40

6.2 Apply Filters to Packages.......................................................41

6.3 Apply Filter to Objects.........................................................42

7 Creating Information Views and Previewing its Output.............................. 43

7.1 Generate Time Data..........................................................43

Supported Calendar Types to Generate Time Data..................................44

2

P U B L I C

7.3 Using Analytic Views..........................................................50

Create Analytic Views...................................................... 52

7.4 Using Calculation Views....................................................... 56

Create Script-Based Calculation Views.......................................... 57

Create Graphical Calculation Views.............................................62

Supported Data Categories for Information Views.................................. 72

7.5 Working With View Nodes......................................................73

Create Joins.............................................................73

Create Unions............................................................87

Create Rank Nodes........................................................94

8.1 Create Counters............................................................102

Counter Properties....................................................... 103

Example: Counters........................................................104

8.2 Create Calculated Columns....................................................105

Calculated Column Properties................................................107

Example: Calculated Measures...............................................107

Example: Calculated Attributes...............................................108

8.3 Create Restricted Columns.................................................... 110

Restricted Column Properties................................................ 111

Example: Restricted Columns................................................ 112

Supported Semantic Types for Measures........................................118

Supported Semantic Types for Attributes........................................118

8.6 Create Input Parameters......................................................119

Map Input Parameters or Variables............................................123

Input Parameters.........................................................124

SAP HANA Modeling Guide

P U B L I C 3

8.7 Using Hierarchies for Reporting.................................................126

Create Level Hierarchies....................................................127

Create Parent-Child Hierarchies..............................................130

Query Shared Hierarchies...................................................134

Supported Drilldown Types for Attributes........................................144

8.10 Trace Columns in Information Views With Data Lineage................................144

8.11 Assign Value Help for Attributes.................................................145

8.12 Add Descriptions to Attributes..................................................146

8.13 Group Related Measures......................................................147

8.14 Convert Attribute Values to Required Formats.......................................148

9 Working With Information View Properties.......................................150

9.1 Deprecate Information Views...................................................150

9.2 Filter Data for Specific Clients...................................................151

Assign Default Client ......................................................152

10 Defining Data Access Privileges...............................................163

10.1 Create Classical XML-based Analytic Privileges......................................165

Analytic Privileges........................................................ 167

Structure of XML-Based Analytic Privileges......................................168

Dynamic Value Filters in the Attribute Restriction of XML-Based Analytic Privileges..........172

Runtime Authorization Check of Analytic Privileges.................................174

Example: Using Analytic Privileges.............................................177

Example: Create an XML-Based Analytic Privilege with Dynamic Value Filter...............179

Supported Restriction Types in Analytic Privileges..................................181

10.2 Create SQL Analytic Privileges..................................................181

4

P U B L I C

11.1 Convert Attribute Views and Analytic Views to Graphical Calculation Views..................188

Migration Impact.........................................................190

11.2 Convert Script-based Calculation Views to Graphical Calculation Views.....................192

11.3 Convert Classical XML-based Analytic Privileges to SQL-based Analytic Privileges.............194

Debug Calculation Views...................................................204

Validate Performance of Calculation Views...................................... 206

12.2 Maintain Comments for Modeler Objects.......................................... 207

12.3 Replacing Nodes and Data Sources..............................................209

Replace a View Node in Calculation Views.......................................209

Remove and Replace a View Node in Calculation Views.............................. 211

Replace a Data Source in Calculation Views......................................212

12.4 Renaming Information Views and Columns.........................................212

Date Functions..........................................................220

Miscellaneous Functions................................................... 222

Spatial Functions.........................................................223

Spatial Predicates........................................................225

12.6 Trace Performance Issues.....................................................226

12.7 Maintain Search Attributes....................................................226

13.1 Activate Objects............................................................231

SAP HANA Modeling Guide

P U B L I C 5