SAP HANA建模指南-中文版

下载需积分: 5 | PDF格式 | 6.47MB | 更新于2023-11-23 | 149 浏览量 | 举报

标题：SAP HANA建模指南摘要：本文是SAP HANA建模指南的文件描述，旨在介绍建模概述和SAP HANA架构。SAP HANA是一种内存数据库，具有列式数据存储和并行处理等特点。它简化了应用程序的开发和部署过程，并提供强大的数据建模功能。正文：《SAP HANA建模指南》是SAP HANA平台SPS 08版本的1.1版文件，发布于2014年8月21日。本文主要包括两个部分：建模概述和SAP HANA架构。建模概述部分主要介绍建模的背景和概念。建模是一种数据处理和组织的方法，通过定义实体、属性和关系，将现实世界中的信息转化为可操作的数据模型。建模有助于数据分析和应用程序开发，提高了数据的可理解性和可用性。 SAP HANA架构部分主要介绍SAP HANA的技术特点和架构。SAP HANA是一种内存数据库，利用内存存储数据，实现了高速的数据处理和查询。其中，列式数据存储是SAP HANA的一个重要特点，它将数据存储为列，提高了数据读取和压缩效率。并行处理是另一个重要特点，SAP HANA利用多个处理单元同时处理数据，提高了计算速度。此外，SAP HANA还简化了应用程序的开发和部署过程，提供了强大的数据建模功能，使得开发人员可以更轻松地构建复杂的数据模型和分析应用。总结：《SAP HANA建模指南》是一份介绍SAP HANA建模相关知识的重要文件，它包含了建模概述和SAP HANA架构两个部分。建模概述部分介绍了建模的背景和概念，以及建模在数据分析和应用程序开发中的作用。SAP HANA架构部分介绍了SAP HANA作为内存数据库的特点，包括列式数据存储和并行处理等。此外，SAP HANA还提供了强大的数据建模功能，使得开发人员可以更轻松地构建复杂的数据模型和分析应用。本文对于了解和使用SAP HANA建模技术具有重要的指导意义。

● Input parameters

You can choose to further fine-tune the behavior of the attributes and measures of an analytic view by setting

the properties as follows:

● Apply filters to restrict values that are selected when using the analytic view.

● Define attributes and measures as Hidden so that they can be used in calculated columns but are not

visible to end users.

Note

You can mark attributes/measures as hidden in the Logical Join and Semantics node. Hidden attributes

of an analytic view are not visible during data preview and in the calculation views using the analytic

view.

● Set the Drill Down Enabled property to indicate if an attribute is available for further drill down when

consumed.

● Set the aggregation type on measures.

● Assign Semantic Type to the attributes and measures.

● Associate a measure with the currency and unit of measure using the Measure Type property

Calculation Views

A calculation view is used to define more advanced slices on the data in the SAP HANA database. Calculation

views can be simple and mirror the functionality found in both attribute views and analytic views. However,

they are typically used when the business use case requires advanced logic that is not covered in the previous

types of information views.

For example, calculation views can have layers of calculation logic, can include measures sourced from

multiple source tables, can include advanced SQL logic, and so on. The data foundation of the calculation view

can include any combination of tables, column views, attribute views and analytic views. You can create joins,

unions, projections, and aggregation levels on the sources.

You can model the following elements within a calculation view:

● Attributes

● Measures

● Calculated Columns

● Counters

● Hierarchies (created outside of the attribute view)

● Variables

● Input parameters

Calculation views can include measures and be used for multidimensional reporting or can contain no

measures and used for list-type of reporting. Calculation views can either be created using a graphical editor

or using SQLScript . These various options provide maximum flexibility for the most complex and

comprehensive business requirements.

You can choose to further fine-tune the behavior of the attributes and measures of a calculation view by

setting the properties as follows:

● Apply filters to restrict values that are selected when using the calculation view.

● Define attributes and measures as Hidden so that they can be used in calculated columns but are not

visible to end users.

P U B L I C

SAP HANA Modeling Guide

Getting Started

Note

You can mark attributes/measures as hidden in the default Aggregation or Projection node, and in the

Semantics node. Hidden attributes of a calculation view are not visible during data preview and in the

calculation views using this calculation view.

● Set the Drill Down Enabled property to indicate if an attribute is available for further drill down when

consumed.

● Set aggregation type on measures

● Associate a measure with the currency and unit of measure using the Measure Type property

Note

You can look into the XML that is generated for the modeled view. You can view both the View XMLand the

Repository XML. The view XML comprises of the tags corresponding to the models created using existing

view editor. However, the repository XML depicts tags as in the old models. The two options are available in

the view editor toolbar menu.

Related Information

Attributes and Measures [page 23]

Attributes and measures form the content data that is used for modeling. While attributes represent the

descriptive data like city and country, measures represent quantifiable data like revenue and quantity sold.

Create Level Hierarchies [page 101]

You create hierarchies to arrange view attributes that enhances data analysis by displaying attributes

according to their defined hierarchical relationships.A level hierarchy is rigid in nature, and the root and the

child nodes can only be accessed in a defined order.

Create Parent-Child Hierarchies [page 103]

A parent-child hierarchy is defined using a parent attribute that determines the relationship among the view

attributes. A parent attribute describes a self-referencing relationship, or self-join, within the main table.

Assign Variables [page 110]

You can assign variables to a filter at design time for obtaining data based on the values you provide for the

variable. At runtime, you can provide different values to the variable to view the corresponding set of

attribute data.

3.2.2 SAP HANA Studio

The SAP HANA studio is an Eclipse-based development and administration tool for working with SAP HANA,

including creating projects, creating development objects, and deploying them to SAP HANA. As a developer,

you may want to also perform some administrative tasks, such as configuring and monitoring the system.

There are several key Eclipse perspectives that you will use while developing:

● Modeler: Used for creating various types of views and analytical privileges.

SAP HANA Modeling Guide

Getting Started

P U B L I C

剩余169页未读，继续阅读

身份认证购VIP最低享 7 折!

30元优惠券

xiaoli8748_软件开发

粉丝: 1w+

SAP HANA建模指南-中文版

Java采购供应平台源码与SAP-HANA技术整合升级指南

SAP-HANA数据库SQL操作与指令大全

Teka-Teki-Silang-Hana项目深度解析

SAP-HANA-Administration-with-SAP-HANA-Cockpit-en

SAP-HANA-Cockpit-Installation-Guide-en

ha200-sap-hana-administration-amp-operations-sap-hana-participant-handbook

Java采购管理信息系统源码-SAP-Hana-cloud-espm-v2:SAP-Hana-cloud-espm-v2

SAP-HANA-Administration-Guide

SLES4SAP-hana-sr-guide-PerfOpt-12-Alicloud_color_en.pdf

SLES4SAP-hana-sr-guide-PerfOpt-15_AWS_color_en.pdf

最新资源