Modeling

Master Data based on Scenarios
Hi Can I know how to change master data based on scenarios ? Example I have Regions List consisting of 3 regions and Scenarios list having 3 scenarios (Base Scenario , Scenario1 , Scenario2 ). The data related to these 3 regions should be base Scenario and in future if I add another region the data related to these 4…
Allow un-balanced hierarchies on composite hierarchies for child hierarchies
As a model builder, I would like to be able to add "parent" elements into the child hierarchies (Level 2, 3, etc.). As for now, in a child hierarchy is allowed only to add leaves elements (elements without children) because as "parent" are allowed to be set only elements from the parent hierarchy. As for now, the unbalance…
What is the Longest Model Time Range You've Used?
If you feel comfortable, try include: * Model time range (actuals + forecast periods) * Industry * Usage Mine is: - Model time range: 2 years actuals + 10 years forecast - REIT - PB&F
Creating an As-Of Version
Hi, I was wondering if users can create an as-of version in Anaplan. Thanks in Advance, Daniel
How to model annual inflation in Anaplan?
Hi Anaplan Modeling Experts, I found it is not that straightforward to play with timeseries data in Anaplan, when the calculation logic for a specific item is referring to the values of itself from the previous period. In this example, I am trying to model the annual inflation rates. In Excel, it is quite easy, just type…
List Formatted Line Item Selective Access
I am requesting the ability to control if a user can copy/paste into a list formatted line item cell with selective access enabled. Currently, model builders can restrict a list formatted line item drop-down to only show list members for which a user has selective access. However, this restriction is easily violated by…
Notes Availability in the New UX
When you build an Anaplan model you can add notes to Modules, Lists and Line Items amongst other things. I would like to have the option in the New UX to be able to pull these notes forward and display them as informational messages in the Pages in the same way that you can currently add information to an object.
Roll up blank children into parent list?
Hi all, I'm working on an incarnation of a the Anaplan Agile app, where we track user stories in a list and those roll up into epics in a parent list. In my user story module, the user stories can be tagged with a status (not started / in progress / complete / removed), or that cell can be left blank by the end user. In my…
Option to pick a separator, when using TEXTLIST as "Result = Source[TEXTLIST: Mapping]"
Good to give user the ability to pick or type a separator instead of default comma, as there might be commas in the orginal text strings already.
Import data to a module, best practice?
Hello, I have the following data: Name/Formula/Format/Notes Transaction # /CODE(ITEM(# Transactions))/Text/(# Transactions is the numbered list I created with Properties of Account (Text Format), Cost Center (Text Format), Cost Pool (Text Format), Amount (Number Format), Version (Text Format), Period Text Format) Cost…
Meeting Invite Through Anaplan
Hi Can we schedule a Meeting invite into our mail calendar through Anaplan? Thanks Tejaswini
Comparing two modules
Hi - Because of a unique use case, we had to create two modules with similar information except a couple of columns. I want to compare if the data is correct in the new model. Can you please suggest on how I can do this ? Sunl
Platform for new users
Hi All, Recently, have started exploring the Anaplan, can someone please let me know how I get a platform to test and explore options. I want a platform to work on my ideas.
Boolean Formula - Match line item with date to date on column i.e. item(time)
Hi, I am trying to write a boolean formula that will create the check mark where the formula finds a match between another line item containing a date and the calendar date on my columns, i.e. item(time). Attached are my current views and what I am trying to accomplish. Can someone please help me write this formula? I do…
ALM and History changes
I accidentally make an error and realize it instantly. So alter it back to the previous one. My history gets saved. Now I archive the model and later change it to standard one. Will Tenant Admin still be able to pull the history?
Allow for users to breakback on time and not other hierarchies
I have a customer who wants to use breakback for time but not the other hierarchies in the module. They are planning for cost centers and require users to enter data at the lowest level. However, they want to enter data for annual periods and break back to the months. If we can separate the other hierarchies from time,…
Save Charts as 'Saved View' on modules
Hi Anaplan, It would be great if Anaplan had the ability to save charts to the 'saved views' on modules. Allowing users to re publish and edit charts without having to recreate the chart each time. Thanks, Usman
Delta load for Numbered lists
How to implement Delta load for Numbered lists in Anaplan ?
Fake to Real Timescale
I am trying to map a fake time list (months) to the real months timescale so that I can create a time filter off of the real timescale for the fake timescale. What would be the best way to do that? The fake months list has the same format at the real one does (MMM YY).
Internal Learning on Demand
Hi - does anyone know if the Anaplan Learning Center is compatible with Learning on Demand Platforms (i.e. Cornerstone (CSOD))? I'd like to be able to track enrollment and group with other internal on-boarding trainings. Thanks!
How to flag a period using boolean?
I have 12 months worth of data, but only want to flag Aug-Dec. I can't do it by checking all the boxes as there are over the 10k limit, so I'm trying to develop a formula where it essentially says, if period > July, true else false... Any ideas on how to easily accomplish that?
How to "do nothing"?
I have a situation where if a given condition is met I want to take action, but if it is not met, I don't want to do anything. The line item is of type number and setting it to 0 is not a viable option for the ELSE side. So how can I code "do nothing"? Thanks in advance!
Anaplan way course los angeles
Is there an Anaplan way course on-demand or available in Los Angeles area? I'm working on level 1 and level 2 model builder but was hoping to get model builder certification. The Anaplan way course seems to be a requirement but I only find classes in SF, London, Singapore. Thanks Jason
Creating an Automated E-mail Job for Anaplan Data Outputs
Overview E-mail functionality to send automated notifications and data outputs can be achieved for Anaplan Customers utilizing Anaplan Connect. This is a solution that utilizes a portion of the error handling script found on community…
Set Display Name in Line Item Subsets
I would like the ability to (optionally) set a separate Display Name for line items in Line Item Subsets. Whenever the Line Item Subset is used, this Display Name should show instead of the original names of the included line items. This would be really useful when collecting line items from multiple modules, especially…
Level II Sprint III Model
Please suggest a Link from where I can download the FP&A Model.
History information seeking
Hi Friends, Any lights on how is ID values generated? It is sequential but why it starts with 200? I hope it's not year.
Create Technical Names for an Application
When you create an application it is often the case that you create a User Friendly name which is fine however when you then create any imports using this as a source the description will include this name and I always find myself having to edit the name by abbreviating the name of the application so for instance Data Hub…
Looping in Anaplan
How to apply this formula in anaplan ? CF Inc/dec in Receivables = (@PRIOR(Customer Accounts Receivable)+@PRIOR(Other Receivables)-@PRIOR(Accounts Payable - Intercompany))- ((Customer Accounts Receivable)+(Other Receivables)-(Accounts Payable - Intercompany))-CF Inc/dec in Receivables
Limitations on data load
Is there any limit on data load? i.e. If the data is importing from CSV, What could be the maximum size of the CSV File?

Modeling

Discussion List