Limits of TM1
Christoph Hein
Managing Director at Intito | Expert in Finance & Sustainability Planning | TM1 Fanboy | Advocate for a Sustainable Future
Today I documented the various limits of #tm1. Here are my findings. Looking forward to your feedback. Maybe you had different findings. I tested it on 11.8.4.
Database Limitations
As the avid reader already knows I once confirmed the limit of 256 dimensions per cube (that includes hierarchies by the way). A dimension supposedly contain up to 2 billion elements and there is no actual limit for a tm1 server. As long as the machine provides memory, tm1 will keep on growing. I think you can get 13 TB RAM and 400 cores on AWS. Would be fun to see such a big tm1 database.
Cell Value Limitations
If we dig deeper into a single cube, we see that numeric values are stored in double precision floating point and can contain 15 digits. The smallest number that can be stored that way would be '0.00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'. String cells are limited to 30,000 characters.
Keep in mind that architect and tm1web only show up to 9 digits after the decimal separator.
Processes and Rules
Processes can have up to 16,000 lines of code per tab. Other limits are 3,125,446 characters per string variable and 32,000 characters per line. A process can read/write textfiles with 65,000 characters per line.
Fun Fact: The error message for maximum characters per line in processes is the one for rules.
Rules have a much higher limit per line of 63,000 characters. The number of lines seems not to be limited. I stopped trying after successfully saving a rules file with more than 1,500,000 lines. It was all comments so no questions about calculation time. ;-)
Analyst | Developer | TM1 | Python
3 个月Awesome!!!
TECHNOLOGY/FINANCE/BUSINESS : DIRECTOR, SENIOR MGR & CONTROLLER | PMO/PROJECT MGR | CONSULTANT | TRANSFORMATION | TRANSITION | PROCESS OPTIMIZATION & CI | SHARED SERVICES I VISA STATUS : SG PERMANENT RESIDENT (SPR)
1 年Can anyone advise what's the limit length of a TM1 Cost Center? Cognos Controller has 4 only. How about Cognos TM1? Thanks
TeamOne Google Integration for IBM Planning Analytics | Succeedium Planning Analytics Cloud Extension (SPACE)
2 年Awesome job Christoph Hein! I've got another one for TI processes: Max number of statements The limit is around 16384 statements, which may actually correspond to the max number of lines per tab
Business Intelligence System Manager at Solera, Inc.
2 年How about maximum if/while nesting levels?
IBM Champion 2025 EPM/TM1/Planning Analytics Architect
3 年Named Levels have a length limit of 255 characters, also in TI Processes, String variables can hold up to 8000 characters