CellPutN across the intersection of cube cells at once

Post Reply
syd
Posts: 22
Joined: Tue Jan 21, 2014 2:03 am
OLAP Product: PA/TM1, CX
Version: PA 2.0
Excel Version: MSO 365

CellPutN across the intersection of cube cells at once

Post by syd »

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?
Thank you,
syd
tomok
MVP
Posts: 2835
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: CellPutN across the intersection of cube cells at once

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
syd
Posts: 22
Joined: Tue Jan 21, 2014 2:03 am
OLAP Product: PA/TM1, CX
Version: PA 2.0
Excel Version: MSO 365

Re: CellPutN across the intersection of cube cells at once

Post by syd »

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).
Thank you,
syd
MarenC
Regular Participant
Posts: 432
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: CellPutN across the intersection of cube cells at once

Post by MarenC »

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
Post Reply