Skip to Content
Author's profile photo Robert Waywell
Robert Waywell
August 17, 2015 Less than a 1 minute read

SAP HANA Dynamic Tiering Quick Start Guide – Overview

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

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Naresh Gadamsetti
      Naresh Gadamsetti

      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