none
Time Dimension - Expanding Time Table Dates

    Question

  • Hi all!

    I have an Analysis Services project with a Time table that was created through the wizard.

    (Generate a table in the data source option)

    The date range used was too small, is there a method to add more dates into the table? Hoping I won't have to recreate the dimension again from scratch.

    thanks in advance!

    Thursday, May 15, 2014 9:04 PM

Answers

  • Hi Good,

    In case you want to expand the already existing Time Dimension, below are two ways of doing so :

    Sol 1:

    • Remember when you create Time Dim using wizard (Generate table in DS), analysis service creates a Time table in underlying database. You can always go and add additional time range into this table and process update the existing Time Dim.

    Sol 2:

    • One more tactical way would be to create a new Time dimension using wizard with expanded time range.
    • Now there would be 2 Time tables in underlying database, delete the old table and rename the new table to name same as old.
    • Delete the newly created Time dimension
    • Process Update the old Time Dimension.

    Saurabh Kamath

    • Proposed as answer by Piotr Palka Tuesday, May 20, 2014 5:19 AM
    • Marked as answer by D_Good Wednesday, May 21, 2014 9:43 PM
    Tuesday, May 20, 2014 3:52 AM

All replies

  • Hi D_Good,

    According to your description, you create a time table using "Generate a table in the data source option", and the issue is that the date range was to small, right?

    When creating a table table using "Generate a table in the data source option",  we can specify the time periods, and also the start and end dates for the dimension.

    So in your scenario, you can specify the first calendar day earlier to expand the time table dates.

    Reference.
    http://technet.microsoft.com/en-us/library/ms174832.aspx

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here


    Charlie Liao
    TechNet Community Support

    Friday, May 16, 2014 3:25 AM
  • Hi Good,

    In case you want to expand the already existing Time Dimension, below are two ways of doing so :

    Sol 1:

    • Remember when you create Time Dim using wizard (Generate table in DS), analysis service creates a Time table in underlying database. You can always go and add additional time range into this table and process update the existing Time Dim.

    Sol 2:

    • One more tactical way would be to create a new Time dimension using wizard with expanded time range.
    • Now there would be 2 Time tables in underlying database, delete the old table and rename the new table to name same as old.
    • Delete the newly created Time dimension
    • Process Update the old Time Dimension.

    Saurabh Kamath

    • Proposed as answer by Piotr Palka Tuesday, May 20, 2014 5:19 AM
    • Marked as answer by D_Good Wednesday, May 21, 2014 9:43 PM
    Tuesday, May 20, 2014 3:52 AM
  • Great Saurabh, solution 2 looks to be exactly what I was looking for.

    Thanks so much!


    • Edited by D_Good Wednesday, May 21, 2014 9:45 PM
    Wednesday, May 21, 2014 9:44 PM