Getting 12 months from any given time

Post Reply
Posts: 16
Joined: Wed Sep 02, 2020 3:08 pm
OLAP Product: tm1
Version: 11.3. 0.
Excel Version: 16

Getting 12 months from any given time

Post by samiamsz » Wed Jan 13, 2021 3:16 pm

I have to write a process that basically gets a month from a user and copies data into a new book from that date and twelve months onward.

Im using a cellgets to get the month I need, But in the cellputN for the period, Im not sure how to do it.

Im assuming i need a variable that takes the user entered Month and adds the next 11 moths to it, But im not sure how to do this. I have worked on rolling months but it wouldnt work here

User avatar
Regular Participant
Posts: 171
Joined: Wed May 14, 2008 8:27 am
OLAP Product: TM1
Version: 10.2.0, PA 2.0.9
Excel Version: 2016
Location: London

Re: Getting 12 months from any given time

Post by Ajay » Wed Jan 13, 2021 5:41 pm

1) Are you wanting the 12th month ? if so why don't you use an attribute on the elements which has the 12th month in it ?


2) Are you wanting the all the 12 months ? If so why not have a consolidation of the months which you can reference in an attribute from the selected first month ?


Post Reply