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?
CellPutN across the intersection of cube cells at once
-
- 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
Thank you,
syd
syd
-
- 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
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.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?
-
- 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
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
syd
-
- 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
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
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