没有合适的资源?快使用搜索试试~ 我知道了~
首页SAP HANA 2.0 Modeling Guide
1 SAP HANA Modeling Guide.....................................................7 2 Introduction to Modeling......................................................8 3 SAP HANA Architecture.......................................................9 3.1 SAP HANA In-Memory Database..................................................9 Columnar Data Storage......................................................9 Parallel Processing.........................................................10Simplifying Applications.....................................................11 3.2 SAP HANA Database Architecture.................................................
资源详情
资源评论
资源推荐

PUBLIC
SAP HANA Platform 2.0 SPS 03
Document Version: 1.0 – 2018-04-06
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
3.1 SAP HANA In-Memory Database..................................................9
Columnar Data Storage......................................................9
Parallel Processing.........................................................10
Simplifying Applications.....................................................11
3.2 SAP HANA Database Architecture.................................................11
4 Getting Started.............................................................13
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 Denitions and Data............................................25
5.1 Import Table Denitions....................................................... 25
5.2 Load Data into Tables.........................................................26
Suspend and Resume Data Load...............................................28
Upload Data from Flat Files...................................................29
5.3 Copy Content Delivered by SAP..................................................30
5.4 Map Authoring Schema to the Physical Schema...................................... 32
Maintain Package Specic Default Schemas.......................................33
Change Authoring Schemas..................................................36
6 Setting Up the Modeling Environment...........................................38
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
SAP HANA Modeling Guide
Content

Time Range to Generate Time Data.............................................45
7.2 Using Attribute Views.........................................................45
Create Attribute Views......................................................46
Attribute View Types.......................................................50
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............................................................. 74
Create Unions............................................................88
Create Rank Nodes........................................................94
Filter Output of Data Foundation Node...........................................95
Filter Output of Aggregation or Projection View Nodes............................... 96
7.6 Preview Information View Output.................................................98
Data Preview Editor.......................................................100
SQL Editor..............................................................101
8 Working With Attributes and Measures..........................................102
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
8.4 Assign Variables............................................................ 112
Supported Variable Types...................................................115
Variable Properties........................................................115
8.5 Assign Semantics........................................................... 115
Extract and Copy Semantics From Underlying Data Sources...........................116
Propagate Columns to Semantics..............................................117
Supported Semantic Types for Measures........................................ 118
Supported Semantic Types for Attributes........................................118
8.6 Create Input Parameters...................................................... 119
Map Input Parameters or Variables............................................ 122
Input Parameters.........................................................124
SAP HANA Modeling Guide
Content
P U B L I C 3

Input Parameter Properties..................................................126
8.7 Using Hierarchies for Reporting................................................. 126
Create Level Hierarchies....................................................127
Create Parent-Child Hierarchies...............................................130
Query Shared Hierarchies...................................................134
Root Node Visibility....................................................... 135
Orphan Nodes...........................................................136
8.8 Using Currency and Unit of Measure Conversions.....................................136
Associate Measures with Currency.............................................137
Associate Measures with Unit of Measure........................................140
8.9 Enable Attributes for Drilldown in Reporting Tools.....................................143
Supported Drilldown Types for Attributes........................................143
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......................................................146
8.14 Convert Attribute Values to Required Formats....................................... 147
9 Working With Information View Properties.......................................149
9.1 Deprecate Information Views...................................................149
9.2 Filter Data for Specic Clients.................................................. 150
Assign Default Client ...................................................... 151
Default Client Values.......................................................151
9.3 Enable Information Views for Time Travel Queries.....................................152
9.4 Invalidate Cached Content.....................................................153
Enable Support for Cache Invalidation..........................................154
9.5 Maintain Modeler Object Labels in Multiple Languages.................................154
9.6 Quick Reference: Information View Properties.......................................155
10 Dening Data Access Privileges................................................161
10.1 Create Classical XML-based Analytic Privileges...................................... 163
Analytic Privileges........................................................ 165
Structure of XML-Based Analytic Privileges...................................... 166
Dynamic Value Filters in the Attribute Restriction of XML-Based Analytic Privileges...........171
Runtime Authorization Check of Analytic Privileges.................................173
Example: Using Analytic Privileges.............................................175
Example: Create an XML-Based Analytic Privilege with Dynamic Value Filter................177
Supported Restriction Types in Analytic Privileges..................................179
10.2 Create SQL Analytic Privileges..................................................180
Static SQL Analytic Privileges................................................182
Dynamic SQL Analytic Privileges..............................................182
Structure of SQL-Based Analytic Privileges.......................................182
4
P U B L I C
SAP HANA Modeling Guide
Content

11 Migrating an Object Type to a Dierent Object Type................................185
11.1 Convert Attribute Views and Analytic Views to Graphical Calculation Views...................186
Migration Impact.........................................................188
11.2 Convert Script-based Calculation Views to Graphical Calculation Views.....................189
11.3 Convert Classical XML-based Analytic Privileges to SQL-based Analytic Privileges..............192
11.4 Simulate a Migration Activity...................................................194
11.5 Undo Migration Changes......................................................195
11.6 Activate Migrated Objects.....................................................196
11.7 Migration Log..............................................................197
11.8 Best Practice: Migrating an Object Type to a Dierent Object Type.........................197
12 Additional Functionality for Information Views....................................199
12.1 Performance Analysis........................................................199
Open Information Views in Performance Analysis Mode............................. 200
Debug Calculation Views................................................... 202
Validate Performance of Calculation Views.......................................204
12.2 Maintain Comments for Modeler Objects.......................................... 205
12.3 Replacing Nodes and Data Sources.............................................. 207
Replace a View Node in Calculation Views....................................... 207
Remove and Replace a View Node in Calculation Views..............................209
Replace a Data Source in Calculation Views...................................... 210
12.4 Renaming Information Views and Columns.........................................210
Rename Information Views..................................................210
Rename Columns in Information Views..........................................211
12.5 Using Functions in Expressions..................................................212
Conversion Functions......................................................213
String Functions..........................................................214
Mathematical Functions....................................................217
Date Functions...........................................................218
Miscellaneous Functions....................................................219
Spatial Functions.........................................................221
Spatial Predicates........................................................223
12.6 Trace Performance Issues.....................................................224
12.7 Maintain Search Attributes.................................................... 224
12.8 Congure Tracing...........................................................225
12.9 View the Job Log............................................................226
12.10 Validate Models............................................................ 226
12.11 Manage Editor Layout........................................................226
12.12 Search For Tables, Models and Column Views.......................................228
13 Managing Objects in SAP HANA Systems........................................229
13.1 Activate Objects............................................................229
SAP HANA Modeling Guide
Content
P U B L I C 5
剩余265页未读,继续阅读














安全验证
文档复制为VIP权益,开通VIP直接复制

评论0