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


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.





Source: SAP


Source: SAP

The legal disclaimer applies


Figure 3: Source: SAP


Why graphical vs. SQL view


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



Figure 5: Source: SAP

Integrate SQLScript

Code inside

Load data for warehousing


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


Figure 7: Source: SAP

Debug view – see how it is processed


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)


Figure 9: Source: SAP

OLAP features, pivot columns

Calculated columns – on the fly during query run time


Figure 10: Source: SAP

Support hierarchies

History tables

Support client handling (ABAP feature)

Analytic privilege support – security on a record level


Figure 11: Source: SAP

When features were introduced


Figure 12: Source: SAP


Non-equi joins – join based on dates


Figure 13: Source: SAP

Fuzzy search – search for not just exact matches, typos

Easy to switch to upper case

Unified modeling environment


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


Figure 15: Source: SAP


Figure 16: Source: SAP

Benefits – move to the cloud environments


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,

Assigned Tags

      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: (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):




      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.