Now that you have created the calculation views, you will need to activate them. Right click AV_ORDERS
and click Activate.
A wizard will pop up, in which you can select further objects to activate. Dependencies are automatically selected. Note how AT_REGION
, which AV_ORDERS
depends on, was added automatically.
Add CALC_ORDERS
from the package to the list of selected models as well. Then, click Activate.

After they have been activated (you can check the Job Log for progress), the will lose the grey diamond beside their icon.
You have now successfully converted all views from the original information model into calculation views.
Here’s what each view does:
AT_REGION
This view takes in 3 tables, and combines their attributes to create a table of region names with corresponding customer keys. It takes the customer key column from the CUSTOMER_CS
, the region name column from REGION_CS
, and combines them using mutually inclusive columns located in NATION_CS
.
AV_ORDERS
This view takes the attribute view created before (AT_REGION
) and joins it with 4 columns from ORDERS_CS
. The result is a table showing each customer key, and the corresponding region name, order status, order date, and total price.
CALC_ORDERS
This view performs the same functionality as AV_ORDERS
, but is created as a calculation view type. It uses a union node to join AT_REGION
and ORDERS_CS
, to output a table showing each customer key, and the corresponding region name, order status, order date, and total price.