TM1 Forum

You can create a process that scans all *.pro files and *.cho files to extract the information you need. You can extract more information, such as Parameters, their default values etc. But if your Data Source is dynamic, it will be hard to determine the Data Source of your processes. We keep such i...

Hello everyone, I want to create a mapping of the processes we have and I want the mapping to include data source type, data source name and the chore involved (if applicable). I do not see an easy way to do this in TM1 so I am going to try creating a new process and posting the below in the prolog...

skipcheck; 'base annual pay' and 'worker type' are element of measure dimension. 'worker type' is string element having 'a' value at one intersection. while saving rule i am getting syntax error. could anyone find the error. ['base annual pay']=N:if(['worker type']@='a',0,1); For String Measures, y...

TM1 applies the formatting of the Most inner Row dimension, in your case it would be the formatting defined in your Version dimension.

Just curious: What you have called as Employee Dimension seems to be your Measures dimension in the cube?

Correct answer : In addition to official documentation: Files are created in the 1st directory. After you move them to another directory, they are updated there. Use a separate folder for *.rux and *.pro files in your favorite version control system There is a great explanation of this by mce here:...

Thanks for sharing George!

I wonder how many other golden TI Functions like this are there

EP_explorer wrote: ↑Tue Jun 25, 2024 3:40 pm Yes.
I create TaskFile in Prolog
and run ExecuteCommand with rushti in Epilog
With Status Wait

Do you create any Subset/View in the Prolog of the process? If these Views or subsets are referenced in the processes triggered by RushTI, then this might be the reason why your process goes on Wait.

I wrote a process1 which launch 6 processes in parallel (I'm using RushTI if it is important to launch parallel processes) which updates Cube1 and use during update data which calculated in Cube2. Before launch process1 I need launch process2 which updates Cube2. If I launch process2 independently ...

Correct answer : Is described here: https://www.tm1forum.com/viewtopic.php?p=83638#p83638 Leader of this round is michalb . Congrats and welcome! Question #23: GroupsCreationLimit - where is this parameter set? What are recommendations for optimal parameter value? GroupsCreationLimit Is a tm1s.cfg ...

Security is based on }ElementSecurity cube rule. Rule is changed. NO Security is based on }ElementSecurity cube rule. New element is added to the dimension YES }ElementSecurity cube does not have any rules. Particular cell is changed manually NO }ElementSecurity cube does not have any rules. Securi...

I use a different approach. I have a 3-dimensional cube, with one of dimensions being }Processes where for each process I have a few flags such as : email on successful completion, email on complition with minor errors and email on failure with major error Then in Epilog of each process I have a few...

Hi guys, Is anyone aware of any utility that can help to migrate perspective reports to Universal Reports? Even if it does only half of the work, it will still be helpful We have lots of websheets with Active Forms which are really dynamic, so I know there will be impossible to find a utility that d...

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...