Skip to Content
Product Information

What’s New in HANA 2.0 SPS04: Data Warehousing Foundation Webcast Recap

1df.png

Source: SAP

Link to slides are here

2df.png

Source: SAP

Requirements for HANA DW

3df.png

Source: SAP

Load data to Native DSO

New NDSO editor

Generated Flowgraph when execute the NDSO

Flowgraph has been “massively improved”; easy to use; complexity is reduced.

4df.png

Source: SAP

Transfer or relocate hot store to warm (usually in HANA node) or move to cold storage – in XSA typically Hadoop

XS Classic can move to SAP IQ and Hadoop

New in SP04 is the DLM feature; able to combine several tables and move them at once to improve productivity

5df.png

Source: SAP

Setting a column to a key value, from a source or target point of view

6df.png

Source: SAP

7df.png

Source: SAP

See SAP Note for release notes

Need SP04 of HANA to use

8df.png

Source: SAP

Features from NDSO – SP05 simplified authorization – as soon as generate NDSO, the authorization roles are generated and can be used by calc views; no manual work required

Authorization role contains select/execute; other auths need to be manually updated

9df.png

Source: SAP

Separate functionality to use to relocate from hot store (marked in red) – warm in yellow, cold in blue

In older, XSA – could only move hot store to extension nodes

Now can use multi-store tables.

Native storage extension; new possibility how data can be relocated

10df.png

Source: SAP

Suggestion from a customer

Task chain – new in SP05 – if task chain had a sub chain, could not identify root-cause

Now can jump directly

11df.png

Source: SAP

Release is now once a year

Q&A

Q: What is investment on on-premise for SAP HANA DW?

A: Still invest in on-premise, will reduce investment, but still invest, performance improvements for NDSO and HANA DLM

Feature requests validated with other customers

More harder process

Investment is planned

Link to recording is here

Be the first to leave a comment
You must be Logged on to comment or reply to a post.