TM1 Forum

Hi everyone

I have cube Expense, revenue and i input data from month 1 ,2,3,4,5,6. Now I want created one process copy data from month 1-> 6 to 7-> 12.

When i run process, all cube copy data. How do ??? I should create process or code TI.

Thanks you very much.

ChauBSD wrote: I have cube Expense, revenue and i input data from month 1 ,2,3,4,5,6. Now I want created one process copy data from month 1-> 6 to 7-> 12.

When i run process, all cube copy data. How do ???

Wow, that's a tough one. Have you made even the slightest attempt at all to figure out how to do it? Read any manuals, looked at any code examples, done any searches? I'm sure I read something about that somewhere. Can't quite recall where, but I think it was the same place I read this:

Request For Assistance Guidelines wrote: Also, please don't ask very basic questions about how to do things in TurboIntegrator or Rules without at least looking through the relevant functions in the Reference Guide.

A place which, I note, you have been pointed to previously on another occasion when you were charging clients for your extensive TM1 skills.

Thanks you,

I am never use code TI or processes. But i try look at it.

ChauBSD wrote:I am never use code TI or processes. But i try look at it.

Then I'd question how or why you're being paid for TM1 work with no training and exceedingly limited experience in the tool. There are training courses available.

That aside, though, have you thought that if the data set is small enough (say, up to anything up to a few tens of thousands of rows), you don't even need TI if this is a one off. You could just as easily:
1) create a view at N level with periods as your column dimension,
2) snapshot it, then
3) in the empty columns to the right add the next 6 months in as headings.
4) Below that you use DBSW formulas to re-upload the values from your snapshot into the corresponding months.

This presupposes that the next 6 months are currently unpopulated; if they are populated you would need to zero them out first.

That having been said, you should probably attempt to do it by TI anyway. It is not possible to be a competent administrator or consultant without knowing how TIs work and how to code one, especially for as simple a task as moving or copying data from place A to place B.