Exercise: Add Date Table to MDW

In TimeXtender you use date tables, stored in the data warehouse, as the basis for your time dimensions. For more detailed information, please see Date Tables.

Steps:

  1. Right click the Tables node in the MDW Data Warehouse and select Add Date Table
  2. Type Date in the Name box
  3. Change the year of the Start date to 2011 and click OK
  4. Move the Date table to the top of the tables list
  5. Deploy and Execute the Date table