MDX dynamic year in filter

13 views Asked by At

I have the following simple MDX fetching quantity from my data cube:

SELECT NON EMPTY
{  
  [Measures].[QTY]
} ON COLUMNS FROM
(
  SELECT
  (
    [DATE].[YEAR].&[2022] : null 
  ) ON COLUMNS FROM [MY_DATA_CUBE]
)

As you can see the lower limit range for DATE.YEAR dimension is here hard coded (2022). There's no upper limit (null) so this is like DATE.YEAR >= 2022.

I'd like to have MDX with dynamic value (current year - 2). How to do this?

0

There are 0 answers