Search found 53 matches

by ellissj3
Mon Jul 31, 2017 1:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: is python is used in Planning analytics
Replies: 6
Views: 1730

Re: is python is used in Planning analytics

Vinod,

This should be a different thread, and it does not follow the posting guidelines.

TM1S.CFG - Server configuration file which dictates the operations of the TM1 server itself

TM1P.INI - User configuration file
by ellissj3
Wed Jul 26, 2017 8:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tracking User Logins
Replies: 19
Views: 4108

Re: Tracking User Logins

try inserting this into the tm1s-log.properties ### CREATE LOGIN FILE log4j.logger.TM1.Login = DEBUG, LOGIN log4j.appender.LOGIN = org.apache.log4j.SharedMemoryAppender log4j.appender.LOGIN.MemorySize = 1MB log4j.appender.LOGIN.File = tm1login.log log4j.appender.LOGIN.MaxFileSize = 2MB log4j.appende...
by ellissj3
Tue Jul 11, 2017 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAFE & Excel 2013
Replies: 2
Views: 873

Re: CAFE & Excel 2013

Hello, We experienced this. Do you happen to be using other add-ins in Excel. When examining the dump logs, we found these older (non-supported) add-ins were the root cause. For some reason, CAFE didn't work nicely with them. You may want to try examining the dump logging, or asking your help desk t...
by ellissj3
Mon Jun 12, 2017 11:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Format zeros as blank in planning analytics
Replies: 3
Views: 1067

Re: Format zeros as blank in planning analytics

I raised this with IBM. They mentioned that the number formatting must be on "0.00" for this to work. They mentioned it would be fixed in future releases.

I found this on 10.2.2 FP3.

HTH
by ellissj3
Fri Sep 09, 2016 2:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Go to Another Websheet
Replies: 3
Views: 617

Re: TM1 Go to Another Websheet

Hi,

Have you checked the TM1 Web configuration for the setting that governs the sheets calculating on activation?

add value="true" key="RecalcOnActivate"
by ellissj3
Tue Mar 10, 2015 2:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Jump after pressing Enter button on IE browser
Replies: 5
Views: 2743

Re: Jump after pressing Enter button on IE browser

All,

A recent Hot Fix was provided to alleviate this Friday 2/20. I would ask IBM Support for this fix.

Hope this Helps,
by ellissj3
Thu Jan 08, 2015 12:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creation of Cascade Style Sheet
Replies: 2
Views: 1306

Re: Creation of Cascade Style Sheet

Alan,

Thank you for the response. I agree with you regarding the size of the report. I wasn't involved when it was created and I advised the client around breaking this out (unsuccessfully). I will look into your recommendation around caching the data into memory on the server.
by ellissj3
Thu Jan 08, 2015 12:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 & XBRL Reporting
Replies: 4
Views: 1604

Re: TM1 & XBRL Reporting

I agree w/ Mr. Usherwood. CDM is a good choice for TM1 / XBRL reporting
by ellissj3
Thu Jan 08, 2015 12:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creation of Cascade Style Sheet
Replies: 2
Views: 1306

Creation of Cascade Style Sheet

I am in a situation where a client is upset at the time it takes to initially open a very large and complex Active form on the web as a websheet. The workbook itself has 30+ worksheets and multiple active form sections on each sheet. This workbook takes about 9 minutes to load the cascading style sh...
by ellissj3
Wed Jan 07, 2015 12:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Problem with Subtraction und Multiplication
Replies: 6
Views: 1913

Re: Feeder Problem with Subtraction und Multiplication

Based on the calculation, I anticipate you would need to feed from 2 of the 3 terms: I evaluated your rule as essentially A-(B*C) ['dim1','dim2','dim3','dim4','dim5',dim6']=N: DB('Cube1','dim1',!dim2,'dim3',!dim4,!dim5,'dim6','dim7','dim8',ELPAR('dim9',!dim9,index),'dim10')-(DB('Cube1', 'dim1', !dim...
by ellissj3
Mon Aug 04, 2014 8:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: xdi bug in 10.1?
Replies: 7
Views: 1981

Re: xdi bug in 10.1?

Was there any resolution via IBM PMR? I am experiencing same issue.
by ellissj3
Fri Aug 17, 2012 5:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: EV Custom Calculation Performance
Replies: 0
Views: 304

EV Custom Calculation Performance

One of our clients is using Executive Viewer for most of their reporting/analysis. We are running into slow performance with EV so I thought I'd ask for opinions...the background: 1) EV view that uses alot of custom formulas to retrieve data runs slow. 2) We have created facisimilies of the EV view ...
by ellissj3
Thu May 24, 2012 8:19 pm
Forum: OLAP Jobs
Topic: TM1 Developer Position - Orangeburg,NY, USA
Replies: 0
Views: 802

TM1 Developer Position - Orangeburg,NY, USA

Hello, A networking contact of mine is looking for a TM1 Developer Position in Orangeburg, NY. Domestic Relocation is being offered for the right candidate. Please see below excerpt. Please PM me if you are interested, and I will ensure you get more details. Thank you, ------------------------------...
by ellissj3
Wed Mar 28, 2012 6:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 952 PI - management of multithreaded processes
Replies: 19
Views: 3477

Re: 952 PI - management of multithreaded processes

I don't disable the schedule, I just make sure that the criteria will only successful one time every day. I have a 2 logs occurring for every chore. One is to indicate chore is in progress, and one is when chore is complete. The chore will only execute when the chore is not in progress and not compl...
by ellissj3
Wed Mar 28, 2012 5:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 952 PI - management of multithreaded processes
Replies: 19
Views: 3477

Re: 952 PI - management of multithreaded processes

PlanningDev, How do you control the serial updates for dimensions? Do you put all of the dimension updates in a chore to serialize them? Also, does anyone know if you can run dimension updates in parallel as long as they don't have security and aren't related to any of the same cube objects? I am un...
by ellissj3
Tue Mar 27, 2012 7:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dumb question, but . . .
Replies: 4
Views: 650

Re: Dumb question, but . . .

@= is required when youre conducting a conditional statement to evaluate a string.

For Example:

if (<Current Version> @= 'Plan' );
Then ....
Endif;
by ellissj3
Tue Mar 27, 2012 5:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 952 PI - management of multithreaded processes
Replies: 19
Views: 3477

Re: 952 PI - management of multithreaded processes

Maybe I'm missing something, but I think that your approach ensures that your processes run in sequence, not in parallel. What I'm trying to do is to force a massive amount of calculation through a large complex model in less time than happens now, utilising multiple cores to calculate distinct par...
by ellissj3
Tue Mar 27, 2012 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 952 PI - management of multithreaded processes
Replies: 19
Views: 3477

Re: 952 PI - management of multithreaded processes

Forumers may recall the humungous model I have which takes days to process. I've been liaising with IBM on using PI to parallel process the calculations, which led to 952 FP1 HF6, which significantly improves process time (reduced by a factor of 200). I'm now exploring how to manage such a set of p...
by ellissj3
Tue Feb 28, 2012 9:15 pm
Forum: Bugs
Topic: View Construct Issue PMR 86469,756,000
Replies: 14
Views: 8614

Re: View Construct

I saw similar issue where we had an operating RAM at 50Gb (as a service). This ended up eclipsing 195Gb, causing a service crash.