TM1 Forum

This is an indication that the process did not get triggered at all, and usually this is due to security access or the name of process is not spelled correctly. If the name of Process is in a reference cell then check the cell, i usually use Named Ranges for process name, process params, and all oth...

Is it possible to pass the view and cube name as a parameter of the TI Process for a more 'generic' export process? Can I pick the data source in the Prolog instead? Thanks. Yes you can, you can create the View in a master process and pass the name of the view to the other export process along with...

I have created a Python Script to do that. I pass the excel file to a python script, create a dataframe, I clean up the dataframe and at the end I store the Dataframe to a CSV file, which is consumed by a TI Process. The TI process can be executed from within Python Script (TM1Py), or it can be exec...

macsir wrote: ↑Tue Apr 23, 2024 6:01 am Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks.
e.g. Union( [dim].[a].children, [dim].[c].children )

Not possible, different hierarchies of a dimension are treated the same as 2 separate dimensions.

Do yourself a favor, use RushTI. Before I started using RushTI, process parallelization was always causing challenges.

Data will be spread to leaf cells proportionally with existing values.

In this Case:
Value of January will change from 2 to 3, and value of February will change from 4 to 6. Value of March will remain zero

Wim Gielis wrote: ↑Wed Mar 06, 2024 5:52 am Hello,

Can I ask you why you don’t finish your words and dimension names? It seems weird to have dimension names like that. I have never seen such strange dimension names.

lol: I was thinking exactly the same. Impossible to follow the question with these object names

In that case, all cells will ne fed. Previously fed cells will remain fed until feeders will be rebuilt. On top of existing feeders, the updated feeder will Feed A1, so the results will be: ABC1('A1', 'Total Year') = 31 ABC1('B1', 'Total Year') = 16 ABC1('C1', 'Total Year') = 15 But after the feeder...

Still the results will be the same:

ABC1('A1', 'Total Year') = 0
ABC1('B1', 'Total Year') = 16
ABC1('C1', 'Total Year') = 15

• A1 will not be fed
  B1 will be fed from B
  C1 will be fed from C

Only B1 and C1 are being fed, so the in the ABC1 Cube, the value of each elements will be:

ABC1('A1', 'Total Year') = 0 # A1 is not being fed,
ABC1('B1', 'Total Year') = 16
ABC1('C1', 'Total Year') = 15

Thank you Ardian. Good additions. Maybe useful to post a sample file for 'config.ini' (though probably standard and not too difficult to do it ourselves) ? Of course without sensitive information but just the structure and some examples of entries. I would also skip the If test for the PRO extensio...

Here is the version of the code I use to promote TIs from one TM1 Instance to another. I have a config file where I save all the connection details and I created a function to get all the information i need from the config file Also, I check if the Process exists in Target Instance. If it exists, I ...

Hi, I want to have a Picklist for all used user defined dimensions. So I want a complete list of all elements, which would be: Dimension:DimName I also want to offer a list of all elements without the top level and a list without the leaf elements. Additionally I need to show attribute names define...

Public or enterprise Github? I ran into similar errors trying to connect on-prem PAW to an enterprise Github repo and so far haven't got it working. I suspected that the connection was being blocked/rejected by enterprise github admins but haven't confirmed that. You are using the SSH url and not t...

Hello, We are trying to use the new PAW feature to add TM1 objects to GIT Repository, and for some reason, we cannot make it work. We have generated the SSH Public Key / Private Key, and also saved the SSH Key to GitHub, but when we enter the Repo URL / SSH Keys in PAW, we receive an error: TM1 Git ...

Found one very strange thing in one TM1 model I can't zero any view in one Cube in it using ViewZeroOut. I've done different things - at the end I deleted all rules from cube and put in view only detail elements. But ViewZeroOut doesn't work again CellPutN works, I can put 0 by hands but ViewZeroOu...

Hi there We have inherited a complex model (which is non business critical) which on rare occasions (every few months), start spiking the RAM to a point where the RAM for the entire server maxes out, and all models go down. Obviously we need to get to the root cause of what is causing this (initial...

lotsaram wrote: ↑Wed Nov 08, 2023 6:21 pm You can't.

TM1 will eat up all available memory until it runs out.

And then it is paging, hanging and crashing time.

And the worst part is that TM1 does not release the memory back until next restart, even if you Zero Out some of the data

Formatting your code will go a long way in helping you to read/understand it and posting within a code block will go a long way in helping the rest of us help you. By the CellGetN you posted at the bottom for InvStatus, it appears you're using only the variables defined in the source view to derive...

And if you want to keep Spreading enabled for some of the users, you should consider turning OFF this option

ProportionSpreadToZeroCells=F

By default this is turned on and in my experience this is dangerous