5.1 Constructing Data Blocks
There are many different ways to construct Data Blocks. In this example, you will build a Data Block by assembling several attributes from a single data model.

1. Click the 'New' button in the toolbar. This opens the 'New Asset' dialog box.
2. In the left panel, select 'Worksheet' and Click 'OK'.

This creates a blank Data Worksheet.
3. In the Data panel, expand the following tree nodes: 'Query' > 'Orders' > 'Order Model' > 'Order'. This displays the attributes within the 'Order' entity of the data model.
4. Select and drag the 'Date' field from the tree to an empty cell on the Data Worksheet grid. This creates a new table with the title “Order1”.

5. Next, expand the 'Product' entity, and drag the 'Category' attribute over the 'Date' column header.

When you see the green line on the right side of the header, drop the entity into the table. The table now includes both fields.

6. Using the same procedure, add 'Product' > 'Total' to the table.

7. Now, right-click the table title, and select 'Properties' from the context menu. This opens the 'Table Properties' dialog box.
8. In the 'Table Properties' dialog box, rename the table by typing “MonthlySales” into 'Name' field.

9. Click 'OK' to close the dialog box.
10. In the title bar of the “MonthlySales” Data Block, click the 'Live Data' button. Drag the bottom border of the Data Block down to see the actual data.

You can use this new Data Block in further data manipulations (e.g., joins, concatenations), or as a data source to reports and Viewsheets. For more information on creating Data Blocks, see Creating a Data Table in Data Mashup.
| << 5 Data Manipulation & Mash-up | © 1996-2013 InetSoft Technology Corporation (v11.4) | 5.2 Manipulating Data Blocks >> |