TM1 Period to Date Dimensions

As Business Analytics coaches for Lodestar Solutions, we come across questions that are asked of us by our clients. A common question is about TM1 period to date dimensions. There are many times when  data needs to be seen on a Period to Date basis, such as quarter-to-date and year-to-date.  Creating additional rollups in your time dimension can be cumbersome.  An easy way to tackle this is to have a Period to Date dimension in your cube.  I usually call this dimension MQY or XTD if I have more than Month, Quarter and Year calculations.

Period to Date in a TM1 cube:

TM1 Period to Date
Period to date dimensions

The rule behind the calculation is written as such:


And the attributes of the time dimension Months are:

TM1 Period to Date
Period to date dimensions 2

Please do not hesitate to contact Lodestar Solutions for more information about this topic or any others. Our goal is your be Business Analytic coaches and to provide solutions where our clients said there were none. Email us at

Have you joined our community yet?  If not, go to and join!  It is super easy and takes less than 1 minute.  By joining you will have access to our events and the latest information!  Join today!

Leave a Comment

Send this to a friend