TM1 Forum

Posted: **Thu Sep 19, 2024 5:13 pm**

Hi,

I have 10 cubes, each with a common dimension but varying in the number of dimensions from 4 to 12. When a new element is added to the common dimension, I want to assign a value of 1 to a specific measure element (which is available in all the measure dimensions). Is there a function (no rule, and want to write via TI process) to assign the value 1 for the new element across the intersection of cube cells at once?

Posted: **Thu Sep 19, 2024 5:17 pm**

syd wrote: ↑Thu Sep 19, 2024 5:13 pm Hi,

I have 10 cubes, each with a common dimension but varying in the number of dimensions from 4 to 12. When a new element is added to the common dimension, I want to assign a value of 1 to a specific measure element (which is available in all the measure dimensions). Is there a function (no rule, and want to write via TI process) to assign the value 1 for the new element across the intersection of cube cells at once?

What is stopping you from having multiple CELLPUTN formulas in the same process? It's just a single line of code. That's how I would do it.

Posted: **Thu Sep 19, 2024 5:20 pm**

Each dimension has thousands of elements. Basically, I want to use the measured element as a feeder and avoid conditional feeders (sometimes over and under-feedings).

Posted: **Fri Sep 20, 2024 4:02 pm**

Hi,

I assume the issue here is the time it takes to populate the flag feeder with a 1 and this isn't something that can be run 'out of hours'?

You could try using RunProcess or TM1RUNTI to run things in parallel, at least for the bigger cubes?

Maren

TM1 Forum

CellPutN across the intersection of cube cells at once

CellPutN across the intersection of cube cells at once

Re: CellPutN across the intersection of cube cells at once

Re: CellPutN across the intersection of cube cells at once

Re: CellPutN across the intersection of cube cells at once