---
parser: v2
primary_tag: products>sap-hana
author_name: Thomas Jung
author_profile: https://github.com/jung-thomas
auto_validation: true
tags: [  tutorial>intermediate, topic>sql, products>sap-hana, products>sap-hana\,-express-edition   ]
time: 15
slug: xsa-graphical-cube-view
canonical_url: https://developers.sap.com/tutorials/xsa-graphical-cube-view
---
# Create a Cube Calculation View (XS Advanced)
<!-- description --> Create a graphical calculation view with a cube data type.

## Prerequisites  
- This tutorial is designed for SAP HANA on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud.
- **Tutorials:** [Create a calculation view of data type Dimension](https://developers.sap.com/tutorials/xsa-graphical-view.html)


## 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

---

### Create a new Calculation view of type Cube


Create a new calculation view in your models folder.

![Create calculation view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/1.png)

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

![Call it PO](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/2.png)



### Join header and items


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

![New Join node](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/join.gif)

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

![Call it PO](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/3.png)

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

![Call it PO](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/4.png)

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

![Mapping](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/5.png)

Finally, rename the node to `PO`.


### 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](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/star2.gif)

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

![Mapping](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/6.png)


### Create an input parameter


In the Parameters tab of the Star Join Node, create an input parameter named `IP_O_TARGET_CURRENCY`.

![Mapping](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/7.png)

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

![Mapping](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/8.png)



### 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](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/9.png)

Change the name of the duplicate column to `OriginalGrossAmount`.

![Mapping](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/10.png)

Click the semantics node.  Change the Type of the `PURCHASEORDERID` to be an Attribute.

![Attribute](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/10-1.png)

Assign semantics for `GROSSAMOUNT`.

![Assign Semantics](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/11.png)

Choose **Amount with Currency Code** and configure as follows:

- Display Currency: column, choose `GROSSAMOUNT_CURRENCY`
- Check the `Conversion` and `Decimal shift` boxes

![Mapping](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/12.png)

Click on the `definition` tab and use the following configuration

![Mapping](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/13.png)

**Save** the view.



### Build and preview


Build the `db` module and return to the database explorer

![Mapping](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/15.png)

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

![Final view](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-graphical-cube-view/16.png)




---