Generating Extended Tables for BW Objects

A setting in object maintenance allows you at individual BW object level to define whether the table whose data is in the warm area should be generated as an extended table. While the object is being activated, an extended table is created if the prerequisites for this are met.

Prerequisites

You have installed and configured SAP HANA Dynamic Tiering.
Note Note the licensing conditions when using SAP HANA dynamic tiering.
The extended table is only created upon activation if the BW object does not contain any data yet. If it does already contain data, you can use a program to create the extended table(s) and to move the data.
For DataStore objects, the extended table is only created if the DataStore object does not contain any data yet.

Generating an Extended Table for PSA Tables of the DataSource

Procedure

In the DataSource maintenance transaction in the BW system, choose the General tab and select PSA as Extended. Table.
Note
If you want to make this setting for a large number of DataSources, you can perform mass maintenance using program RS_DYNTIER_CHANGE.
Activate the DataSource.

Results

If the DataSource does not contain any data yet, the system deletes the PSA table and generates an extended table.

If the DataSource already contains data, the system issues a warning during activation that the status of the table cannot be changed. In other words, an extended table cannot be generated. In this case, you can use program RS_DYNTIER_CHANGE with the settings Warm (Extended Storage) and Move Data to create the extended table and move the data there.

Generating an Extended Table for DataStore Objects (advanced)

Prerequisites

You are using the BW Modeling tools version 1.5 or higher.
The DataStore object is created in the function of a write-optimized DataStore object - in other words without activation and only with inbound table.

Procedure

In the maintenance transaction for DataStore objects (advanced) in the BW Modeling tools, go to the General tab and select Extended Table.
Activate the DataStore object.

Results

If the DataStore object does not contain any data yet, the system generates an extended table.

If the DataStore object already contains data, the system issues a warning during activation that the status of the table cannot be changed; in other words, an extended table cannot be generated.

Generating an Extended Table for Writing-Optimized DataStore Objects (classic)

Procedure

Under Settings in the maintenance transaction for the write-optimized DataStore object, choose Extended Table.
Note
If you want to make this setting for a large number of write-optimized DataStore objects or semantically partitioned objects, you can perform mass maintenance using program RS_DYNTIER_CHANGE.
Activate the DataStore object.

Results

If the write-optimized DataStore object does not contain any data yet, the system generates an extended table.

If the write-optimized DataStore object already contains data, the system issues a warning during activation that the status of the table cannot be changed; in other words, an extended table cannot be generated. In this case, you can use program RS_DYNTIER_CHANGE with the settings Warm (Extended Storage) and Move Data to create the extended table and move the data there.