---
parser: v2
auto_validation: true
primary_tag: products>sap-hana-dynamic-tiering
tags: [ tutorial>beginner, products>sap-hana, products>sap-hana-dynamic-tiering, products>sap-hana-studio, topic>big-data, topic>sql ]
time: 15
slug: dt-data-modelling-part6
canonical_url: https://developers.sap.com/tutorials/dt-data-modelling-part6
---

# Seeing Calculation View Results
<!-- description --> Generating select statements for results and visualization

## Prerequisites
 - **Tutorials**: "Adding Our Union Calculation View into the Converted Data Model" and "Migrate Records in Related Tables Using Stored Procedure"

## You will learn
  - How to generate a `SQL` Select Statement for a Calculation View
  - How to Visualize Queries

 ---
### Seeing Results

We will now generate a `SQL` select statement for our `AV_ORDERS` calculation view. It will be editted to query all rows between 6 months and 18 months ago. Since `ORDERS_CS` contains all data from the current year and `ORDERS_DT` contains all data older than a year, the result set will span both the in-memory table instance and the extended table instance.

We will then visualize the plan, and show again that data is being queried from both in-memory and extended storage.

Before we begin, open a SQL console, and run our `Migrate_Aged_Orders()` function created from our previous tutorial, [Migrate Records in Related Tables Using Stored Procedure](https://developers.sap.com/tutorials/dt-create-schema-load-data-part6.html). This will ensure that all data older than one year is moved from `ORDERS_CS` into `ORDERS_DT`.

Click execute, to run the statement.

![Call Migrate_Aged_Orders()](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-data-modelling-part6/call-migrate.png)

```sql
CALL "TPCH"."Migrate_Aged_Orders"();
```

Now, right click on the calculation view `AV_ORDERS` and click **Generate Select SQL**.

![Generate Select SQL](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-data-modelling-part6/generate-select-sql.png)

The result:

![Result of select sql](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-data-modelling-part6/sql-statement.png)

We will add a `WHERE` statement, so the query only returns results between 6 to 18 months ago. This is done to ensure that it is collecting data from both `ORDERS_CS` and `ORDERS_DT`. Add the following between the `FROM` and `GROUP BY` lines:

![Where statement](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-data-modelling-part6/where-statement.PNG)

```sql
WHERE "O_ORDERDATE"
	BETWEEN ADD_YEARS(CURRENT_DATE, -1.5)
		AND ADD_YEARS(CURRENT_DATE, -0.5)
```

Click execute.

![Execute](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-data-modelling-part6/execute-where.png)

The results should look like the following image:

![Where Results](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-data-modelling-part6/where-results.png)


### Visualizing Queries

We can also visualize the query, by going back to the `SQL` tab, right clicking, and selecting **Visualize Plan** > **Execute**.

![Visualize Plan](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-data-modelling-part6/visualize-plan-execute.png)

After it executes, navigate to the **Executed Plan** tab.

![Executed Plan](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-data-modelling-part6/executed-plan.png)

On the bottom panel, navigate to the **Operator List** tab, and search for the operator name **ES**.

![Operator List](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-data-modelling-part6/operator-list.png)

Double click one of the results, and it will zoom into the selected operator. As you can see by the **Remote Row Scan** box, the query accessed the extended table.

![Remote Row Scan](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/dt-data-modelling-part6/extended-storage.png)