Time Intelligence - Trading Calendar injection
i am looking for a way to let the Time intelligence function use my customer's trading calendar instead of the Gregorian Calendar.
4 replies
-
I have a feature request on this https://community.pyramidanalytics.com/t/p8y1xfx/configurable-default-week-1-start-system-level-option
I understand there are some technical issues but agree this is a useful feature -
I have voted, Thanks Darren
-
Hi
We'll take a look at your suggestion, but realistically, the number of possible permutations and definitions of custom calendars makes this a very difficult proposition. I can guarantee that even if we add this so that your needs are accommodated, it won't be sufficient for someone else and we're into a never ending development process and the options become very complicated and confusing.
Pretty much all financial reporting systems include a calendar table where the year / week / quarter groupings etc. are all defined once, and that table joined to the Facts to produce a Calendar Dimension.
If your underlying database for your Direct Query Model lacks this calendar table, you can create one by adding a custom query to the DQ model to generate the Calendar Table dynamically. It's a bit of work to set it up, but once done, can be reused wherever you need it.
Hope that helps.
Ian