Create a Time Dimension Using the Date Wizard

You can use the Date Wizard to speed up creation of a time dimension for your model. Whether your time dimension contains standard calendar or lunar time periods, down to the Month, Week, or Day level, this wizard prompts you for the information required in a logical sequence.

Later, if you decide to change the information, you can do so manually.

Procedure

  1. From the Tools menu, click Date Wizard.
  2. Type a name for the new time dimension and click Next.
  3. Choose the source column that contains the date values for the new dimension and click Next.
  4. Respond to the remaining prompts.

    You can click Back to return and change your response to a previous prompt.

  5. When you have defined the levels in the time dimension, click Finish.