Skip to Content

Dear Friends of SAP HANA data warehousing foundation,

Now that we are in the new SAP Community, I’d like to welcome you. This blog is the landing page for you, providing continuously updated content incl.  valuable product information. For latest information follow the tag SAP HANA data warehousing foundation


Since March 2017 SAP HANA Data Warehousing Foundation 2.0 is available

Support Packages: SP02 for HDWF 2.0

Documentation: The most current information on installation prerequisites is available online at


SAP HANA Data Warehousing Foundation 1.0: This first release will provide packaged tools for large Scale SAP HANA use cases to support data management and distribution within a SAP HANA landscapre more efficiently. Further versions will focus on additional tools to  support native SAP HANA data warehouse use cases, in particular data lifecycle management.

Support Packages

SP 05 for HDWF 1.0 is available now. Documentation: The most current information on installation prerequisites is available online at


Blogs from the Experts

SAP HANA Data Warehousing Foundation  Playlist In this SAP HANA Data Warehousing playlist you will find demos showing the Data Distribution Optimizer (DDO) as well as the Data Lifecycle Manager (DLM)

SAP HANA Academy
Find out more about the Data Temperature integration with HANA including Data Lifecycle Management on the DWF YouTube channel of SAP HANA Academy

In his 4 video tutorials,SAP HANA Academy: SAP Data Warehousing Foundation: HANA Native datastore object Sefan Linders introduces the Native DSO, part of the SAP HANA 2.0 web IDE, with which you can manage data in your Native HANA data warehouse.




Let’s thrive this community with your active contributions ranging from blogs to questions and answers. For more info, see the quick start guide.

Optimize you search by using the tag “SAP HANA Data Warehousing Foundation” 


To report this post you need to login first.


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

  1. Former Member


    I created a profile in DLM on a given table to move the data from Hot to cold and it created a pruning view. I am trying to create a calculation view by including this pruning view to use in my application and encountering the following issue. I gave select grant access on the schema sap_hdm_dlm_gnr to _sys_repo

    I can not think of any other access and I am able to create views but not on top of the PVIEW created by DLM.

    (ERROR, error code: 40117, error message: Repository: Encountered an error in repository runtime extension;Model inconsistency. Create Scenario failed: The following errors occurred: user is not authorized (2950)


  2. Mike Curl


    I’m trying to find an up to date summary of the main differences between data tiering approaches on HANA native and BW/4HANA. We have a hybrid EDW. The DWF seems to have unlocked some new options.

    Any pointers or summaries appreciated!

    Many thanks,


    1. Gary Elliott

      Hi Mike,

      Did you get a response on this? Slide 12 in this presentation gives you a high level overview of each of the different platform options. For high level differences on data tiering between XS Classic and XS Advanced, scroll down to “Data Lifecycle Manager (DLM) – XS-Classic” and “Data Lifecycle Manager (DLM) – XS-Advanced” in this blog. The DWF looks pretty slick.




Leave a Reply