Category Archives: Uncategorized

HANA Virtual Data Models

Recently I had a chance to work with HANA VDM – Analytics for ERP 1.0 in sidecar scenario. These built-in views are very valuable for real-time operational reporting. For organization which already made an investment on HANA, implementing these views mean a quick ROI to business users. Another big advantage is to use the existing ECC as-is while using HANA as a secondary database before doing “Integrated Scenario”.

Here are the high level steps I took to implement these views;

Technical System Landscape

  • HANA SPS08
  • SLT 2.0 (Dedicated Server)


  • Verify HANA appliance is functioning and HANA Lifecycle Manager is working (we had an issue which we had to upgrade lifecycle Manager)
  • Installation of SLT 2.0 on Windows server
  • Setup proper roles in ECC and HANA
  • Configuration of replication between ECC and HANA (one to one mapping)


  • Replicate 559 tables from ECC
    • If not all 559 tables replicates, the view activation process will be skipped during HANA Analytics package deployment
    • 1781992 – Tables for SAP HANA Analytics for ERP 1.0
    • 1782065 – Tables for SAP HANA Analytics for SAP Business Suite
  • Configure Schema Mapping
  • Download and Deploy Content package in HANA


Install following adds-on on HANA ( )

  • SAP HANA Live Extensions Assistant
  • SAP HANA Live View Browser
  • Analytical Authorization Assistant (AAA) for HANA Live VDM


  • SAP HANA Live Extensions Assistant

With the SAP HANA Live extension assistant, you can extend query or reuse views delivered by SAP. The tool is an eclipse plug-in for the SAP HANA studio.

  • SAP HANA Live View Browser

SAP HANA Live Browser is a SAP UI5 based web application that allows to browse, search, and tag HANA content views and consume them in SAP Business Objects Lumira or Analysis Office for analyzing the data.

  • Analytical Authorization Assistant (AAA) for HANA Live VDM

Here are some key points which I’d like to investigate more;

–          Create Analytical Privileges in a regular way. This will give us flexibility of the naming of APs and create a custom restriction

  • This is very important considering there are almost 1000 prebuild models / queries for HANA Live

–          For real-time operational reporting we don’t need to replicate ECC security. However it should be granular enough and flexible for security provisioning (example, secure PM KPI from Finance, etc.)

–          Once we create all APs we create Roles and assign APS to role and assign roles to users.

–          This adds-on comes with metadata tab which we could define authorization object (similar to what is done for vendor security in EDW).


We selected couple of queries such as “CostCenterPlanActualCostQuery” and “LocationAndPlannedGroupCostQuery”. We were able to have reconciled them back to the ECC system via Lumira and Aoffice.

Lesson learned

I found Cost Center Hierarchy is missing from “CostCenterPlanActualCostQuery”. There are couple of hierarchy queries available as part of 1018 Calculation Views, however none of them works as hierarchy. I noticed the “ProfitCenterQuery” uses the same set of tables that are required for Cost Center Hierarchy, however here are some challenges;

  • “Profit Center Group” in ProfitCenterNode is hardcoded (0106). This query is not reusable for Cost report.
  • ProfitCenter queries don’t have any hierarchy. For some attributes, the hierarchy property is set to “true” but it doesn’t function as hierarchy.
  • Any change in these queries (reusable query) impact the higher level queries.
  • Any change in these queries could be overwritten by upgrade / patches

Considering these challenges I decided to build a Calculation View for Cost Center Hierarchy which worked as I expected!. This view could be joined with CostCenterPlanActualQuery to provide true hierarchy functionality for cost centers.


How to secure information views in SAP HANA



As more and more organization implement SAP HANA native, S4/HANA or sidecar solutions, the need to understand how to provide access and secure information views has emerge.  The intent of this article is to provide the reader with a few technical details relevant to securing SAP HANA information views.

Before we describe how to secure an information view, let’s quickly define the various information views that are available within SAP HANA.

Attribute Views

Attribute Views are created to serve as a reusable type of view. Developers will create Attribute Views to represent items such as customers, products, dates, salespersons and cost centers. Once activated, they can be joined to one or more analytic view data foundations. Within an attribute view we can also create Hierarchies.

Analytic Views

Analytic Views are created to serve as the SAP HANA Cube. When designing the analytic view, developers will design a data foundation using…

View original post 1,208 more words