TM1 Forum

Yes, I do. Thanks for the tip.

Hi, I am creating a new Windows 2012 environment with BI + TM1 10.2.2 (PreProd). All the installation is working (BI, Framework, Architect, Modeler, pmpsvc, tm1web...), but Package Connector is greyed out into Turbo Integrator. I tried all KB I found. Reviewing my checklist: IBM Package Connector is...

I just found the same thing. Something goes bad on the server. TM1 reinstalled and everything is working now.

Hi. I've been working on EP since 1997 and I miss those grey screens. :) I have to upgrade myself for TM1 as you need to do. You can do much more things than EP, but of course, as an open scripting tool (Turbo Integrator) it is not that "click in the options" system. Modeler is changing th...

Hi masters! Is there a way to hide the Contributor "User Instructions" from the tree screen? I don't want to have the user instructions bar as my company does not use it and it is presented maximized in some browser versions. Many thanks.

Hi. We like new guys so we think we are smart. But no one will create the full code for you. The source date, target start date and end date can be in the process parameters. Beginners do one process per cube. If you have more than one cube to copy, you can create a master process to run the copy fr...

Hi Elessar, Unfortunately, I don't know if it is possible to create a dynamic subset to present the products per selling department because it is a "many to many" combination. I had to do something similar to that. It is a hard and ugly solution but it will work. 1) Create a Department | P...

As Alan said, please check the transaction logging. In the log folder for the application check for tm1s.log file (or for example tm1s20171005214604.log). If you can stop the services, clear the log folder, start and run this process only, your life will be simplest. tm1s.log example: "",&...

Hi. I did create a code for parallel processing in TM1, based on tm1runti.exe. With this code, TM1 can run multiple processes at the same time. You can define how many processes you want to run in parallel and the code triggers as many tm1runti is requested. So, when one process is ready, tm1runti t...

Sorry for the 2 years late reply, but I did test something interesting today in TM1 10.2 and I want to share. - TI process with no source, dimension item insert and/or delete in Prolog: no cube lock; - TI process with a source, view create, subset create, data values changes: no cube lock; - TI proc...

I found the same error related to the user set in the Windows services.
Two possible reasons: the user doesn't have the rights needed or bad password.

I don't know if this is the most "elegant" solution, but you can put a clause:

• ['Result'] =N: IF(Roundp(['A'] - ['B'], 2) = 0, Continue, Roundp(['A'] - ['B'], 2));

tm1server.log registers cube dependencies at server startup. It might help you.

Check if you have "MaxBackupIndex" set in tm1admsrv-log.properties. If it is set, the audit log is being erased when it reaches the number of files. The AuditLogMaxFileSize parameter in the tm1s.cgf determines the size of each file size, then TM1 breaks it in more files. Transaction log di...

I suggest using Data Reservation in this case as it can be applied to a specific user. Configuration made in }CubeProperties does enable it. The available Data Reservation modes you can use are listed here: Required (REQUIRED): disables write access for all users for the entire cube and requires you...

Hi, here a list of things that may help you about the TM1 performance and memory consumption. Bear in mind all of these needs to be tested before implemented and this is not all you need, but it is a good start. The intention here is to share what we need to be worried about performance parameters. ...

What I got from IBM support (version 10.1): "yes this is all needed and you user shouldn't be online when updating it". So I did add a verification over security cubes to check if someone is online before starting it.

-adminhost "server:port" is missing

The control cube should have the dimension 1: processes you need to run and dimension 2: "dependency", "start date" and "end date". Each process you run should update "start date" in the Prolog start and "end date" at the Epilog end. This way you can...

Firs I would create a control cube with the process order and dependencies, this cube stores start and end flags to monitor what is running and what is ready. Then a process checks the cube and triggers those 29 processes in the correct order and following the dependencies to move forward, so you ca...