- SAP HANA BI Development Tutorial
- Home
- Introduction
- Reporting and Dashboard Tools
- Different BO Tools Connection to HANA
- Creating a Relational Connection
- Creating an OLAP Connection
- HANA Modeling Views
- Input Parameters in HANA
- Using Attribute View
- Using Analytic View
- Using Calculation View
- Using Tables in HANA DB
- Connecting Webi to HANA
- Universe Development
- User Prompts and Filter in IDT
- Webi Report Development
- Lumira Connection to HANA
- Dashboard Development in Lumira
- Dashboard Designer Connection to HANA
- Dashboard Development in DD
- Connecting Crystal to HANA Views
- Crystal Report Development on HANA
- BW on HANA Connection
- Design Studio Connection with HANA
- Development in Design Studio
- Publishing BI Reports on HANA
- Benefits of Using HANA
- Connecting HANA with Other BI Tools
- Interview Questions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Using Calculation View
Calculation views are used to perform complex calculations, which are not possible with Attribute or Analytic view. You can also use Attribute and Analytic views while designing Calculation views.
Following are a few characteristics of Calculation Views −
Calculation Views are used to consume Analytic, Attribute, and other Calculation Views.
There are two ways to create Calculation Views - Using SQL Editor or Graphical option.
It has built-in Union, Join, Projection, and Aggregation nodes.
SAP BusinessObjects reporting tools can connect to Calculation view using an OLAP connection for reporting and dashboard.
How to Create a Calculation View?
Choose the Package name under which you want to create a Calculation View. Right-click the Package → Go to New → Calculation View. When you click the Calculation View, a new window will open.
Enter the view name, description and choose the view type as Calculation View, Sub-type Standard or Time (this is a special kind of View, which adds time dimension). You can use two types of Calculation View - Graphical and SQL Script.
Calculation view provides an option of using a Star Join or not to use a Star Join. Also, it has two different Data Categories −
Cube − When a user selects Cube as data category, the default node is Aggregation. You can choose Star Join with Cube dimension.
Dimension − When a user selects Dimension as data category, the default node is Projection.
Calculation View with Star Join
When you use Calculation view with Star Join, it does not allow base column tables, Attribute Views, or Analytic views to add at data foundation. All Dimension tables must be changed to Dimension Calculation views to be used in Star Join. All Fact tables can be added and can use default nodes in Calculation View.
Example
The following example shows how we can use Calculation View with Star Join.
You have four tables, two Dim tables, and two Fact tables. You have to find a list of all employees with their Joining date, Emp Name, empId, Salary, and Bonus.
Advantages of Using a Star Join
It simplifies the design process. You need not create Analytical views and Attribute Views. Fact tables can be directly used as Projections.
3NF is possible with Star Join.
Calculation View Without Star Join
This allows the use of other Attribute views and Analytic views using different nodes available in Calculation Join.
In the above screenshot, you can see two Analytic views - AN_Fact1 and AN_Fact2 - are used using node Projection 1 and Projection 2 and then joined with the help of a Join node.