Hello,
I have built a report using a Cube (and not a relational database).
I have a date as a parameter and I would like to filter its content: the parameter goes from 1900 to 2090 and I would like the user to see only from 2006 to 2090.
Can you help me by giving me tricks to do it ? There may have several ways of doing it but I can't find them.
Thank you in advance !
Alexis
If you always want it to start from 2006( not change to 2007 to 2090 when it is 2008) it′s easy in MDX:SELECT {[Time].[Year].&[2006] : NULL } on rows, bla bla bla.
This will make it take every member from the time dimension from 2006 up til the end, in your case 2090.|||
Thank you, it works perfectly !
It would be interesting to make dynamic date range according to the actual year but.... next time !