Here you'll find Community hot topics! Most searched-for discussions, best practices from our internal experts, trending articles, and more.
What are blocks? How blocks are calculated – General Lists How blocks are calculated – Native Time/Native Versions Hyperblock performance Summary block counts Should I worry about blocks? A reason why we shouldn’t focus on just the block count Focus Points We recommend this article to Experienced Model Builders and…
Building well performing models is a balance between the complexity and functionality of a model versus the number of concurrent users. If you have seen software development / project management triangles, where scope, time and cost control quality, this will be familiar. It is a good way to show the constraints of any…
PLANS PLANS is the new standard for Anaplan modeling—“the way we model.” This covers more than just the formulas and includes and evolves existing best practices around user experience and Data Hubs. It is a set of rules on the structure and detailed design of Anaplan models. This set of rules will provide both a clear…
Introduction Hopefully, by now you've heard of the D.I.S.C.O. methodology for model and module design, but do you fully understand how to put it into practice? D.I.S.C.O. is part of the wider P.L.A.N.S. standard for Anaplan model building and falls under the L for Logical. D.I.S.C.O. provides a logical structure for one to…
Overview Imports are blocking operations. To maintain a consistent view of the data, the model is locked during the import, and concurrent imports run by end users will need to run one after the other and will block the model for everyone else. Exports are blocking for data entry while the export data is retrieved, and…
Reducing the number of calculations will lead to quicker calculations and improve performance. However, this doesn’t mean combining all your calculations into fewer line items, as breaking calculations into smaller parts has major benefits for performance. Learn more about this in the Formula structure for performance…
All too often, when analyzing a model, we see very long, convoluted, and complex formulas. These are commonly nested IF THEN ELSE statements and can be in excess of 5,000 characters. Line item subsets (LISS) can be used to shorten the length of the formula while making the solution more dynamic, scalable, maintainable—and…
You may have heard about a model called a Data Hub, but perhaps you aren’t confident that you understand the fundamentals, primary functions, or considerations when architecting one. There are three main advantages to incorporating a Data Hub: Single source of truth : Stores all transactional data from the source system.…
One of the most common questions I get asked is when to use native versions versus using a general list to replicate versions. As is often the case, the answer is: it depends. Let me run through some key areas to help you with the decision. Functionality What functionality do you need? We always advocate using native…
* What is Anaplan Connect? * What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Deep Dive on Integration * Integrating with SAP HANA Cloud * Integrating with Snowflake * Integrating with Azure SQL Database * Integrating with Google Cloud (GCP) BigQuery * Integrating…
We built this app to make getting started on your Anaplan data integration journey simple with a quick questionnaire and helpful information and links. A common question that arises during Anaplan implementations (or even after go-live) is "How can I automate data feeds into and out of Anaplan?" While the ultimate decision…
Hello Anaplan Community! Welcome to the Model Optimization team's monthly blog post. This is our last post in an eight-part series, on the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month,…
Author: Vinay Varadaraj Mirajkar is a Certified Master Anaplanner and Senior Solution Architect at Anaplan. When you think about creating simple workflows or enabling collaboration between/within the planning teams, some of the features which can help achieve this are: sharing pages, card comments, notifications, and last…
I had the opportunity to test a preview of the new database connectors developed by the Anaplan Data Orchestrator (ADO) Team, and I wanted to share my experience with you. To set up the testing environment, I used my AWS account and the RDS service to launch four types of databases: PostgreSQL, MySQL, Microsoft SQL Server,…
Hello! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
Is there a function to change a list value to a text? I want to use the & operator with list values, but it only accepts text. When I try just using the list-formatted line items, I get the error below, so it seems that if I could convert the list selection into text then I'd be fine: The 'text1' argument for the '&'…
Hi! I have this list called Strategic Customer. I have a module based off this list called Strategic Customer Details. the parent hierarchy of this list is Strategic Account Owners. In the module, I have a line item to choose a different Strategic Account Owner for a Strategic Customer. The choose new SAM line item is…
Hi , I have a text formatted line item which is a date .I want to convert it to Date format . I tried to break it into three Year ,Month and day using Value(RIGHT(Line item,4)) Value(Mid(Line item,4,2)) Value(LEFT(line Item,2)) It works for 12/10/2012 but what about 2/3/2012 ?? Note -- Can't change source text to date…
Given how flexible numbered lists are, is there a reason why I should not make all lists in a model 'numbered'?
Hello, I would like to find an app to estimate the size of a model I can't find it on the App Anaplan Agile THank you for your help
Please can someone give the step by step points in an easy way to convert a Ragged Hierarchy to Balanced Hierarchy in Anaplan. Thanks!
Hi! I reckon there are two reports we can ask Anaplan to run for the models to gauge its performance. Wanted to know a bit more about Model Open Analysis and Performance Analysis reports - what do they entail and when should we go for one over the other. Thanks!
It looks like you're new here. Sign in or register to get started.
