Create process copy data first 6 month

Post Reply
ChauBSD
Posts: 55
Joined: Wed Jun 27, 2012 3:22 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Contact:

Create process copy data first 6 month

Post by ChauBSD »

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.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Create process copy data first 6 month

Post by Alan Kirk »

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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
ChauBSD
Posts: 55
Joined: Wed Jun 27, 2012 3:22 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Contact:

Re: Create process copy data first 6 month

Post by ChauBSD »

Thanks you,

I am never use code TI or processes. But i try look at it.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Create process copy data first 6 month

Post by Alan Kirk »

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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply