Skip to Content

The SAP HANA Dynamic Tiering Quick Start Guide provides a hands on introduction to using the features and functions of the Dynamic Tiering component. The Quick Start Guide consists of 6 modular lessons starting with Lesson 1 which focuses on creating tables in the Dynamic Tiering extended storage, loading data and moving data between in-memory and Dynamic Tiering tables. Lesson 1 is a pre-requisite for the later lessons. Once lesson 1 is completed, the other lessons can be completed in any order.


Required Files


Each lesson within the Quick Start Guide is published as a separate document. The first lesson – “Creating Tables and Loading Data” is a pre-requisite to the later lessons as it establishes the HANA schema, including the extended tables, which will be referenced in the later lessons. In addition there is a set of supporting data files and SQL scripts.


  1. Lesson 1 – Creating Tables and Loading Data
  2. Lesson 2 – Query Processing in SAP HANA Dynamic Tiering
  3. Lesson 3 – Monitoring SAP HANA Dynamic Tiering Using HANA Studio and HANA Cockpit
  4. Lesson 4 – Backup and Recovery of SAP HANA Dynamic Tiering
  5. Lesson 5 – Managing Disk Storage Space for SAP HANA Dynamic Tiering
  6. Lesson 6  – Data Modelling with Calculation Views and Extended Tables

The supporting files can be downloaded from SAP HANA Dynamic Tiering Quick Start Guide – Supporting Files

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Naresh Setty

    Hi Robert,
    I created a Profile using DWF framework and asuccessfully moved the data from Hot to Cold. It also generated pruning views, Union views.

    I am trying to wrap pruning view into another calculation view and able to activate it but when I do data preview/query it, I am getting following authorization errors.

    [20053]{334380}[356/-1] 2016-10-14 00:01:30.686660 e ceExecute        cePopQo.cpp(00235) : Caught ptime::PtimeException: ‘insufficient privilege: Not authorized: line 1 col 3208 (at pos 3207)’; schema='{{USERSCHEMA}}’; user=’_SYS_REPO’

    Note : Our tables are created using Hana native CDS.

    Can you pl. suggest

    (0) 

Leave a Reply