Search found 25 matches

by tiagoblauth79
Mon Oct 23, 2017 4:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Package Connector is disabled
Replies: 3
Views: 633

Re: TM1 Package Connector is disabled

Yes, I do. Thanks for the tip.
by tiagoblauth79
Mon Oct 23, 2017 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Package Connector is disabled
Replies: 3
Views: 633

TM1 Package Connector is disabled

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...
by tiagoblauth79
Sun Oct 22, 2017 5:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Configuration does not Open
Replies: 1
Views: 683

Re: Cognos Configuration does not Open

I just found the same thing. Something goes bad on the server. TM1 reinstalled and everything is working now.
by tiagoblauth79
Tue Oct 17, 2017 10:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is the future of Cognos TM1/PA?
Replies: 1
Views: 467

Re: What is the future of Cognos TM1/PA?

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 that and Arc...
by tiagoblauth79
Tue Oct 17, 2017 8:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide Contributor User Instructions
Replies: 0
Views: 425

Hide Contributor User Instructions

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.
by tiagoblauth79
Tue Oct 10, 2017 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help to create TI process to copy data
Replies: 5
Views: 851

Re: Need help to create TI process to copy data

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...
by tiagoblauth79
Mon Oct 09, 2017 7:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 1815

Re: Dynamic subset based on a cube value, with another dimension

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 | Product (co...
by tiagoblauth79
Mon Oct 09, 2017 6:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old data pops up in a cube even after performing a deletion in a cubeview.
Replies: 4
Views: 597

Re: Old data pops up in a cube even after performing a deletion in a cubeview.

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: "","2017100916...
by tiagoblauth79
Mon Oct 09, 2017 5:47 pm
Forum: Useful code, tips and tricks
Topic: TM1 Tip - Parallel Processing with tm1runti
Replies: 1
Views: 959

TM1 Tip - Parallel Processing with tm1runti

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...
by tiagoblauth79
Tue Oct 03, 2017 9:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Locking Issues
Replies: 23
Views: 6041

Re: Locking Issues

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...
by tiagoblauth79
Mon Aug 21, 2017 6:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot start TM1 Application Server
Replies: 8
Views: 9045

Re: Cannot start TM1 Application Server

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.
by tiagoblauth79
Wed Jul 26, 2017 9:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Nominal Value in Consolidation
Replies: 5
Views: 974

Re: Nominal Value in Consolidation

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));
by tiagoblauth79
Tue Jul 25, 2017 7:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Object dependency walker- get list of all dependent objects
Replies: 4
Views: 980

Re: TM1 Object dependency walker- get list of all dependent objects

tm1server.log registers cube dependencies at server startup. It might help you.
by tiagoblauth79
Tue Jul 25, 2017 6:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 user logon details
Replies: 1
Views: 456

Re: TM1 user logon details

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 displays the...
by tiagoblauth79
Tue Jul 25, 2017 6:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Securing dilemma
Replies: 4
Views: 776

Re: Securing dilemma

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...
by tiagoblauth79
Tue Jul 25, 2017 5:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Performance Tips
Replies: 1
Views: 648

TM1 Performance Tips

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. ...
by tiagoblauth79
Mon Jul 24, 2017 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: app_maintenance refresh order
Replies: 1
Views: 555

Re: app_maintenance refresh order

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.
by tiagoblauth79
Tue Mar 07, 2017 6:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bat to execture a process
Replies: 2
Views: 564

Re: Bat to execture a process

-adminhost "server:port" is missing
by tiagoblauth79
Mon Mar 06, 2017 9:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Process Redesigning
Replies: 10
Views: 2037

Re: TM1 Process Redesigning

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 evaluate which processes have being started / com...
by tiagoblauth79
Fri Mar 03, 2017 7:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Process Redesigning
Replies: 10
Views: 2037

Re: TM1 Process Redesigning

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