416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Standard Virtual Table

Hide navigation
RSS
Modified on Wed, 11 Apr 2012 10:45 AM Categorized as Virtual Tables
Click to return to: Documentation | Defining Virtual Tables


Overview

A standard virtual table can be based on a single data structure (⪚ a database table) or multiple data structures. In the case of multiple data structures, you must define proper relationships (&ie; joins) between them.

Creating a standard virtual table

To create a standard virtual table:

  1. In the first step of the Virtual Table Setup Wizard, select Standard Virtual Table, then click Next.
    The first step of the Virtual Table Setup Wizard.
  2. In the second step of the wizard, select a data connector from the grid, then click Next.
    Choosing a data connector in the Virtual Table Setup Wizard.
  3. In the third step of the wizard, choose one or more data structures to base your virtual table upon by clicking the appropriate check boxes in the Select column. You can choose physical database tables, views, and even previously created virtual tables.
    Choosing data structures in the Virtual Table Setup Wizard.
  4. Click Finish. The Virtual Table Designer is displayed in the content area of &dw;.
    The Virtual Table Designer.
  5. Configure general settings for your virtual table.
  6. If your virtual table is based on more than one data structure, you must define relationships between those data structures using the Data Sources tab. For example, you can specify that two input tables should be combined using an inner join on a specific column. For more details, see Defining Relationships.
  7. Use the Columns tab in the Virtual Table Designer to choose input columns for grouping, aggregation, or to be hidden in the final result. See Defining Columns for more details.
  8. Preview the corresponding SQL query and the resulting data by using the Preview tab in the Virtual Table Designer. You can also modify the SQL query from this tab if desired. For more details, see Previewing a Virtual Table.

Related topics


Click to return to: Documentation | Defining Virtual Tables

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.