Skip to Content
Previous

Create a Cube Calculation View (XS Advanced)

By Lucia Subatin

Create a graphical calculation view with a cube data type.

Details

You will learn

  • How to create a calculation view with a Cube data type
  • Use a star join to combine data from a dimension calculation view and a table
  • Perform currency conversion

Step 1: Create a new Calculation view of type Cube

Create a new calculation view in your models folder.

Create calculation view

Call it PURCHASE_ORDERS, choose CUBE as a data category and mark the flag for With Star Join

Call it PO
Please log in to access this content.
Step 2: Join header and items

Drag and drop a join node and add click on the + sign to add the data sources

New Join node

Type PO and choose both PO.Header and PO.Item and click Finish.

Call it PO

Create a inner join using PURCHASEORDERID and set the cardinality as 1..n

Call it PO

In the mapping tab, add the following columns to the output: PURCHASEORDERID, HISTORY.CHANGEDAT, PRODUCT.PRODUCTID, CURRENCY and GROSSAMOUNT.

Mapping

Finally, rename the node to PO.

Please log in to access this content.
Step 3: Join Purchase Orders with products dimension

Connect the output of the join to the Star Join. Use the + sign to search and select PRODUCTS.

Create star join

Join the PRODUCTID and PRODUCT.PRODUCTID as an inner join.

Mapping
Please log in to access this content.
Step 4: Create an input parameter

In the Input Parameters tab, create an input parameter named IP_O_TARGET_CURRENCY.

Mapping

Configure it as NVARCHAR, length 3 with a Semantic type of Currency.
Flag it as mandatory and set a default value of USD.

Mapping
Please log in to access this content.
Step 5: Configure semantics for currency conversion

Go into the mapping tab and double click on the PO parent node to add all of the fields to the output. Add the GROSSAMOUNT a second time.

Mapping

Change the name of the duplicate column to OriginalGrossAmount.

Mapping

Click the semantics node and assign semantics for GROSSAMOUNT.

Mapping

Choose Amount with Currency Code and configure as follows:

  • Display Currency: column, choose GROSSAMOUNT_CURRENCY
  • Check the Conversion and Decimal shift boxes
Mapping

Click on the definition tab and use the following configuration

Mapping

Save the view.

Please log in to access this content.
Step 6: Build and preview

Build the db module and return to the database explorer

Mapping

Navigate to the column view, right-click on it and select Open Data.

Final view
What happens when you execute the view?
×

Updated 09/06/2018

Time to Complete

15 Min.

Intermediate
Next
Back to top