Using an Excel Spreadsheet to Drive Dimensions

  1. Create Driving Dimension groups for dimensions you want to control
    In the Pull and Move tools, create Ruler Dimensions and add them to Groups to create Driving Dimension groups.
  2. Open the Excel tab.
  3. Click Create.
    The spreadsheet is created and automatically populated with groups
    Auto update is On by default. If you have several dimensions to change, turn it off so the model does not update until you have entered all the new values.
  4. Enter Target Values.
  5. Click Update to apply the new dimensions to your model.

As with all spreadsheet calculations, you should avoid circular calculations.

Values are applied sequentially, so order your groups in the sequence that you want to perform the operations.