Search found 217 matches

by TrevorGoss
Fri Jun 30, 2017 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ti process error when running batch file
Replies: 3
Views: 936

Re: Ti process error when running batch file

Hi, Thanks for quick reply and the pointers , we tried them all and they worked, it came down to this. By changing the batch file path to one having no spaces in the folder path, the TI process did then execute correctly What is strange is that this error occurred only now, considering the path wit...
by TrevorGoss
Fri Jun 30, 2017 10:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ti process error when running batch file
Replies: 3
Views: 936

Re: Ti process error when running batch file

Hi,

try running the batch or command (or both) separately from the TI, via the command line. Also try running it as the user the TM1 service is using, see what results you get.

Trevor.
by TrevorGoss
Fri Jun 30, 2017 10:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Delete Users in Bulk
Replies: 4
Views: 1811

Re: Delete Users in Bulk

Hi guys, any one know of a way to delete users in bulk? I noticed that about 30 users have left our department and would like to remove them from the system, is there a quick way for me to delete them in bulk? does it have to be done through a TI? If yes, can I ask for a copy of the code? Thanks in...
by TrevorGoss
Fri May 26, 2017 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives workbooks when promoted to different version
Replies: 4
Views: 1503

Re: Perspectives workbooks when promoted to different version

Hi, thanks to all for your replies. What do you mean by "shifted"? Do you mean you just moved the entire data directory from a 10.2.2 server to a 10.3 server and brought it up or did you republish the workbooks in question? Also, are you talking about opening the workbooks in Excel or from TM1 Web? ...
by TrevorGoss
Wed May 24, 2017 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives workbooks when promoted to different version
Replies: 4
Views: 1503

Perspectives workbooks when promoted to different version

Hello to all, I have developed Perspective workbooks in TM1 10.2.2, with action buttons running TIs and opening up new workbooks. When the workbook is moved onto a new server with 10.3, all the buttons lose their shape. the text is shifted to the top left hand corner of the button, its as if a new b...
by TrevorGoss
Mon Feb 06, 2017 8:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To use or not to use persistent feeders?
Replies: 20
Views: 7816

Re: To use or not to use persistent feeders?

There is something else that needs to be taken into account when deciding on the use of persistent feeders, and that is memory. Now the IBM document for using persistent feeders states: Using the Persistent Feeders feature will increase your system size on disk only. Memory size is not affected by t...
by TrevorGoss
Fri Feb 03, 2017 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Chrased
Replies: 7
Views: 1466

Re: Tm1 Chrased

I have manually started the Master process that run before the server crashed ( with same input parameters) and it finished with no error. The processQuit was part of a process that was started by the Master Load Process. what do you mean by "have you tried starting the server without running the c...
by TrevorGoss
Fri Feb 03, 2017 10:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To use or not to use persistent feeders?
Replies: 20
Views: 7816

Re: To use or not to use persistent feeders?

Well, it can cause you to run out of disk space, which will cause a crash, but apart from that I am not so sure.
by TrevorGoss
Fri Feb 03, 2017 10:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to exit LOOP in TM1 TI?
Replies: 3
Views: 2175

Re: How to exit LOOP in TM1 TI?

Hi, how to exit LOOP if certain condition is met in TM1 TI? Is below the correct way? nNum = 1; While( nNum <= 7 ); sNum = NumberToString( nNum ); IF( EXPAND( '%v' | EXPAND( '%sNum%' ) | '%' ) @= 'Test' ); END; ENDIF; nNum = nNum + 1; END; you can use the Break keyword from 10.x onwards. Example: x...
by TrevorGoss
Fri Feb 03, 2017 9:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Chrased
Replies: 7
Views: 1466

Re: Tm1 Chrased

Thank you for the fast response. They don t exist. There is a Master Load Process that first runs Dimension update, then updates the cubes , then it does some calculation and after that is exporting a CSV that is bulk load into Thank you There is an aborted process in the start of your server, is t...
by TrevorGoss
Fri Feb 03, 2017 9:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To use or not to use persistent feeders?
Replies: 20
Views: 7816

Re: To use or not to use persistent feeders?

Hi guys, I'm just wondering - do you use persistent feeders or not? If yes - why? If not - why? I have my own opinion for this topic but I would like to hear also others... BR Vladino Persistent feeders help a TM1 server start up quicker. When the persistent feeders parameter is set to T, the TM1 s...
by TrevorGoss
Fri Feb 03, 2017 8:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Chrased
Replies: 7
Views: 1466

Re: Tm1 Chrased

Hi, I have Persistent All my client confidential information will be replaced by: confidential The last executed actions before crash were 2 automatically chores that start a data load. This load does not contain a bulk lode mode. What does it say in the error logs (if they exist) of the TI that we...
by TrevorGoss
Tue Jan 31, 2017 12:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Crashes
Replies: 14
Views: 3117

Re: TM1 Crashes

Hi, I have made some changes in the TM1 configuration ( before this i had no problems, this changes where made to optimize the run time). I have changed Maximum Core Cube Load from 0 to 2, persistence feeder = T, and feeder optimization. This is just a guess, but have you set the MaximumCubeLoadThr...
by TrevorGoss
Mon Jan 30, 2017 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Performance Tuning
Replies: 15
Views: 3007

Re: TI Process Performance Tuning

The picklist is probably red herring since I think it can only stop people from entering incorrect values through one of the user interfaces, not a TI. You could stop people from entering incorrect values into a Picklist from a TI by using the SCAN function on the Attribute value. The logic would b...
by TrevorGoss
Tue Jan 10, 2017 1:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do I write a TI code in Prolog tab for my requirement?
Replies: 6
Views: 1961

Re: How do I write a TI code in Prolog tab for my requirement?

Hello Rao, You will be lucky if someone on here writes your code for you, but below are some links to the functions that can help you do what you want to do. http://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_ref.10.2.2.doc/c_dimensionmanipulationturbointegratorfun...
by TrevorGoss
Tue Aug 23, 2016 1:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change TM1 server location - Service getting started from old location
Replies: 7
Views: 1583

Re: Change TM1 server location - Service getting started from old location

You can also delete the service from the Cognos configuration application. Is there a reason for deleting via a windows command instead of the Cognos configuration? I know when you delete it from the Cognos configuration it saves all of your other services and when you close the application it asks...
by TrevorGoss
Tue Aug 23, 2016 7:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change TM1 server location - Service getting started from old location
Replies: 7
Views: 1583

Re: Change TM1 server location - Service getting started from old location

DELETE the service using cmd.exe (sc delete "service name") Then Cognos Configuration will regenerate the service with the correct path to the folder containing tm1s.cfg You can also delete the service from the Cognos configuration application. Is there a reason for deleting via a windows command i...
by TrevorGoss
Fri Jul 01, 2016 8:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: When to use a new TM1-instance?
Replies: 3
Views: 986

Re: When to use a new TM1-instance?

The amount of TM1 instances you have depends heavily on your business requirements, not just technical issues. There are technical issues that you have to take into account, such as the size of the model. If the model takes too long to load, or if a dimension cannot open because it is too large, the...
by TrevorGoss
Fri Jul 01, 2016 8:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteCommand() argument working from cmd but not TM1
Replies: 5
Views: 2612

Re: ExecuteCommand() argument working from cmd but not TM1

Hello, Most of the time these kinds of issues are due to presence of Space in a filepath and any improper usage of double quotes. This may well be the case with your issue. When using double quotes for the execute command function, we use this code: ## Double quotes for spaces in commmand vQuote = C...
by TrevorGoss
Tue Jun 28, 2016 8:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Long Start Up time after a crash
Replies: 4
Views: 1275

Re: Long Start Up time after a crash

Hi All, We're running 10.2.2 FP4. Recently I noticed that if the server crashes, the start up time can take hours. Even with a tm1s.log file of only 250kb with 1200+ records contained Looking online, I found this http://www-01.ibm.com/support/docview.wss?uid=swg21654137 but it depends upon the serv...