Search found 1211 matches

by Martin Ryan
Sun Jan 12, 2014 9:39 pm
Forum: General
Topic: VM Scheduled Maintenance
Replies: 41
Views: 63916

Re: VM Scheduled Maintenance

All of our hardware nodes where your VPS(s) are hosted on are scheduled to be rebooted to allow virtualisation updates to be applied between: Start time: 17/01/2014 00:00 NZDT End time: 17/01/2014 04:00 NZDT We anticipate up to 60 minutes of downtime during this period and apologise for the inconve...
by Martin Ryan
Fri Dec 13, 2013 12:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number Lock On/OFF Issue
Replies: 14
Views: 10760

Re: Number Lock On/OFF Issue

How annoying. It's a minor thing but it's one that really winds people up.
by Martin Ryan
Mon Dec 09, 2013 8:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number Lock On/OFF Issue
Replies: 14
Views: 10760

Re: Number Lock On/OFF Issue

skinners666 wrote:This issue has been addressed in TM1 9.5.2 FP3 and TM1 10.1.1 FP1.

http://www-01.ibm.com/support/docview.w ... wg1PM26333
Has anyone else experienced the issue after upgrading to 10.1.1 FP1? We've upgraded and we're still having problems. Using Excel 2010 over Citrix.

Martin
by Martin Ryan
Sun Nov 24, 2013 10:16 pm
Forum: General
Topic: Memory errors
Replies: 14
Views: 6791

Re: Memory errors

Anyone notice an improvement with the new .ini file or is it still patchy?
by Martin Ryan
Mon Nov 18, 2013 9:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with TM1 Dimensions
Replies: 12
Views: 3783

Re: Problem with TM1 Dimensions

As so often with TM1 personal preference allows you to do what you please and it'll typically work for you. However it my experience I would find Solanna's methodology would work best where - the model is fairly small and homogeneous (e.g. just finance or just HR) - users don't use the model very of...
by Martin Ryan
Wed Nov 13, 2013 7:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parent Child Dimension
Replies: 5
Views: 1825

Re: Parent Child Dimension

what would be the approach to "you just skip over adding the child element if the parent is "#" or an empty string" In pseudo code you'll need insert child to dimension if sParent='' then do nothing else insert parent to dimension create parent child relationship end if You'll want functions like d...
by Martin Ryan
Wed Nov 13, 2013 7:09 am
Forum: General
Topic: Memory errors
Replies: 14
Views: 6791

Re: Memory errors

I've reset php.ini back to the default and restarted apache. Fingers crossed...
by Martin Ryan
Tue Nov 05, 2013 9:15 pm
Forum: General
Topic: Memory errors
Replies: 14
Views: 6791

Re: Memory errors

That is really annoying. During the upgrade it asked me if I wanted to retain the old php.ini file or use the new one. I said stick with the old one (as I'd made a couple of edits to allow bigger uploads). I think that was the wrong call. I'll update it and let you know when I've done that so we can...
by Martin Ryan
Tue Oct 29, 2013 7:13 am
Forum: General
Topic: Memory errors
Replies: 14
Views: 6791

Re: Memory errors

The forum and PHP version have been upgraded. After a week or two can people please let me know if they've noticed these crashes getting any better, worse or no different?
by Martin Ryan
Tue Oct 29, 2013 7:12 am
Forum: General
Topic: FORUM OUTAGE - Updating PHP and phpBB version
Replies: 2
Views: 2972

Re: FORUM OUTAGE - Updating PHP and phpBB version

Forum and PHP version now updated. Seemed to go smoothly. Only potential conflict is with the email notifications so let me know if you see any problems.
by Martin Ryan
Wed Oct 23, 2013 7:29 am
Forum: General
Topic: FORUM OUTAGE - Updating PHP and phpBB version
Replies: 2
Views: 2972

Re: FORUM OUTAGE - Updating PHP and phpBB version

Sorry, I didn't get to it last week. My four month old baby hasn't co-operated with my plans. I'll probably have another crack next week. Again, I'll post on Facebook/Twitter when I start so if the forum's down check there to check if I've started.

Martin
by Martin Ryan
Tue Oct 15, 2013 7:06 am
Forum: General
Topic: FORUM OUTAGE - Updating PHP and phpBB version
Replies: 2
Views: 2972

FORUM OUTAGE - Updating PHP and phpBB version

I'm going to update the PHP version and the phpBB version too in the next few days, evening time in New Zealand (about 7 or 8am GMT). It shouldn't take too long but keep an eye on the Facebook or Twitter feeds if it's down for more than ten minutes. I'll post on there when I start and finish and pos...
by Martin Ryan
Mon Oct 14, 2013 8:06 am
Forum: General
Topic: Memory errors
Replies: 14
Views: 6791

Memory errors

I've had two reports of memory errors from admins today. I'd like to get a handle on how big the problem is because I've used up all the easy fix options and they only seemed to have reduced the problem, not fixed it. Next stop is upgrading the PHP version and/or changing server providers. I'm happy...
by Martin Ryan
Wed Oct 02, 2013 9:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruling values between dimension elements
Replies: 2
Views: 1277

Re: Ruling values between dimension elements

Marc, great to see someone paying attention to the guidelines for making postings. It makes it much easier to provide meaningful replies when the question is well put. A few key points to help you on your way: Feeders don't move the data, they just flag which cells need to be calculated with a rule....
by Martin Ryan
Mon Sep 16, 2013 1:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM training exams
Replies: 2
Views: 1182

Re: IBM training exams

It's been covered a few times. Search for "exams" in the search box at the top right. The consensus is that the exams aren't particularly onerous on those who know TM1. We've previously discouraged offering too much help in the way of preparation for these exams on the forum. The reason is that anyo...
by Martin Ryan
Sun Sep 08, 2013 11:31 pm
Forum: General
Topic: VM Scheduled Maintenance
Replies: 41
Views: 63916

Re: VM Scheduled Maintenance

The hardware node where your VPS is hosted on is scheduled to have a disk upgrade between: Start time: 13/09/2013 00:00 NZST End time: 13/09/2013 05:00 NZST This will allow for better performance and quicker file system checks in the event of an emergency reboot. This should not cause any issues to...
by Martin Ryan
Wed Aug 28, 2013 4:25 am
Forum: Useful code, tips and tricks
Topic: Averages for Consolidations
Replies: 7
Views: 14360

Re: Averages for Consolidations

I've refined my approach somewhat over the 5 years (5 years!!!!) since I wrote this post and have a fourth method that's a hybird of method 1 and 2. It's a bit more complex, but it allows for handling multiple averages in a cube fairly cleanly. Method 4: Numerator/Denominator This method allows flex...
by Martin Ryan
Wed Aug 21, 2013 5:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ROUNDUP Function in TM1 Rules
Replies: 9
Views: 6659

Re: ROUNDUP Function in TM1 Rules

I usually just add 0.49999 and then round it. That will ensure a figure is always rounded up. It appears less precise, but I've never seen it not work. It's also slightly faster than an IF statement. ['x'] = round(['y'] - ['z'] + 0.49999); NB the reason it's 0.49999 and not 0.5 is because if you add...
by Martin Ryan
Tue Aug 20, 2013 1:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In a global context, how does TM1 compare to...
Replies: 13
Views: 4337

Re: In a global context, how does TM1 compare to...

Here's a few to get you started... http://www.tm1forum.com/viewtopic.php?f=3&t=1059 (BPC) http://www.tm1forum.com/viewtopic.php?f=3&t=1194 (EP) http://www.tm1forum.com/viewtopic.php?f=3&t=3711 (BPC and PM10) http://www.tm1forum.com/viewtopic.php?f=3&t=883 (BO) http://www.tm1forum.com/viewtopic.php?p...