TM1 Performance Tips

Post Reply
User avatar
tiagoblauth79
Posts: 25
Joined: Fri Aug 26, 2016 1:42 pm
OLAP Product: Cognos BI and TM1
Version: 10.2.2
Excel Version: 10
Contact:

TM1 Performance Tips

Post by tiagoblauth79 »

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. Feel free to share your own experience about it.

tm1s.cfg performance parameters
AreaFunctionBrief Description
PerformanceAllRuleCalcStargateOptimizationWhen AllowSeparateNandCRules=T, it can improve performance in calculating views that contain only rule-calculated values. Minimal time consumption to other views.
PerformanceCalculationThresholdForStorageDefines a minimum number of rule calculations required for a single cell or Stargate view, beyond which the server stores the calculations for use during the current server session. High parameter decrease memory but is slowest, low parameter increases memory and is fastest. Default is 50.
PerformanceCheckFeedersMaximumCellsLimits the number of cells checked by the Check Feeders option in the Cube Viewer. It increases performance to large applications. Default is 3,000,000
PerformanceDisableWorksheetViewYou should disable the worksheet VIEW functions when you work with extremely large row or column dimensions in slice worksheets. DisableWorksheetView=T
PerformanceJobQueueMaxWaitTimeWhen the queue thread runs, it blocks all incoming requests to ensure it can get the locks necessary to process a job on the queue. To give the queue thread higher priority, set the JobQueueMaxWaitTime to a larger number. Defaults to 100ms.
PerformanceJobQueueThreadSleepTimeJobQueueThreadSleepTime determines the frequency with which the thread processing the queue runs when there are queued jobs. Defaults to 10 seconds.
PerformanceJobQueueThreadPoolSizeEnables TM1 to use multiple threads on sandbox request.
PerformanceLockPagesInMemoryWhen LockPagesInMemory=T, Windows trims pages from the TM1 process space, but does not page them to disk. Windows 64-bit only.
PerformanceMaximumCubeLoadThreadsSpecifies whether the cube load and feeder calculation phases of server loading are multi-threaded, so multiple processor cores can be used in parallel. If your Cognos TM1 model uses conditional feeders where the condition clause contains a fed value you should not use this. Best set is process chores -1
Memory consumptionMaximumMemoryForSubsetUndoSets the maximum amount of memory, in kilobytes, to be dedicated to storing the Undo/Redo stack for the Subset Editor. Default is 10240 kilobytes (10 MB).
PerformancePersistentFeedersTo improve reload time of cubes with feeders, set to T. Using the Persistent Feeders feature will increase your system size on disk only. Memory size is not affected by the use of this parameter.
Server load timePrivilegeGenerationOptimizationWhen this parameter is set to T, the TM1 server will read only the populated cells in security cubes. In the case of a sparsely populated security cube, this will dramatically shorten the server's load time.
Server load timeSkipLoadingAliasesUse SkipLoadingAliases to speed up the loading of the server and updating of views by skipping the loading of aliases. Check support if you can use it.
PerformanceSubsetElementBreatherCountThis parameter manages the way it handles locking behavior for subsets.
SubsetElementBreatherCount=-1 (standard) better for single access
SubsetElementBreatherCount=0 better for concurrent access
PerformanceViewConsolidationOptimizationMethodThis parameter defines the method used to achieve view consolidation optimization. It should be set to TREE in most circumstances. Two methods: TREE (for tree aggregations) and ARRAY (for multiple aggregations). Default is ARRAY.

tm1p.ini performance parameters
AreaFunctionBrief Description
PerformanceDimensionDownloadMaxSizeTo improve performance when you work with large dimensions, add DimensionDownloadMaxSize so that large dimensions will cache on the client.
I hope it helps someone.
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: TM1 Performance Tips

Post by BariAbdul »

Thanks a lot, tiagoblauth79.It will definitely help.
"You Never Fail Until You Stop Trying......"
Post Reply