SAP HANA Studio: The New Star Join Modeling

  • by Ned Falk, Senior Education Consultant, SAP
  • August 4, 2014
Learn the basic steps to set up a new flavor of SAP HANA information views, the star join graphical calculation view. Understand why it is a valuable new addition in the HANA Studio modeling tool chest.
Learning Objectives

Reading this article you will learn how to:

  • Create a cube-star join calculation view using dimension calculation views as components
  • Understand the pros and cons for building star schemas with both the older analytic view/attribute view method versus the newer star join/dimension view method
Key Concept

A new graphical calculation view option offered in HANA Support Package 7, called star join, allows for easy modeling of a star schema. Although an analytic view previously allowed the creation of a star schema, it had limitations involving sourcing of measures from more than one fact table. These limitations are not an issue for the new star join graphical calculation view.

Star joins are a new option in your SAP HANA modeling tool chest. They overcome the constraints that limit your options when modeling complex analytical views with measures from more than one table. To illustrate my points with a real-world twist, I’m using a scenario revolving around the analysis of airline performance data.

I show how to create a star join calculation view using dimension calculation views and explain the pros and cons of this new method and the older analytic view/attribute view methods. Before I delve deeper into this new star-join concept in SAP HANA, however, first let me review the basics of the existing modeling method for complex star schemas in SAP HANA.

Note
This article enables an SAP HANA modeling professional to create new star join models in SAP HANA. I do not, however, provide the details needed for the basics of modeling in SAP HANA. For that, attend the HA100 or HA300 classes offered by SAP or find online e-learning courses on the web.

Ned Falk

Ned Falk is a senior education consultant at SAP. In prior positions, he implemented many ERP solutions, including SAP R/3. While at SAP, he initially focused on logistics. Now he focuses on SAP HANA, SAP BW (formerly SAP NetWeaver BW), SAP CRM, and the integration of SAP BW and SAP BusinessObjects tools. You can meet him in person when he teaches SAP HANA, SAP BW, or SAP CRM classes from the Atlanta SAP office, or in a virtual training class over the web. If you need an SAP education plan for SAP HANA, SAP BW, BusinessObjects, or SAP CRM, you may contact Ned via email.

See more by this author


Comments

1/25/2017 11:01:32 PM
Ketul Raval

The graphics given in article are too blurry or not clear , can't read the join name etc. can not enlarge it as well.

Is it possible to post more bigger and clear graphics?
9/17/2014 12:17:51 PM
Ken Murray

Hi Ned, Thanks for passing this kind of detail on to us! Great article!
Ken Murray

Please log in to post a comment.

To learn more about subscription access to premium content, click here.