Alternative Calendar Dimensions

You can load multiple calendar systems into One Model, allowing your users to cut metrics by fiscal year or other date groupings.



One Model supports the deployment of multiple time dimensions. This means that in addition to the "normal" or Gregorian calendar groupings, you can load in alternative time models. A common use case for this would be grouping data by fiscal years, quarters, or months rather than the regular civil calendar. Really, however, any system for grouping dates will work, as the example below will show. In that video I show how I have loaded in the Age, Year, and Month groupings from J.R.R. Tolkien's Middle Earth. Please do let me know if anyone asks you to group data using that particular system :)


Below the video you will find notes on recommended fields to include in your date mapping table. Be sure to check those out before creating your own time dimension. 

Was this article helpful?

0 out of 0 found this helpful



Please sign in to leave a comment.