Adding Our Union Calculation View into the Converted Data Model
- How to add extended tables to an existing information model
- Tutorials: “Creating a Calculation View from the Union of In-Memory and Extended Tables”
- Step 1
We have converted the original information into all calculation views so that they can support other calculation views. We then created a new calculation view which was a union between hot and warm data. Now we will replace
ORDERS_CSwith the new calculation view inside of
tutorial_All_Calcpackage, open up
AV_ORDERSin the graphical viewer. Under Projection, right click
ORDERS_CSand click Remove.
Note: You may need to expand Projection by clicking the
+button beside its name.
You will receive a warning that column references will get removed because of this action. Click Yes and OK to confirm.
Similar to the previous tutorial, we will drag
CA_UNIONview over from the Systems panel, and drop it into the Projection node.
Afterwards, select the Projection node to edit its details in the Details panel. Click the gray dots for
O_ORDERDATE. This will add them to the output and the color of the dots will change to orange to indicate that they are now included in the output.
Now, select the Star Join node to edit it. Toggle all the gray circles to become orange, except for the
O_CUSTKEYfrom Projection. Then, connect
C_CUSTKEY. This is done by clicking anywhere on one row, and dragging your cursor to another row.
You may see a warning sign above the Projection node. If it reads “No columns added to the output” when you have already done so (denoted by the orange dots), you may ignore this warning.
Next, we will select the Semantics, to ensure each column is set as the right type. Toggle the type so that
ORDERSTATUSare attributes (denoted by a blue diamond), and
O_TOTALPRICEis a measure (denoted by an orange bar) with a “Sum” aggregation.
Which of the following is true?
- Step 2
tutorial_All_Calcin Systems. Under
tutorial_All_Calc> Calculation Views, right click
AV_ORDERSand click Activate.
We have successfully added extended tables to an existing information model! In summary, we took the old
AV_ORDERSused the in-memory table called
ORDERS_CS, and combined it with
AT_REGIONto create a result set showing each customer key with its corresponding region name, order status, order data, and total price from the last year. This new
AV_ORDERSview combines the new
CA_UNIONview (which is a union of
AT_REGION, creating a result with the same fields as before, but now includes data from all years, including the data that has been aged out to the extended table in Dynamic Tiering.