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:
The rule behind the calculation is written as such:
And the attributes of the time dimension Months are:
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 Sales@LodestarSolutions.com.
Have you joined our community yet? If not, go to Lodestarsolutions.com 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!