Create an include index

  1. On the DWD Designer, click Designers tab.
  2. On the left pane, right-click Dimension Tables, then select the Default Datamart for DWD.
  3. Right click on the dimension table you want to use and select Detailed Properties > Indexes.
  4. Select the columns you want to include from the Available Columns section and click OK.
  5. Recompile the dimension table. Right-click the dimension table, then select Compile.
    Note: 

    You must recompile the dimension table so the include index will be created on the database.