Note: This is an old article. However, some tips may still apply to newer versions.
Edit a hierarchy and add this to the description:
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.
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.
I do not know the answer to your question, but I am sure that you can find the solution in Targit's knowledgebase.