Skip to Content
Author's profile photo Denys van Kempen

SAP HANA Cockpit 2.0 SP 06 What’s New – by the SAP HANA Academy

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:

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

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:

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

 

Assigned Tags

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