TM1 Forum

Greetings all,

Could anyone kindly help please with this:

I have a cube containing accounting data, that I wish to pump into another cube. For example:

In Cube 1, the value £10 is located at the conjunction of Cost Centre "110" and Expense Code "225"
In Cube 2, the same value needs to be located at GL_Account "110225"

In a TI process, what would be the syntax for getting the value from the conjunction of the two dims in Cube 1 into the snigle dim in Cube 2?

All assitance greatly appreciated in advance.

Ian

Create a view of Cube 1 and make it the data source of your TI process.

In the below code for the Data tab vCC and vEC are names of two of your variables on the Variables tab, based on your two dimensions.
The pipe character "|" will concatenate two strings to create the required outcome.

To Kamil,

Utterly brilliant and much appreciated.

Thank you

Ian

You're probably right, the above is some of my best work to date.

qml wrote:You're probably right, the above is some of my best work to date.

Hi,qml,where did you execute the code "CellPutN (vValue, 'Cube 2', some_dims, vCC | vEC, some_more_dims);",and can you give some materials about it?
I'm a green hand on TM1,thanks anyway.

guoshock wrote:

qml wrote:You're probably right, the above is some of my best work to date.

Hi,qml,where did you execute the code "CellPutN (vValue, 'Cube 2', some_dims, vCC | vEC, some_more_dims);",

QML wrote:In the below code for the Data tab

(Emphasis added.)

guoshock wrote:and can you give some materials about it?

Searching for "CellPutN" in the documentation yields this topic.

Many thanks,qml,Emphasis and Alan Kirk.

I too would also like to take this opportunity to thank Emphasis for all the valuable contributions that he/she adds.

lotsaram wrote:I too would also like to take this opportunity to thank Emphasis for all the valuable contributions that he/she adds.

Unfortunately Emphasis is looking to retire soon.

We're working on a forum mod to replace her. It will involve shooting fireworks out of the screen while giant animated arrows point to the key words in each post. The mod will include an auto-eye-detection module so that as soon as the key words are read a medley of John Philip Sousa marches will blast out of the reader's speakers at full volume. If the reader doesn't have speakers, we'll just modulate the output of their monitor to cause it to vibrate so that it fakes the same effect.

When the reader clicks on the FAQ link to the online documentation, then either the Hallelujah chorus or Beethoven's Ode to Joy will play instead. (I haven't decided which yet, but I'm leaning toward the Die Hard version of the latter.)