Data Sources and Measure Columns

You can work with data sources that either include or don't include a measure column.

• You can match tables with measures to other tables with a measure, a dimension, or both.

• When you match tables to other tables with measures, the tables don’t need to be at the same grain. For example, you can match a table of daily sales table to a sales by quarter table.

A table with no measures is treated as a dimension.

• Matches can be between single or composite columns. A single column match might be the product key in one table matching the product key in another. A composite column match might be where company and business unit in one table matches company and business unit in the other table.

• All other columns must be attributes.

Dimension tables can be matched to other dimensions or they can be matched to tables with measures. For example, a table with Customer attributes can be matched to a table with demographic attributes provided both dimensions have unique Customer key columns and Demographic key columns.