TM1 Forum

Hi Guys,

I currently have a subset in my year dimension titled Current Year. However this subset is manually set to 2009. Is there away that I can do a MDX expression that makes the subset set to the current year dynamically.

I have looked some online articles relating to TM1 MDX, but I am unable to find a function similar to Now()? I believe that there is a year function, but you have to pass it a date, therefore I just need to find a way to pass it the current date.

Any help would be appreciated.

Static subsets work fine for this purpose and are commonly used, ... don't forget you have TI in your arsenal!

All that is needed is to have a date dimension in yyyy-mm-dd format (or alias in this format), possibly also with attributes for current week, last week, next week, current month, last month, next month, current year, ... and run a TI nightly to set all your time based reporting subsets.

Yes, I may just create a parameters cube and stick the current year in there. I just wasn't sure if this could be done via MDX expression. Thanks for you help.

There is a TODAY() function in TI. If you set up a chore that runs daily, or on the first of the month or whatever, this chore could destroy and rebuild a static subset using the TODAY function to work out the appropriate information.

Martin