Skip to Content
Product Information
Author's profile photo Tammy Powlas

Leveraging HANA Graphical Modeling for Analytic Reports Webcast Recap

This was an SAP User Group webcast from last week

Abstract:

SAP HANA Calculation View is a powerful option that many SAP customers use to prepare data for various analytic reporting front-ends. In this session we will highlight graphical modeling and Calculation Views in particular from several aspects. One aspect will be the unique features that Calculation Views offer for analytic modeling. A short demo will illustrate how easy it is to develop models by using an intuitive interface. This graphical interface helps to hide the complexity involved and allows to focus on the modeling task itself instead. Another aspect will be how Calculation View modeling integrates into the new development environment of SAP Web IDE. Finally, the way forward, how to migrate Calculation Views into the new development environment, will be discussed.

Links:

Recording

Demo

PDF

Source: SAP

2ha.png

Source: SAP

The legal disclaimer applies

3ha.png

Figure 3: Source: SAP

Agenda

Why graphical vs. SQL view

4ha.png

Figure 4: Source: SAP

Easier to model

Example: star join, means to express it graphically

Graphical – easier to communicate model

Look at right – union, aggregation

Performance can be better

Features

5ha.png

Figure 5: Source: SAP

Integrate SQLScript

Code inside

Load data for warehousing

6ha.png

Figure 6: Source: SAP

Push down filters

Control what you want to do exactly

Way to add semantic information – join pruning – define knowledge of data structure; helps optmizer at run time to run faster

Union pruning – additional information on modeler

Column pruning – large view with a lot of columns, and if you only need a few columns, not all columns are processed, which is faster

7ha.png

Figure 7: Source: SAP

Debug view – see how it is processed

8ha.png

Figure 8: Source: SAP

Way to autodocument model to share knowledge to others

Options to do lineage analysis

Various options to do data previews (not for reporting, for understanding of models)

9ha.png

Figure 9: Source: SAP

OLAP features, pivot columns

Calculated columns – on the fly during query run time

10ha.png

Figure 10: Source: SAP

Support hierarchies

History tables

Support client handling (ABAP feature)

Analytic privilege support – security on a record level

11ha.png

Figure 11: Source: SAP

When features were introduced

12ha.png

Figure 12: Source: SAP

Anonymization

Non-equi joins – join based on dates

13ha.png

Figure 13: Source: SAP

Fuzzy search – search for not just exact matches, typos

Easy to switch to upper case

Unified modeling environment

14ha.png

Figure 14: Source: SAP

Web IDE for SAP HANA- one integrated environment

New features are only available in Web IDE

Old DEV environments have been deprecated

15ha.png

Figure 15: Source: SAP

16ha.png

Figure 16: Source: SAP

Benefits – move to the cloud environments

17ha.png

Figure 17: Source: SAP

Deprecated views

Only support calculation views

Need to migration to new environments

Question & Answer

Q: Does the new Web editor require XSA

A: In cloud, don’t need it, it runs in Cloud Foundry

Q: What is the front end screen for end users to consume analytics generated by SAP Web IDE

A: Depends on needs – Analysis Office, Lumira

Q: Can we connect the Web IDE on SAP cloud to on premise HANA ?

A: Not possible yet

Q: is it the same as the web IDE as the Web IDE in HANA XSA ?

A: no but feature wise similar

Q: can you suggest learning materials for HANA Web IDE beginner

A: Blog, what is changing is how you develop, https://developers.sap.com/india/topics/sap-webide.html#tutorials

https://blogs.sap.com/2018/12/13/overview-modeling-in-sap-web-ide-compared-to-sap-hana-studio

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Lucia Subatin
      Lucia Subatin

      Thanks for sharing, Tammy! Great info as usual.

      May I suggest this group of tutorials for those looking to get started with Calculation Views on Web IDE?

      For on premise: https://developers.sap.com/group.hana-xsa-calculation-view-modeling.html (except for the anonymization, the other two can be done in Web IDE Fullstack with the trial for HANA as a Service)

      For HANA as a Service and Web IDE Fullstack (not the trial, yet): https://developers.sap.com/group.haas-dm-cv.html

      Thanks!

      Lucia.

       

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Thank you, Lucia

      I have been meaning to dig in to the tutorials, I appreciate you providing the links.