Skip to Content
Technical Articles
Author's profile photo Gordon Witzel

SAP BW/4HANA Data Tiering Optimization

Dear friends of SAP BW/4HANA,

I’m working for SAP since more than 10 years and as a member of the BW product management team I received a lot of questions from customers regarding new functionalities for data lifecycle mangement and data aging strategies in SAP BW/4HANA.

Therefore, I would like to share a summary of the currently available information.

With SAP BW/4HANA 1.0 SP04 SAP is providing functionality to classify persistent BW data into hot, warm and cold.

In this blog, I’ll explain the advantages of the SAP BW/4HANA exclusively available new feature for Data Tiering Optimization (DTO) in technical details.


Data Tiering Optimization helps SAP BW/4HANA customers to classify the data in the DataStore object (advanced) as hot, warm or cold, depending on the cost and performance requirements for the data.

Depending on this classification and how the data is used, the data is stored in different storage areas. Data Tiering Optimization provides a central UI, where all storage options can be set. The partitions from the SAP HANA database are used for this.

The following options are available:

  • Standard Tier (hot): The data is stored in SAP HANA.
  • Extension Tier (warm): The data is stored in a SAP HANA extension node. Only SAP HANA Extension Nodes can be used for warm data storage in SAP BW/4HANA – SAP HANA Dynamic Tiering is not applicable to SAP BW/4HANA.
  • External Tier (cold): The data is stored externally (SAP IQ or Hadoop (Hadoop is only available with SAP BW/4HANA 1.0 FP08 or higher)).


Overview presentation:

SAP Data Tiering Optimization is an option to optimize the memory footprint of data in SAP BW/4HANA and streamline administration and development, thereby reducing TCO.

Introducing one data tiering concept for hot, warm and cold data based on Advanced DataStore Objects enables users to create full flexible partitions based on the data temperature in SAP BW/4HANA. Find the full presentation here:

Data  Tiering  Optimization with SAP BW/4HANA  – Updated Version

Furthermore find a technical overview presentation of the SAP HANA Extension Nodes here:

SAP HANA Extension Node – Technical Overview presentation

Getting started

General Information

Set Up and Installation

Cold Store with SAP IQ (fka Nearline Store)

Warm Store with SAP HANA Extension Node

  • SAP Note 2343647 How-To: Configuring SAP HANA for the BW Extension Node
  • SAP Note 2453736 How-To: Configuring SAP HANA for SAP BW Extension Node in SAP HANA 2.0
  • SAP Note 2415279 – How-To: Configuring SAP HANA for the SAP HANA Extension Node

General Information

  • SAP Note 2296290 – New Sizing Report for BW/4HANA

Implementation and Administration

Cold Store with SAP IQ (fka Nearline Store)

  • SAP Note 2165650 FAQ: BW Near-Line Storage with HANA Smart Data Access
  • SAP Note 2100962 FAQ: BW Near-Line Storage with HANA Smart Data Access: Query Performance
  • SAP Note 1999431 SIQ: Setting up SSL for connections to IQ
  • SAP Note 2133194 Can SAP IQ run in a cloud environment?

Warm Store with SAP HANA Extension Node

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Brian Wood
      Brian Wood


      Nice job Gordon, I sent a few questions to you via email. Thanks!

      Author's profile photo Mihir L Kiri
      Mihir L Kiri

      Hi Gordon,

      What does "Dynamic Partitioning Schema" mean ? It is mentioned in "Future direction". Doesn't it contradict when we say "SAP HANA Dynamic Tiering is not applicable to SAP BW/4HANA."

      Or the is a mistake in my understanding.


      Mihir Kiri



      Author's profile photo Gordon Witzel
      Gordon Witzel
      Blog Post Author

      Hi Mihir,

      “Dynamic Partitioning Schema” means  that the partition is able to cope with additional data outside of the expected range and DTO is able to self extending partitioning schemes.

      Furthermore for warm data in DTO we are using Extension Nodes (additional Hana Scale Out node with a relaxed sizing formula and RAM/CPU ratio. Therefore SAP HANA Dynamic Tiering is not applicable and not supported with SAP Data Tiering Optimization.

      BR Gordon.


      Author's profile photo Ebert Toxqui
      Ebert Toxqui

      Excellent update for BW4HANA toolset to maintain this directly at BW4HANA instead manual maintenance at different levels!! Then, SAP HANA landscape reorganization was replaced by Data Distribution Optimizer for BW4HANA, doesn't it?

      From LSA++ perspective, How could be manage effectively Corporate Memory for huge aDSOs when handled in an scale out architecture, where exists multiple tables bigger than 2 billion recs per table and with non cumulative key figures?  I understood that must be partitioned (with Cold data retained at SAP IQ)  and also used Semantic group (also applying multitemperature concept once it was classified by a key field (region, country, etc) but still I have restriction for non cumulative key figures at SAP IQ and maximum partitions are limited to 1024.

      Please let me know


      Author's profile photo Matthias Klocke
      Matthias Klocke

      This is the best introduction to DTO, technical prerequisites and usage!

      Also, in the latest update from November 2018 I think one limitation is more clearly mentioned:

      *Validation with upcoming Vora release still pending (see note 2608405 SAP Vora cold store: Informations, Recommendations and Limitations ).

      Author's profile photo L. Frank
      L. Frank

      Thanks for this DTO overview! I understand that data tiering is only possible in aDSO's. Can it be applied in aDSO's in "BW on HANA" or is it only possible in BW/HANA? When I check the aDSO in our system (7.5 SP11), I only see the checkbox "SAP BW Data Tiering" and no setting for temperartures... Is there documentation available for temperature settings when using "BW on HANA"...

      Author's profile photo Gordon Witzel
      Gordon Witzel
      Blog Post Author


      DTO is exclusively available for SAP BW/4HANA.



      Author's profile photo Miguel Matos
      Miguel Matos

      Hello Gordon


      Congratulations on this blog, it is very helpul.


      I have a question for you, I'm following the steps of the video Build a aDSO and creating partitions for hot, warm and cold data. but I'm getting this message (see image below)

      Maybe I'm doing something wrong. What I'm trying to do is, to split a data set in 3 different months (by partionting object) and then apply the corresponding data temperature to each month of data.

      This is the first time I'm doing this, and probably I made a mistake or something. Could you guys help me in finding what am I missing?



      Best regards,


      Author's profile photo Gordon Witzel
      Gordon Witzel
      Blog Post Author

      Hi Miguel,

      You want to change a DataStore object (advanced) that contains data.

      The System created a Remoling Request. Please execute the remodeling request in the backend.

      More Information here:


      Author's profile photo Miguel Matos
      Miguel Matos



      Thanks a lot Gordon! I have one last question. I clicked on the "remodelling is pending" message, and it took me to the RSCNV_MONITOR transaction. But I don´t see the remodelling steps there...


      I have serious doubts about this, I mean, am I doing something wrong? or maybe is there some step that I am missing?


      Do you recommend me to open an expert chat, maybe?






      Author's profile photo Gordon Witzel
      Gordon Witzel
      Blog Post Author



      yes you should see the remodeling request and the steps there. Have you tried to Start the Request (top Right).

      Otherwise please open a support ticket.



      Author's profile photo Miguel Matos
      Miguel Matos

      Thank you so much Gordon.

      Author's profile photo Avinash Neeli
      Avinash Neeli


      You can go to same screen from RSMONITOR t-code and in the selection ensure you select the from date as 'on or before the date on which the change is moved/done to that ADSO', then you should find that request.

      In case you have deleted the data in the ADSO then re-modelling request will be automatically removed some times.

      Regards - Avinash.

      Author's profile photo Steve Henbury
      Steve Henbury

      Hi Gordon

      Very useful blog, Thank you.

      I have a question on the hot, warm and cold tiers, what is best practice for use of these tiers, I have read through documentation but I am still not clear.

      Many thanks





      Author's profile photo Christoph Hannen
      Christoph Hannen

      Hi Gordon,

      are there any plans to make the new HANA Native Storage Extension (NSE) from HANA 2.0 SPS4 available as a further option for warm storage in DTO (for customers having no scale-out)?

      If yes when and from which BW release?

      Many customers are looking for a solution to reduce memory consumption without adding too much complexity to the architecture...



      Author's profile photo Christoph Hannen
      Christoph Hannen

      Well I think here is the response: NSE is available from BW/4HANA 2.0 SP 4 onwards:

      See: What's New in SAP BW/4HANA 2.0 (Release Information) 2.0 SP4 => Operation =>

      Data Tiering Optimization (Enhanced)


      Author's profile photo Mamta Pathak
      Mamta Pathak


      Thank you for this article.

      I have a question. We are on BW4HANA 2.0 SP1 and have IQ configured as NLS.
      Through DTO, I am able to change multiple partitions to Cold store. But when try to get them back to Hot, it gives exception. One at a time is working fine.

      Is this a limitation, or a configuration bug?

      Author's profile photo Avinash Neeli
      Avinash Neeli

      Hi Gordon,

      Thanks for nice article.

      I have seen the video "Creating a query based on the aDSO partitions.", however for reading near line storage there is an option of creating a manual input variable which we used in old BW. Seems like same option is available in BW/4HANA but I am not able to find that create button.

      Can anyone help me (guide me) on how to create a nearline storage variable in BW/4HANA, so that option/choice can be given to end-user to choose.

      Thanks & Regards,

      Author's profile photo Klaus Reiner
      Klaus Reiner

      Hi Gordon,

      I do have a customer who is interested in NLS. We discussed this and two Questions came up:

      • My Customer does not have a separate BW-System but is using BW-Embedded on SoH 7.5 Netweaver which is working fine. Is NLS also supported for the BW-Embedded Scenario then?
      • Database: NLS seems to require IQ-DB as NLS-Database. As my customer uses internally maxDB on various Systems the Question came up if the database of the NLS-System can
        also be maxDB instead of IQ-DB. Admins would prefere  maxDB as they are not familiar
        with the IQ-DB at all.
      • In case IQ-DB is the only NLS-Database supported, how about the Costs of that database?
        Is it for free when we use it for BW-Embedded NLS and if not who to calculate the Costs then?

      Really would appreciate your help on this. Thank you.

      Kind regards,

      Author's profile photo Roland Kramer
      Roland Kramer

      Hello Klaus Reiner

      1. Yes, when the embedded BW run's in an additional Client
        for NLS in general, see -
        Note 2780668 – SAP First Guidance – BW NLS Implementation with SAP IQ
      2. NLS and DTP works only with SAP IQ as secondary Database, MaxDB is not supported
        see also the Blog - SAP (Sybase) IQ – the hidden treasure …
      3. the SAP-NLS (DTO) "License" comes as a bundle together mostly with BWoH or BW/4
        for Details, see

      These Answers cam from Roland Kramer

      Best Regards Roland Kramer