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.
Create process copy data first 6 month
-
- 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
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: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 ???
A place which, I note, you have been pointed to previously on another occasion when you were charging clients for your extensive TM1 skills.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.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
Thanks you,
I am never use code TI or processes. But i try look at it.
I am never use code TI or processes. But i try look at it.
-
- 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
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.ChauBSD wrote:I am never use code TI or processes. But i try look at it.
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.