I have an OLAP multi dimensional cube, which in its simplest form contains:
- A fact table with a NetAmount measure
- A Time dimension, with fields for Year, Month, Day, Day of Month, Day of Year, etc
The requirement is that the user wants to be able to compare the total NetAmount from the beginning of each year up to a specific date. The date can be chosen by setting filters on the Day and Month fields. For example, the user wants to see total value for:
- 01 Jan 2019 to 20 Jan 2019
- 01 Jan 2018 to 20 Jan 2018
- 01 Jan 2017 to 20 Jan 2017
What would be the best way to tackle this requirement?