Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
dvankempen
Product and Topic Expert
Product and Topic Expert

Introduction


In the upcoming days and weeks, we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA 2.0 SPS 03.

The topic of this blog is SAP HANA cockpit 2.0 SP 06, released together with SAP HANA 2.0 SPS 03.



For the previous version of this cockpit What's New blog, see

For the complete list of the SAP HANA cockpit 2.0 What's New blogs, see

For the complete list of SAP HANA 2.0 SPS 03 What's New blogs, see

For the Getting Started with SAP HANA cockpit 2.0 blog, see

For the full SAP HANA cockpit playlist on YouTube, see


Documentation


New features and known issues are documented in

For all SAP HANA cockpit documentation, see



 

SAP HANA Cockpit SP - Release Notes

 

Administration and Monitoring


Table Redistribution


On a distributed or scale-out system, the location of tables and table partitions might affect the performance of a query. For this reason, at times you may need to optimize the redistribute of tables or table partitions. Similarly, when adding or removing hosts on a distributed system, you also typically need to perform table redistribution operations.

To facilitate table distribution, as of SP 06, you can now view and save current table distributions to a plan, which can be restored when needed. You can also automatically generate optimzed distribution plans.

For the documentation, see

Memory Analysis - Open In


You can now navigate directly from the Memory Analysis page to the Performance Monitor or Workload Analysis, and from there to other apps or pages. Previously, you had to first return to the Overview page. Open In navigation aides make it easier to investigate issues without distraction.

For the documentation, see



SAP HANA Cockpit - Memory Analysis



SAP HANA Cockpit - Performance Monitor

Required Privileges Documentation


The authorizations needed for monitoring and administration in the SAP HANA cockpit are now documented.

For the documentation, see

User Management and Security Administration


Data Anonymization Views


As of SPS 03, SAP HANA provides native support for data anonymization. This allows you to gain statistically valid insights from data containing personal or sensitive information while protecting the privacy of individuals.

How this works is explained by Sinéad:

https://youtu.be/4rC3iAupW04

As of SP06, you can get a list of all the calculation views that have one or more anonymization node views configured using the link View anonymization report under Security Related Links.

For the documentation, see

Manage SAML identity providers


A new page (app) has been added to the SAP HANA cockpit where you can add and manage the SAML identify providers for your SAP HANA system.

For the documentation, see



SAP HANA Cockpit - Overview



SAP HANA Cockpit - Configure SAML Identity Providers



SAP HANA Cockpit - New User

SAP HANA Database Explorer


Whereas for the earlier versions of the SAP Web IDE for SAP HANA and the SAP HANA Database Explorer the focus was on achieving feature parity with the SAP HANA 1.0 studio tool, as of SPS 02 and more specifically SPS 03, they clearly go beyond to what studio had to offer with a very rich set of features to support data modeling and native development for SAP HANA.

Background Activities with Monitor


Two options have been added to the Run command for SQL statements:

  • Run as Background Activity

  • Run on Multiple Databases


On the right pane, you can access the Background Activities Monitor to view progress and result of the statement.






SQLScript Code Analyzer


You can now analyze a procedure or function written in SQLScript to search for patterns indicating problems in code quality, security or performance. Choose the Analyze SQLScript Code option from the context menu of a database, schema, procedure, or function.


Catalog Browser


In the catalog browser now displays both Graph Workspaces and Table Types, and a right-click on a  Graph Workspaces opens a new editor that shows the properties of the graph workspace and allows you to apply filters and algorithms to your graph workspace.



For an introduction, watch Philip's Getting Started, below.

For the full story, see his blog

For the documentation, see

https://youtu.be/Z1vP-qFIySA?list=PLkzo92owKnVwCuJeNPcC7J_v4eT5_s6-d

Debug Logging and Remove User Data


Under preferences, a new section for Database Explorer has been added where we can enable debug logging and remove user data. Debug logging needs to be confirmed informing the user about  data protection and privacy regulations impact, and there is a visual indicator (recording) that reminds the user about debug logging being enabled.






Remote Source


You can now create remote sources in the database explorer and create virtual objects from those remote sources.



For the documentation, see


SQL Debugger


All debuggers in the SAP WEb IDE, Node.js, Java, SQLScript, now have a common look and feel.


Data Preview Hierarchies


The Data Preview editor for dimension calculation views and CUBE calculation views now contains a Hierarchies tab that shows hierarchies and measures details if they are available for the view.

Backup and Recovery


Recover SAP HANA 1.0


With SAP HANA cockpit 2.0 SP 06, you can restore both SAP HANA 2.0 and 1.0 (SPS 12) databases. Before, only 2.0 databases could be restored using cockpit.

For the documentation, see

SAP HANA XS Advanced Cockpit


SAP HANA Platform 2.0 SPS 03 introduces the new and enhanced version of SAP HANA XS Advanced Administration tool called SAP HANA XS Advanced Cockpit.

For an overview, see the next tutorial video:

https://youtu.be/J5KxoBcjMg8?list=PLkzo92owKnVx6qZK63YmISEnVWddx_LA_

References


For more information, see:

SAP Community Blogs



SAP Help Portal



SAP Notes



Thank you for watching


The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library - by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy