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 −

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.

Calculation View

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.

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 −

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.

Employees

Advantages of Using a 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.

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.