Anaplan With Numbers
Interesting Anaplan Numbers
Anaplan is built for numbers.
The Hyperblock engine performs complex calculations at a high speed, processing millions of numbers in milliseconds. But have you ever thought about the numbers that limit Anaplan?
Here’s a closer look at some key limits and specifications.
Time Limits in Anaplan
- 97 — The maximum time range is 98 years, spanning from 1981 to 2078.
- 81 — The model calendar supports up to 81 years.
- 71 — The longest continuous time range allowed within a single model.
CloudWorks Limits
- 5000 — CloudWorks supports up to 5000 workspaces.
- 500 — A tenant can have up to 500 integrations.
- 50 — If there are more than 50 integrations in a tenant, the list paginates.
- 6 — Integration history is kept for six months.
- 10 — Maximum file size (in GB) for AWS and Azure imports.
- 3 — Maximum file size (in GB) for Google BigQuery imports.
- 48 — Failure logs expire after 48 hours.
API Constraints
- 30 — API tokens expire after 30 minutes.
- 30 — Audit API retains events for 30 days.
Excel Add-in Compatibility
- 2013 — The minimum version of Microsoft Office required for compatibility.
- 8,190 — The maximum character limit for a text line item.
- 32,767 — The maximum number of items in a list dropdown.
- 1,000,000 — The maximum single dimension size of imported modules and views.
- 5,000,000 — The maximum number of cells of Anaplan data per Excel worksheet.
Performance Testing Thresholds
- 8 — Performance testing is recommended for models exceeding 8 GB.
- 1,000,000,000 — If the number of cells in a model exceeds 1 billion, performance testing is advised.
- 400 — If a model has more than 400 users, testing for performance impact is recommended.
Center of Excellence (CoE) Guidelines
- 2 — Every CoE should have two key roles: an executive sponsor and a CoE lead.
- 3 — CoE development follows three phases: foundation, centralization, and scaling.
- 4 — Recommended resolution time (in hours) for high-priority issues.
CoE Recommended Response and Resolution Times:
- Critical: Response: 30 min, Minimum Resolution: 2 hrs, Maximum: 4 hrs
- Major: Response: 2 hrs, Minimum Resolution: 4 hrs, Maximum: 12 hrs
- Minor: Response: 8 hrs, Minimum Resolution: 12 hrs, Maximum: 24 hrs
- Cosmetic: Response: 12 hrs, Minimum Resolution: 24 hrs, Maximum: 48 hrs
Function Limitations
- 10,000 — Built-in character limit for TEXTLIST functions.
- 50,000,000 — The maximum count for ISFIRSTOCCURRENCE(), as it does not apply to summed values.
The 60-Character Limit
Anplan has a 60-character limit in most text fields. You cannot create a text object with more than 60 characters.
Get Seyma - Anaplan for everyone!’s stories in your inbox
Join Medium for free to get updates from this writer.
Here are the places where this rule applies:
- Model Names, Module Names, Functional Area Names, Line Item Names
- List Names, List Item Names, List Codes, User Names, User Email Addresses
- Action Names, Process Names, Time Range Names
- App Names, Category Names, My Pages Names, UX Page Names, UX Page Button Descriptions, Classic Dashboard Names
- CloudWorks Connection Names, CloudWorks Integration Names, CloudWorks Integration Flow Names
The Exception to the 60-Character Rule
While most text fields in Anaplan are restricted to 60 characters but there’s one small exception: Workspace names.
They allow up to 75 characters, providing more flexibility when naming workspaces. This is the only place where the character limit exceeds 60.
Final Thoughts
Numbers are at the heart of Anaplan, and these figures provide insights into its limits and capabilities.
Whether you’re working with time ranges, integrations, APIs, or model performance, understanding these numbers helps ensure smooth operations and better planning within Anaplan.
Want to connect or have a question?
Let’s connect on LinkedIn: https://www.linkedin.com/in/seyma-tas/
Or reach me by email: seymatas@gmail.com
