moving data from any cube to any cube by TI process

[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.

[Emixam]

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

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.

[lotsaram]

You do know that such a process already exists?

Why not implement the library as a standard and spare yourself the work?

[Emixam]

I didn't know !

Kudos to the guy who built that process !

Thanks Lotsaram !

[habibullah.sayyed]

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

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.

[habibullah.sayyed]

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?

[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.

[Wim Gielis]

I 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.

[habibullah.sayyed]

I 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.

[Wim Gielis]

Thank you so much for your time and your reply, cant refrain it because my manager told me to do this.

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.