Run the fact table wizard

After you create a fact table, run the fact table wizard to verify dimensions and relations and categorize measures.

  1. Click the Designers tab.
  2. Expand Fact Tables.
  3. Right-click the fact table you created, then select Fact Table Wizard.
  4. On the Fact Table Wizard window, ensure the following are checked:

    • Verify dimensions and relations

    • Catagorize measures

    Click Next.

  5. On the Add or remove keys or relations window, click Next.
  6. Select the columns for measures. Click Finish.