Adding Tables to the Data window

  1. Select a data source on the Data menu and then select Edit Tables.

  2. In the Tables dialog box, click Add New Table.
  3. In the Add Tables dialog box, select a table to add. Complete the dialog box by defining at least one join clause and optionally changing field aliases.
  4. When finished, click OK and then OK again to close the dialog boxes.
When you connect to multiple tables you are essentially connecting to a denormalized view of the data source. This means that all queries are run against all tables and it is possible for some measures to be over counted. For example, suppose you have an employees table and an orders table. However you keep the employee salary measure in the orders table. The salary will be counted for each order the employee made. Use the MIN aggregation to remove the double counting.

No comments:

Post a Comment