Joining Lookup Tables

There may be instances when a Stage Table designated as a Source table does not provide enough supporting detail within the table. Lookup tables are existing client tables that can be joined to a Source or Destination table to extend the contents of that stage table, providing additional information or data.

A table can be joined to a stage table if it uses the same list of measures, same measure dimension, as the stage table. For example, a table can be a Source Lookup Table if one or more columns are mapped to a member value from the Source Measure Dimension.

Each lookup table adds to the calculation and processing times for the selected stage table. The more lookup tables that are involved in the calculation, the greater the processing time. Not all lookup tables need to be involved in a calculation. For example, you may have 10 tables joined to the stage table, but if a driver is using only three of these tables, the processing impact involves those three tables only.