Follow

How to set up the time dimension for dynamic time in Targit

Edit a hierarchy and add this to the description: 

 #|TimeDef:[<>].&[<>].&[<>].[<>]|#

 

targittime.png

 

The following things is required for the above example to be correct - If you setup is different, the TimeDef should be changed accordingly:

  • The dimension must have the dimension type "Time" set
  • The Day attribute should be created with:
    • Type set to Days
    • Key Column = DateValue
    • Name Column = DayOfMonth
  • The Month Attribute:
    • Type set to Months
    • Key Column = MonthNumber
  • The Quarter Attribute:
    • Type set to Quarters
    • Key Column = QuarterNumber
  • The Year Attribute
    • Type set to Years
    • Key and Name Column set to YearValue

This article applies to: timeXtender 4.5, tX2012, TX2014. Last updated: 2014-04-01.

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    Francois Cormier

    This works great for time periods that are "Calendar" time periods.  How do we adjust this for fiscal years with a different start date, i.e. September 1 to August 31 of following year?  (Playing with the #|Timedef:....,Offset:-8|# or even #|Timedef:......,Offset:4|# offers only a partial solution.

  • 0
    Avatar
    Thomas Lørup Duun

    Hi Francois,

    I do not know the answer to your question, but I am sure that you can find the solution in Targit's knowledgebase.

Please sign in to leave a comment.