Skip to Content
test
0 %
Create a Cube Calculation View (XS Advanced)
Details
// Explore More Tutorials

Create a Cube Calculation View (XS Advanced)

09/06/2018

Create a graphical calculation view with a cube data type.

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
Log on to answer question
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.

Log on to answer question
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
Log on to answer question
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
Log on to answer question
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.

Log on to answer question
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?
×

Next Steps

Back to top