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
- SAP HANA Cockpit 2.0 SP 05 What’s New – by the SAP HANA Academy
For the complete list of the SAP HANA cockpit 2.0 What’s New blogs, see
- What’s New – SAP HANA cockpit 2.0 – by the SAP HANA Academy
For the complete list of SAP HANA 2.0 SPS 03 What’s New blogs, see
- What’s New – SAP HANA 2.0 SPS 03 – by the SAP HANA Academy
For the Getting Started with SAP HANA cockpit 2.0 blog, see
- Getting Started with SAP HANA Cockpit 2.0 – by the SAP HANA Academy
For the full SAP HANA cockpit playlist on YouTube, see
Documentation
New features and known issues are documented in
- SAP HANA Cockpit SP 06 Features – What’s New in the SAP HANA Cockpit 2.0
- 2604594 – SAP HANA cockpit 2.0 SP 06 – SAP Note
For all SAP HANA cockpit documentation, see
- SAP HANA Cockpit – SAP Help Portal
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
- Managing Table Redistribution in SAP HANA Cockpit – SAP HANA Administration Guide
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
- Analyze Memory Statistics – SAP HANA Administration Guide
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
- Authorizations Needed for Monitoring and Administration – SAP HANA Administration Guide
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
- Data Anonymization – SAP HANA Administration Guide
- SAP HANA Data Anonymization – SAP HANA Security Guide
- Anonymize Data Using Calculation Views – SAP HANA Modeling Guide
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
- Add a SAML Identity Provider in SAP HANA Cockpit – SAP HANA Administration Guide
- Single Sign-On Using SAML 2.0 – SAP HANA Security Guide
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
- 2604594 – SAP HANA cockpit 2.0 SP 06
- 2380291 – SAP HANA 2.0 Cockpit Central Release Note
- 2373065 – SAP HANA 2.0 Database Explorer Release 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
- Subscribe to our YouTube channel for updates
- Join us on LinkedIn linkedin.com/in/saphanaacademy
- Follow us on Twitter @saphanaacademy
- Google+ plus.google.com/+saphanaacademy
- Facebook facebook.com/saphanaacademy