In many reports I need to consider date intervals. for example beginning is
2012-11 and end is 2015-03
Calendar is
- All Years
- Year
- Quar.
- Month
So a macro calculates all needed Elements:
- 2011-11, 2011-12, 2012, 2013, 2014, 2015-Q1
This is quite circuitous. having an input form that calculates these interval for date dimensions (depends on the definition)
- Years
- Quart.
- Weeks or Months
- Days
would make work with jedox much easiert!