SAP HANA Database

To create a PDM with support for features specific to the SAP® HANA DBMS family, select the appropriate version in the DBMS field of the New Model dialog. To view these extensions to the PowerDesigner metamodel in the Resource Editor, select Database > Edit Current DBMS and expand the Profile node.

The following sections list the extensions provided for SAP HANA.

Tables

The following extensions are available on the General tab:

Name	Description
Type	Specifies the table type. You can choose between: Row - [default] If the majority of table access involves selecting a few records, with all attributes selected, ROW-based storage is preferable. Column - If the majority of table access will be through a large number of tuples, with only a few selected attributes, COLUMN-based storage should be used. History column - Creates a table with a session type HISTORY, to support time travel queries, which are queries against historical states of the database. Global temporary - The table definition is globally available while data is visible only to the current session. The table is truncated at the end of the session. Local temporary - The table definition and data is visible only to the current session. The table is truncated at the end of the session. Scripting name: FullType

Name

Description

Type

Specifies the table type. You can choose between:

Row - [default] If the majority of table access involves selecting a few records, with all attributes selected, ROW-based storage is preferable.
Column - If the majority of table access will be through a large number of tuples, with only a few selected attributes, COLUMN-based storage should be used.
History column - Creates a table with a session type HISTORY, to support time travel queries, which are queries against historical states of the database.
Global temporary - The table definition is globally available while data is visible only to the current session. The table is truncated at the end of the session.
Local temporary - The table definition and data is visible only to the current session. The table is truncated at the end of the session.

Scripting name: FullType

The following extensions are available on the HANA tab:

Name	Description
Logging type	Specifies whether table logging is activated. You can choose between: logging - [default] nologging - specifies that logging is deactivated. As a result, the definition of the table is persistent and globally available and data is temporary and global. The resource manager should therefore explicitly drop a NOLOGGING table. Scripting name: LoggingType
Retention period	[if nologging] Specifies the retention time in seconds of the table created as nologging. Scripting name: Retention

Name

Description

Logging type

Specifies whether table logging is activated. You can choose between:

logging - [default]
nologging - specifies that logging is deactivated. As a result, the definition of the table is persistent and globally available and data is temporary and global. The resource manager should therefore explicitly drop a NOLOGGING table.

Scripting name: LoggingType

Retention period

[if nologging] Specifies the retention time in seconds of the table created as nologging.

Scripting name: Retention

Columns

The following extensions are available on the Detail tab:

Name	Description
Stored as	Specifies the stored data type. Scripting name: StoreDataType
DDIC type	Specifies the application data type. Scripting name: DDICDataType

Name

Description

Stored as

Specifies the stored data type.

Scripting name: StoreDataType

DDIC type

Specifies the application data type.

Scripting name: DDICDataType

Indexes

The following extensions are available on the General tab:

Name	Description
Descending	Specifies that the index should be created in descending order. Scripting name: DescIndex

Name

Description

Descending

Specifies that the index should be created in descending order.

Scripting name: DescIndex

Keys

The following extensions are available on the General tab:

Name	Description
Key type	Specifies the key type. Scripting name: KeyType

Name

Description

Key type

Specifies the key type.

Scripting name: KeyType

Roles

The following extensions are available on the General tab:

Name	Description
Global visibility	Specifies that the role is available globally. Scripting name: GlobalVisibility
Global ID	[if global visibility] Specifies the external role name for the global user. Scripting name: GlobalID

Name

Description

Global visibility

Specifies that the role is available globally.

Scripting name: GlobalVisibility

Global ID

[if global visibility] Specifies the external role name for the global user.

Scripting name: GlobalID

References

The following extensions are available on the HANA tab:

Name	Description
Cardinality	Specifies the HANA Cardinality attribute. Scripting name: HANACardinality
Join type	Specifies the HANA Join Type attribute. Scripting name: HANAJoinType
Language Column	Specifies the HANA Language Column attribute. Scripting name: HANALanguageColumn

Name

Description

Cardinality

Specifies the HANA Cardinality attribute.

Scripting name: HANACardinality

Join type

Specifies the HANA Join Type attribute.

Scripting name: HANAJoinType

Language Column

Specifies the HANA Language Column attribute.

Scripting name: HANALanguageColumn

Users

The following extensions are available on the General tab:

Name	Description
Identification	Specifies the type of identification (global, local or external). Scripting name: Identification
Distinguished name	Specifies the user's distinguished name (DN) in the directory or certificate. Scripting name: DistinguishedName
Password	Specifies the clear copy of the password. Scripting name: CopyPassword
Implicit Schema	If true, the database generation will use the stored procedure sp_grantdbaccess instead of create user statement. Scripting name: ImplicitSchema
Default Schema	Specifies the first schema searched to resolve the names of objects for this user. Scripting name: DefaultSchema

Packages

The following extensions are available on the HANA tab of HANA packages:

Name	Description
Structure package	Specifies that the package is a structural package Scripting name: Structural
Object Name	Specifies the HANA object name. Scripting name: _ObjectName_

Name

Description

Structure package

Specifies that the package is a structural package

Scripting name: Structural

Object Name

Specifies the HANA object name.

Scripting name: _ObjectName_

Facts (Analytic Views) and Dimensions (Attribute Views)

The following extensions are available on the HANA tab:

Name	Description
Default Client	Specifies the Default client HANA attribute. Scripting name: DefaultClient
Default Language	Specifies the Default Language HANA attribute. Scripting name: DefaultLanguage
Default Member [Dimension only]	Specifies the Default Member HANA attribute. Scripting name: Default Member
Multidimensional reporting [Fact only]	Specifies the Multidimensional Reporting HANA attribute. Scripting name: MultidimensionalReporting
Package	Specifies the HANA object package. Scripting name: _ObjectPackage_
Name	Specifies the HANA object name. Scripting name: _ObjectName_
Version	Specifies the HANA object version. Scripting name: _ObjectVersion_
Last Updated Date	Specifies the Last Updated HANA attribute. Scripting name: _LastUpdatedDate_
at	Specifies the LastUpdated HANA attribute. Scripting name: _LastUpdatedTime_
XML description	Specifies the XML description HANA attribute. Scripting name: _ObjectXML_

Dimension Attributes and Fact Attributes

The following extensions are available on the HANA tab:

Name	Description
Default Member	Specifies the Default Member HANA attribute. Scripting Name: DefaultMember
Info Object	Specifies the Info Object HANA attribute. Scripting Name: InfoObject
Drill Down Enabled	Specifies the Drill Down Enabled HANA attribute. Scripting Name: DrillDownEnabled
Hidden	Specifies the Is Hidden HANA attribute. Scripting Name: IsHidden
Alias	Specifies the Alias HANA attribute. Scripting Name: Alias
Key Attribute	[Dimension attribute only] Specifies the Key Attribute HANA attribute. Scripting Name: KeyAttribute
Principal Key	[Dimension attribute only] Specifies the Principal Key HANA attribute. Scripting Name: PrincipalKey
Attribute Hierarchy Active	[Dimension attribute only] Specifies the Attribute Hierarchy Active HANA attribute. Scripting Name: AttributeHierarchyActive
Data Type	Specifies the AttributeDataType HANA attribute. Scripting Name: AttributeDataType
Length	Specifies the Calculated Attribute Length HANA attribute. Scripting Name: Length
Scale	Specifies the Calculated Attribute Scale HANA attribute. Scripting Name: AttributeScale

Fact Measures

The following extensions are available on the HANA tab:

Name	Description
Data Type	Specifies the MeasureDataType HANA attribute. Scripting Name: MeasureDataType
Length	Specifies the MeasureLength HANA attribute. Scripting Name: MeasureLength
Scale	Specifies the MeasureScale HANA attribute. Scripting Name: MeasureScale

Name

Description

Data Type

Specifies the MeasureDataType HANA attribute.

Scripting Name: MeasureDataType

Length

Specifies the MeasureLength HANA attribute.

Scripting Name: MeasureLength

Scale

Specifies the MeasureScale HANA attribute.

Scripting Name: MeasureScale