InetSoft Product Information: Data Manipulation & Mash-Up

Style Intelligence provides sophisticated capabilities for data manipulation and mash-up through its easy-to-use graphical Data Worksheets. With Worksheets, administrators and power-users can rapidly combine information from different data sources into meaningful and reusable Data Blocks.

The following example shows how to construct, manipulate, and save a new Data Block. For information on how to create more complex assets, please refer to the Data Worksheet Guide.

Constructing Data Blocks

There are many different ways you can construct Data Blocks. In this example, you will build a Data Block by pulling together several attributes from a single data model.

  1. In a Windows environment, open the Asset Composer from the option on the Windows Start Menu, Start → All Programs → Style Intelligence → Asset Composer.
  2. Click on the ‘New WorkSheet’ button in the top toolbar to open a new data worksheet.
  3. In the left pane of the Asset Composer, expand ‘Query’, then the ‘Orders’ data source. Also expand ‘Order Model’ and ‘Order’.
#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index Read More

  1. 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 “Order,” the name of the parent entity from which the ‘Date’ field was drawn.
  2. Next, expand the ‘Product’ entity, and drag and drop the ‘Category’ attribute over the right side of the ‘Date’ column in the data worksheet. The table now includes both fields.
  3. Using the same procedure, add ‘Total’, from the ‘Product’ entity, to the data worksheet.
  4. Now, right-click the table title, and select ‘Properties’ from the context menu. This opens the ‘Table Properties’ dialog box.
  5. In the ‘Table Properties’ dialog box, rename the table by entering “MonthlySales” into ‘Name’ dialog box.
  6. Click ‘OK’ to close the dialog box. You have now created a “MonthlySales” data block that you can use in further data manipulations.
Previous: Virtual OLAP Models