Duplicate a dimension table

Simplify the creation process by duplicating an existing dimension table and modifying it.

  1. Click the Designers tab.
  2. Expand Dimension Tables.
  3. Right-click the dimension table, then select Duplicate
  4. Select one of the following:
    Copy the Dimension Table

    The new dimension table will be identical to the original dimension table but will not inherit the original references forward.

    Add a copy after

    The new dimension table will depend on the original dimension table.

    Insert a copy before

    The original dimension table will depend on the new copy of the dimension table.

  5. Select a system from the Target system drop-down field.
  6. Click OK.