SAP HANA Calculation View to build virtual keyfigure

In my project I have now the opportunity to build SAP HANA Calculation Views. We use Calculation Views to combine two different Advanced DataStore Objects. First you have to set the parameter External HANA View in the setting of your ADSO. When you activate this setting a SAP HANA Table is created which you can use in a Calculation View.

Create External SAP HANA View for an ADSO
Create External SAP HANA View for an ADSO

The following functions are available for a SAP HANA Calculation View:

  • Join
  • Union
  • Projections
  • Aggregation
  • Rank

In our project we build a view which creates a Month-to-Date (MTD), Quarter-to-Date (QTD) and Year-to-date (YTD) view. For this we have a control ADSO which has the following structure.

Structure of control ADSO
Structure of control ADSO

The control ADSO has also an External SAP HANA View. After the preparation is done and the control data is loaded into the BW, we go back to Eclipse and open the perspective SAP HANA Administration Console. First we add an Inner-JOIN to connect our first ADSO with the control ADSO.

Inner Join with two HANA Tables
Inner Join with two HANA Tables

Now we have created the connection between the two ADSOs. After the JOIN, we created an UNION to have the freedom to add more JOINs in the future. We match now all fields from the source to the target.

HANA View Union Mapping
HANA View Union Mapping

After we matched all fields, we now can select them in the AGGREGATION layer.

HANA View Aggregation Layer
HANA View Aggregation Layer

Now we assign the key figure fields the right Semantic Type.

HANA View Semantics View
HANA View Semantics View

After we activate the Calculation View, we can now see the data in the preview.

HANA View Data preview
HANA View Data preview

But keep in mind, we only have Month-to-Date values in our BW. The Year-to-Date and Quarter-to-Date values are just virtual. I hope this can help someone to build something really cool. Here is the overview of my HANA View.

HANA View
HANA View

author.


I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

SAP Analysis for Office - The Comprehensive Guide
The book SAP Analysis for Office - The Comprehensive Guide by Tobias Meyer is a pdf book about SAP Analysis for Office. It is based on Analysis for Office 2.8 and contains 346 Pages.
45,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.7 and contains 299 Pages.
37,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.6 and contains 272 Pages.
27,00 €

Write a comment

Comments: 2
  • #1

    Aaron Benner (Thursday, 25 October 2018 04:15)

    Could you not use a composite provider to join the 2 ADSO's? Just comparing this to the CV approach.

  • #2

    Aaron Benner (Thursday, 25 October 2018)

    Please disregard, I didn't see the rest of the post before commenting!