SAP HANA

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.

PowerDesigner supports round trip reverse-engineering and generation of SAP HANA® v1.0 SP07 tables and analytic and attribute views.

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

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

Auto-Merge

Specifies that automatic delta merge is triggered.

Scripting name: AutoMerge

Unload priority

Specifies the priority for unloading the table from memory from 0 to 9.

Scripting name: UnloadPriority

Schema flexibility

Specifies that the table schema is flexible.

Scripting name: WithSchemaFlexibility

Location

Specifies that partitions will be created on the listed instances using round robin scheme.

Scripting name: PartitionLocation

Multiple

Specifies that the location targets multiple HANA instances.

Scripting name: HasMultipleLocations

Options text

Specifies the SQL text of the table options. Options entered here will be set in their relevant fields, and changes to the fields are reflected here.

Scripting name: FullTableOptions

The following extensions are available on the Partitions tab:

Name

Description

Type
Specifies the partition scheme type:
  • Hash - Distributes rows to partitions equally for load balancing and to overcome the 2 billion row limitation. Specify an expression listing the columns to partition on and the number of partitions to create. You may specify a second scheme of type Hash or Range.
  • Range - Creates partitions for specific values or value ranges. Specify an expression and range specifier.
  • RoundRobin - Distributes rows to partitions equally without specifying partitioning columns. Specify the number of partitions to create. You may specify a second scheme of type Range.

Scripting name: FirstPartitionElement, etc

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

Indexes

The following extensions are available on the General tab:

Name

Description

Type

Specifies the type of the index, which can be:
  • <none> - [default] The server will choose the appropriate index type.
  • Cpbtree - Compressed Prefix B+-Tree, which can show better performance for larger keys for character, string, binary string, or decimal column types, or when the constraint is a composite key, or a non-unique constraint.
  • Btree - Maintains sorted data that performs efficient insertion, deletion and search of records.

Scripting name: DescIndex

Descending

[btree only] 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

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

References

The following extensions are available on the HANA tab:

Name

Description

Cardinality

Specifies the type of cardinality.

Scripting name: HANACardinality

Join type

Specifies the join type.

Scripting name: HANAJoinType

Language Column

Specifies the language column.

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

Specifie"s that the database generation will use the stored procedure sp_grantdbaccess instead of a 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_

Facts (Analytic Views) and Dimensions (Attribute Views)

The following extensions are available on the HANA tab:

Name

Description

Default Client / Language / Member

Specify the HANA default client, language, and (dimension only) member.

Scripting name: DefaultClient, DefaultLanguage, DefaultMember

Multidimensional reporting

[facts] Specifies that multidimensional reporting is enabled.

Scripting name: MultidimensionalReporting

Package / Name / Version

Specifies the HANA package, object name, and version.

Scripting name: _ObjectPackage_, _ObjectName_, _ObjectVersion_

Last Updated Date / at

Specifies when the dimension or fact was last edited.

Scripting name: _LastUpdatedDate_, _LastUpdatedTime_

Dimension Attributes and Fact Attributes

The following extensions are available on the HANA tab:

Name

Description

Default Member / Info Object

Specify the HANA default member and info object.

Scripting Name: DefaultMember, InfoObject

Drill Down Enabled

Specifies the drill down is enabled for the attribute.

Scripting Name: DrillDownEnabled

Hidden

Specifies that the attribute is hidden.

Scripting Name: IsHidden

Key Attribute / Principal Key / Attribute Hierarchy Active

[Dimension attribute only] Specify that the attribute is a key attribute, a principal key attribute, and that the attribute hierarchy is active.

Scripting Name: KeyAttribute, PrincipalKey, AttributeHierarchyActive

Data Type / Length / Scale

Specify the data type, length and scale of the attribute.

Scripting Name: AttributeDataType, Length, AttributeScale

Fact Measures

The following extensions are available on the HANA tab:

Name

Description

Data Type / Length / Scale

Specify the data type, length and scale of the measure.

Scripting Name: MeasureDataType, MeasureLength, MeasureScale