Page 1 of 1
moving data from any cube to any cube by TI process
Posted: Mon Jul 29, 2019 12:44 pm
by habibullah.sayyed
Hello everyone,
I am new to tm1 and i want to write advance TI (a generic process), 'the data should move from a any Cube to any Cube by TI process', for more understanding read following conditions:
1) No dimension name are allowed to mention in script and when we mention source and target cube while processing, it should get mapped when we run the process.
If question is not understood please ask.
And I want to solve it today itself.
Thanks in advance.
Re: moving data from any cube to any cube by TI process
Posted: Mon Jul 29, 2019 1:02 pm
by Emixam
habibullah.sayyed wrote: ↑Mon Jul 29, 2019 12:44 pm
Hello everyone,
I am new to tm1 and i want to write advance TI (a generic process)
You must learn to walk before you can run. TM1 is a powerful tool but you must master basic skills before you are able to learn more complex things.
You should take a look at this white paper.
https://static1.squarespace.com/static/ ... grator.pdf
habibullah.sayyed wrote: ↑Mon Jul 29, 2019 12:44 pm
1) No dimension name are allowed to mention in script and when we mention source and target cube while processing, it should get mapped when we run the process.
Good luck with that. However, I suggest you to take a look at the TABDIM function.
https://www.ibm.com/support/knowledgece ... abdim.html
Code: Select all
sDim1 = TABDIM(sCube,1);
sDim2 = TABDIM(sCube,2);
...
Good luck.
Re: moving data from any cube to any cube by TI process
Posted: Mon Jul 29, 2019 4:08 pm
by lotsaram
You do know that such a process
already exists?
Why not implement the library as a standard and spare yourself the work?
Re: moving data from any cube to any cube by TI process
Posted: Mon Jul 29, 2019 7:46 pm
by Emixam
I didn't know !
Kudos to the guy who built that process !
Thanks Lotsaram !
Re: moving data from any cube to any cube by TI process
Posted: Tue Jul 30, 2019 6:11 am
by habibullah.sayyed
Emixam wrote: ↑Mon Jul 29, 2019 1:02 pm
habibullah.sayyed wrote: ↑Mon Jul 29, 2019 12:44 pm
Hello everyone,
I am new to tm1 and i want to write advance TI (a generic process)
You must learn to walk before you can run. TM1 is a powerful tool but you must master basic skills before you are able to learn more complex things.
You should take a look at this white paper.
https://static1.squarespace.com/static/ ... grator.pdf
habibullah.sayyed wrote: ↑Mon Jul 29, 2019 12:44 pm
1) No dimension name are allowed to mention in script and when we mention source and target cube while processing, it should get mapped when we run the process.
Good luck with that. However, I suggest you to take a look at the TABDIM function.
https://www.ibm.com/support/knowledgece ... abdim.html
Code: Select all
sDim1 = TABDIM(sCube,1);
sDim2 = TABDIM(sCube,2);
...
Good luck.
Thanks a lot for your time and reply.
Re: moving data from any cube to any cube by TI process
Posted: Tue Jul 30, 2019 6:12 am
by habibullah.sayyed
lotsaram wrote: ↑Mon Jul 29, 2019 4:08 pm
You do know that such a process
already exists?
Why not implement the library as a standard and spare yourself the work?
Thank you so much, how can i get access to that library?
Re: moving data from any cube to any cube by TI process
Posted: Tue Jul 30, 2019 7:14 am
by Wim Gielis
Did you check the link and the library at github ?
Go to the main page of the library and there you can download the processes as a zip file.
Re: moving data from any cube to any cube by TI process
Posted: Tue Jul 30, 2019 7:19 am
by Wim Gielis
habibullah.sayyed wrote: ↑Mon Jul 29, 2019 12:44 pmI am new to tm1 and i want to write advance TI (a generic process),
Do yourself a favor and refrain from doing this exercise. There is plenty of stuff you can do in TI that is less advanced and still a challenge.
For example, write a TI process that can lookup an element name in any dimension of a TM1 model, be it as an element or as an alias. Bonus: wildcards ? and * are allowed in the element name (pElement).
The output is a CSV file with, record by record, the hits. Each time: dimension name, element index, element name, all aliases.
Re: moving data from any cube to any cube by TI process
Posted: Tue Jul 30, 2019 10:31 am
by habibullah.sayyed
Wim Gielis wrote: ↑Tue Jul 30, 2019 7:19 am
habibullah.sayyed wrote: ↑Mon Jul 29, 2019 12:44 pmI am new to tm1 and i want to write advance TI (a generic process),
Do yourself a favor and refrain from doing this exercise. There is plenty of stuff you can do in TI that is less advanced and still a challenge.
For example, write a TI process that can lookup an element name in any dimension of a TM1 model, be it as an element or as an alias. Bonus: wildcards ? and * are allowed in the element name (pElement).
The output is a CSV file with, record by record, the hits. Each time: dimension name, element index, element name, all aliases.
Thank you so much for your time and your reply, cant refrain it because my manager told me to do this.
Re: moving data from any cube to any cube by TI process
Posted: Tue Jul 30, 2019 11:04 am
by Wim Gielis
Then your manager does not know what he or she is talking about, if he or she asks this kind of task to someone who is new in TM1.