SAP Knowledge Base Article - Preview

2758095 - Select doesn't return data from partition on extended storage - SAP Dynamic Tiering


  • Use Data Lifecycle Manegement to create a rule to define a storage destination table to Dynamic Tiering.

In the following example, rows having I_COL column = 6 are stored in Dynamic Tiering.



  • When exececuting: select * from "SAPIBH"."/BIC/TEST", the rows located in the Dynamic Extended Storage for the I_COL column with values = 6 are not in the result set.



  • SAP Dynamic Tiering 2.0
  • SAP HANA 2.0


SAP HANA dynamic tiering 2.0 ; SAP HANA, platform edition 2.0


pruning view , KBA , HAN-DYT , SAP HANA Dynamic Tiering , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.