Wednesday 23 December 2015

SAP Certified Support Associate: SAP HANA - by the SAP HANA Academy


Interested in getting certified as official SAP HANA supporter? In this blog, I will explain how you can prepare for the SAP Certified Support Associate - SAP HANA certification exam.

This blog is part of a series.
About the Certification

The Support Associate certification was introduced with SPS 06 (June 2013). Tim Breitwieser blogged about it at the time on SCN:SAP HANA Certification Program extended with "SAP Certified Support Consultant". In this blog he explained that the exam is "a pre-requisite for VARs to become authorized to deliver support for SAP HANA". For those that have access to SAP PartnerEdge, you can find all information in the Overview Presentation: VAR-Delivered Support for SAP HANA.

Topic Areas

There are 80 questions divided over ten topic areas. Cut score is 60%, which means that you need to answer at least 47 questions correct. Below the different topics and their relative weight. See the C_HANASUP_1 page on the SAP Training and Certification Shop for the specifics.

SAP Hana EIM (SDI/SDQ) setup

In my documentation I’ll explain how to setup and configure SAP Hana SP10 EIM (SDI/SDQ) with Sybase IQ database and ERP on Hana database schema source system to replicated data for realtime data replication.

I will show in detail step and configuration point to achieve it.

In order execution
  • Create Sybase IQ database
  • Enable DP server for SDI
  • Enable Script server for SDQ
  • Install SDQ cleanse and geocode directory
  • Install DU HANA_IM_DP (Data provisioning)
  • Install and Register Data Provisioning Agent
  • Create remote source
  • Data replication and monitoring
Configuration required on SP9
The xsengine needs to be turn to true (if not done)
The statistic server needs to be turn to true (if not done)
The DU HANA_IM_ESS needs to be imported

Monday 21 December 2015

How to Setup Hana Authorization Trace

How to activate an Authorization Trace in case of authorization Problems:
(something similar to Transaction ST01 in Netweaver ABAP)

Go to Hana System Administration, Trace Configuration:

SAP Hana Authorization Trace

User Specific Trace, select New Configuration (small Icon 'Create' upper right Corner of User-Specific Trace)

Getting the Counters right with stacked Calculation Views

Data Modeling in SAP HANA provides great amount of flexibility to the end user. One of the key capabilities in Modeling sector of SAP HANA is computation of user required calculations. One of the variations in calculation which end user can perform in Calculation Views/Analytic Views is 'Counter'.

Let us now understand the operations under the hood when stack of Calculation Views are created in a project.

Consider a simple 'Product Details' table which comprise of the product information along with its sales information as shown below:

Product Store Customer Quantity Revenue Unit
Headset METRO ALDI 2 120 PACKG
ipad METRO ALDI 10 6000 PACKG
ipad METRO IBM 10 6000 PACKG
Budweiser EDEKA IBM 360 720 BOTTL
Coke EDEKA IBM 250 375 BOTTL
Coke EBAY IBM 200 300 BOTTL
Headset EBAY IBM 10 600 PACKG
ipad EBAY ALDI 10 600 PACKG

Friday 18 December 2015

Auto Documentation Functionality in HANA Studio

When the user creates Views in HANA Studio under “Contents”, he can automatically generate the documentation about the views. This generated document will have the details about all the view belongs to a package which he selected for Auto Documentation.

The user can invoke the Auto Documentation from three places.
  1. Right click Context menu of the Package or the Views
  2. On the top right corner of the opened view
  3. Quick Launch->Content->Auto Documentation

Auto Documentation Functionality in HANA Studio

There are two types of Documents available
Model Details:
This lists the information about the views included
For Eg: In case of Analytical View,
Name of the View, Activation Status, Owner who created, Creation time, Package it belongs to, the Attributes and Measures it has(Private Attribute, Calculated Attribute, Measures, Calculated, Restricted Measure,etc)
This will have a collection of (PDF) files for each View belongs to a package the user selected

Wednesday 16 December 2015

SAP HANA SPS 11 What's New: Security - by the SAP HANA Academy


In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 11.

What's New with SAP HANA SPS 11 - by the SAP HANA Academy

The topic of this blog is security.

SAP HANA Academy - SAP HANA SPS 11: What's New? - Security - YouTube

Exception aggregation modeling with Graphical Calc view

The business scenario is quite common in the BI reporting. Consider a KPI, required to be calculated at a low level of granularity, but the reporting is required at the higher level of granularity. With the default aggregation behavior of the calc view, the constituents of the Calculated KPI might also be aggregated at the reporting granularity level, resulting in incorrect value for the Calculated KPI.

To elaborate more on this, consider the following data model for the Sales Transaction. The transaction data is captured for Product Sold on a given date in a store. The table structure can be defined as follows:

( STORE_ID    nvarchar(10),  --- Store Id
  PROD_ID    nvarchar(10),  --- Product Id
  PROD_CAT    nvarchar(10),  --- Product Category
  PROD_PRICE  decimal(10,2), --- Product Price
  SOLD_QTY    integer,      --- Product Quantity Sold in a Sales transaction
  TRANS_DATE  nvarchar(8),  --- Sales Transaction Date
  STORE_REG  nvarchar(10)  --- Region in which the Store is located

The business rule could be:
The product price may vary each day, hence the Net Sales need to be calculated for the Product Price on the transaction date and Quantity Sold on the day.

Wednesday 2 December 2015