TM1 cfg parameter - RulesOverwriteCellsOnLoad

Post Reply
gabi
Posts: 23
Joined: Thu Jun 19, 2008 12:44 pm

TM1 cfg parameter - RulesOverwriteCellsOnLoad

Post by gabi » Wed Apr 13, 2016 2:54 pm

Hello,

Checking new parameters on tm1s.cfg on TM1 10.2.2 FP5 server, I found RulesOverwriteCellsOnLoad significantly effects TM1 server load time and memory consumption.
http://www.ibm.com/support/knowledgecen ... lang=en-us

Same model on current TM1 10.1.1 FP2 server load time is 02:13:00 and 117 GB memory consumption on startup.
Running same model on TM1 10.2.2 FP5 with RulesOverwriteCellsOnLoad=F result with 01:19:00 load time and 79 GB memory consumption on startup
Removing RulesOverwriteCellsOnLoad=F parameter on TM1 10.2.2 FP5 server showing same results as original TM1 10.1.1 server

I will appreciate any illumination and recommendations on this parameter.

Thank you,
Gabi
Gabi Cohen
Biconix International

User avatar
Elessar
Regular Participant
Posts: 168
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010
Location: Russia

Re: TM1 cfg parameter - RulesOverwriteCellsOnLoad

Post by Elessar » Wed Apr 13, 2016 3:10 pm

Hi Gabi,

The parameter was discussed a bit earlier in this thread: http://www.tm1forum.com/viewtopic.php?f=3&t=12414

The behaviour is really strange: with RulesOverwriteCellsOnLoad=F the server will store the inputed values "under rules", and so the server should consume more memory.
I think you should raise PMR with IBM.
Sorry for my English ;)

gabi
Posts: 23
Joined: Thu Jun 19, 2008 12:44 pm

Re: TM1 cfg parameter - RulesOverwriteCellsOnLoad

Post by gabi » Wed Apr 13, 2016 3:43 pm

Hello Elessar,

Thank you for your reply.
I'm re-checking this behavior as I did several changes on tm1s.cfg and might caught the wrong parameter.
I'll update with new results tomorrow

Thank you,
Gabi
Gabi Cohen
Biconix International

Andy Key
MVP
Posts: 341
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1 CX
Version: 2-5 to 10-2-x
Excel Version: 2003 2007 2010 2013
Location: Sydney
Contact:

Re: TM1 cfg parameter - RulesOverwriteCellsOnLoad

Post by Andy Key » Thu Apr 14, 2016 3:54 am

Be aware that there is an open issue with IBM where RulesOverwriteCellsOnLoad=F can cause feeders to not fire properly.

You may find that your faster startup and smaller memory footprint is because your model is not completely calculated.
Andy Key

gabi
Posts: 23
Joined: Thu Jun 19, 2008 12:44 pm

Re: TM1 cfg parameter - RulesOverwriteCellsOnLoad

Post by gabi » Thu Apr 14, 2016 9:48 am

Hello again

Andy, Thanks for your reply - I'll verify RulesOverwriteCellsOnLoad impact before setting the prod env..

It seems I mistakenly caught RulesOverwriteCellsOnLoad as the cause for shorten load time and memory use.

Now, I verified 'SkipLoadingAliases' is the cause for shorten load time and memory consumption on startup.
Do you have any recommendations using this parameter?


Thank you,
Gabi
Gabi Cohen
Biconix International

User avatar
Elessar
Regular Participant
Posts: 168
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010
Location: Russia

Re: TM1 cfg parameter - RulesOverwriteCellsOnLoad

Post by Elessar » Thu Apr 14, 2016 2:03 pm

I think you should create a new topic with the subject "TM1 cfg parameter - SkipLoadingAliases". Our descendatns will appreciate this :)

IBM site tells us that "Please contact customer support to determine if this parameter is applicable to your Cognos® TM1® system" (This parameter you don't want, my young padawan)
I think it's better to delete the parameter from tm1s.cfg, if you do not know what it does.
Sorry for my English ;)

moby91
MVP
Posts: 211
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: TM1 cfg parameter - RulesOverwriteCellsOnLoad

Post by moby91 » Fri Apr 15, 2016 7:58 am

Andy Key wrote:Be aware that there is an open issue with IBM where RulesOverwriteCellsOnLoad=F can cause feeders to not fire properly.

You may find that your faster startup and smaller memory footprint is because your model is not completely calculated.
Do you refer to the defect logged as APAR PI56768 which has been addressed by the IF1 for TM1 10.2.2 FP5 ?

https://www-304.ibm.com/support/entdocv ... wg1PI56768
PI56768: FEEDERS APPEAR NOT TO BE FEEDING THE CUBE IF RULESOVERWRITECELLS ONLOAD=F, PERSISTENTFEEDERS=F AND SUPPRESS ZEROS IT TURNED ON.

Andy Key
MVP
Posts: 341
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1 CX
Version: 2-5 to 10-2-x
Excel Version: 2003 2007 2010 2013
Location: Sydney
Contact:

Re: TM1 cfg parameter - RulesOverwriteCellsOnLoad

Post by Andy Key » Tue Apr 19, 2016 4:57 pm

That looks to be a similar issue, but we found it in 10.2.2 FP4 rather than 10.1 as that link shows, and the setting of PersistentFeeders didn't make any difference for us. I don't have the precise APAR number to hand, so it is possible that it is just a mis-identification on that ticket. If it is correct in saying that it was 10.1, then it must be a regression bug (surely not!) as we were using the same code base and the same config file in base 10.1.1 without any problems.

IBM have assured us that it is fixed in 10.2.2 FP5 IF1 despite it not being mentioned in IBM's List of Fixes. We're too deep into getting an upgrade to 10.2.2.4.15 settled in to have a chance to install any new versions, and we'll probably be waiting for a few more critical fixes to be addressed as well.
Andy Key

failurehappening
Posts: 78
Joined: Tue Nov 30, 2010 1:18 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: TM1 cfg parameter - RulesOverwriteCellsOnLoad

Post by failurehappening » Wed Apr 20, 2016 3:59 am

I believe the PMR Andy is talking about is
PMR 70882,101,616 - Feeders do not fire up on startup in the TM1 Instance
RHR

Post Reply