Daniel Kutac · Aug 3, 2017

DeepSee time series - season


I have a series of data organized by time (year and month) so I can use a time dimension to drill down data. So far so good.

However, I need to display the data not by calendar years and months but rather by seasons. The season has 12 calendar months but starts in September. So I'd like to see the data from September / Year N to August / Year N+1 using the same hierarchy as normal time dimension.

Has anyone done something similar?

Obviously, the season can start by any month, not only September :)



0 227
Discussion (3)1
Log in or sign up to continue

You can add your own DeepSee dimension levels by extending  %DeepSee.Time.AbstractLevel class. Check  %DeepSee.Time.Year class for an example of Year level within a time dimension.

List of available time level classes is obtained in %DeepSee.Utils:%GetTimeLevelClasses and is used during cube generation.

Thanks Alexander,

this seems promising. It works well for Year / MonthYear hierarchy, not working for Year/MonthNumber which I was using. My original hierarchy levels setup allowed me for easy year to year comparison of values for a given month.