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