A Datamart stores time dimensions (week, month, quarter and year) for the pricing dates. To get a time dimension value, a DMCalendar instance (Datamart Calendar) can be used.
For example, the date "2018-01-24" falls in the week "2018-W04"; which can be retrieved by the getWeek(date)
method of a DMCalendar instance:
def date = api.parseDate("yyyy-MM-dd", "2018-01-24") def week = api.getDatamartContext().calendar().getWeek(date) return week |
Similarly, other time dimensions such as Month, Quarter and Year can be retrieved by getMonth(date)
, getQuarter(date)
and getYear(date)
methods respectively.
These functions ( |