Creating a Spotfire Information Model for Central Logger

Procedure

  1. Within TIBCO Spotfire Professional, open the Information Designer from the menu bar as: Tools - > Information Designer.
  2. Select the Elements tab.
  3. Create a new directory as follows:
    • Click New - > Folder
    • Enter the name of the new folder. For example, ASGTEST.
  4. Select the Data Sources tab. In the left panel of the Information Designer dialog, expand the data source name by clicking on the + sign. Expand the asguser schema.
  5. Verify that following database tables are listed from the Central Logger database schema:
    • ASG_KPI
    • ASG_LOG_MESSAGES
    • ASG_THROTTLE_MESSAGES
    • ASG_THROTTLE_USAGE
    • ASG_TRANSACTION_DETAILS
    • ASG_TRANSACTION_KEYS
    • ASG_TRANSACTION_MESSAGES
    • ASG_TRANSACTIONS
  6. Press Shift and click on the first table and the last table to select all tables. With all the tables selected, right-click on your mouse and select the option Create default Information Model link from the context menu.
  7. On the next window, select Destination folder from the Library as ASGTEST.
  8. Click OK on the next new dialog window.
  9. On the Create Default Information Model Settings window, ensure that the radio button Automatically assign a new name to the created item is selected. Click OK.
  10. Verify that the Information Links has been created for each table of the Central Logger database, which appears in the left pane of the Information Designer window on the Elements tab.
  11. In the Information Designer window, follow these steps to create the join between the ASG_TRANSACTIONS and ASG_TRANSACTION_KEYS tables:
    1. Click New and select Join from the drop-down list.
    2. From the database schema, expand the ASG_TRANSACTIONS table. Select TRN_GUID and click Add on the right side of the Information Designer window.
    3. From the database schema, expand the ASG_TRANSACTION_KEYS table. Select KEY_TRN_GUID and click Add on the right side of the Information Designer window.
    4. Click Save to save changes.
    5. On the next window, select Destination folder from the Library as ASGTEST. Verify that this creates ASG_TRANSACTIONS - ASG_TRANSACTION_KEYS Inner Join join under ASGTEST folder.
  12. In the Information Designer window, follow these steps:
    1. Go to Elements tab and select ASGTEST folder.
    2. Click New and select Information Link from the drop-down list.
    3. Select the ASG_TRANSACTIONS data model folder. Add TRN_GUID and TRN_STATUS columns.
    4. Select the ASG_TRANSACTION_KEYS data model folder. Add KEY_TRN_GUID, KEY_TYPE, KEY_VALUE columns.
    5. Expand the Join Path tab. Add the ASG_TRANSACTIONS - ASG_TRANSACTION_KEYS Inner Join join.
    6. Save the Information link as Transaction-Transaction Keys.
  13. Click Close to close the Information Designer.