Modeling
Discussion List
-
Collecting the value of a parent list in calculations
Hi, I want to collect the value on the parent membrer for the employees list of my source line item to calculate my target one I did an example like this one target_lineitem=source_lineitem[SELECT: Employees.PARENT(ITEM(Employees))] but it doesn't work can someone help me.
-
Delete Bottom Level of a Composite Hierarchy
I have 3 lists and 2 of them have parent hierarchies. The first list and the top level is organization. The second list is cost centers, which has organization as its parent hierarchy. The third list is employees, which has cost centers as its parent hierarchy. If I want to refresh my employee list, deleting all existing…
-
"Select All" for Boolean
If I have a Property on a list or a line item that is Boolean formatted, is there a way to "select all" of the items?
-
Single module, multiple modules?
When should I break apart a big module into smaller modules? What's the cut off in terms of dimensionality and logical design?
-
Always Show "Current Version" When Opening a Module
In order to get your model to always open on the version you have marked as the Current Version, when you save the module view as the default view, you need to uncheck the box "Always open on current page" and the current version will always be the default.
-
Show current value for 'Day' timescale
A model I developed had KPI daily values loading from an external data source The challenge I had when working with the day timescale was the size of the time dimension (being days) and finding the 'current' day (most recent load) To resolve here is what to do:[list=1] * Create a list that is the 'load date', update this…
-
Rank function on LineItem Subset
I have a module containing: - timescale - versions - 1 list (offices) - lineitem subset based on PNL module - 2 lineitems (1 = collect(), 2 = rank(1)) I need to rank every PNL values independently and need help with formula or approach to do it Now by default - Rank function set rank for all values - e.g it compare values…
-
Limit on selections
Is there a limit to columns or rows I can use in selections? How many can I select and hide at the same time?
-
Refresh data in a module
How do I refresh the data in a module without refreshing the whole browser?
-
Can you Lock a Model?
Can you lock a model in Anaplan?
-
How do I do a daily switchover?
I know that in the versions section of Settings, I set a switchover date which has a 'month' default. But, what if I want to do a switchover in amodule by day? In other words, if I roll forward a day, how do I get my forecast version to display actual and forecast for the year, by day, up to the switchover?
-
Line item reference
I have a currency module containing Line Items, Time and Version with the line items as currency codes and the values as exchange rates. This has Line items as rows, Time as columns and Version as a page. I have a details module that contains amounts in local currency and a currency indicator. In another module I want to…
-
Module name
If I change the name of my module does it have an impact on entered data?
-
How do I sum across dimensions other than time?
Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products against every product. Beyond allocation use, is there a way to introduce a line item that returns the value at the next level up a…
-
End Users Creating Subsidiary View
Can an end user change the blueprint to create a subsidiary view?
-
How far does History go?
Does the Anaplan Platform keep ALL history for a model back as far as when it was first created?
-
Using Model Restore with Other Platform Users
If I go to the history and restore, will it just restore my changes, or will it wipe out the work that other users have done all day?
-
How to use a drop-down list within the PROFILE function
Hi - struggling to get my head around this. Not sure if I'm getting the syntax wrong, or whether what I'm trying to do simply isn't possible. I want the model user to be able to make a selection in a drop-down list from a number of different allocation profiles to use in the PROFILE function. To hold the different…
-
Create Subtotal of Existing Line Items
How do I make an existing line item a subtotal of other line items? Line items below: - Opening Stock - Purchases - Issue of Stock - Closing Stock Formula should be: Opening Stock + Purchases + Issue of Stock = Closing Stock
Upcoming Events
-
Streamlining business processes with Workflow
Join Anaplan experts for a practical deep dive into how Anaplan Workflow helps organizations streamline business processes, eliminate operational bottlenecks, and automate planning approvals at scale. This session will explore how structured workflows direct stakeholders to the right task at the right time, helping…
-
Community Challenge Recap: Enhanced board layouts
Join us for our Community Challenge Recap where we'll dive into the creative and innovative ways members are using the enhanced board layout features. Our guest host, Anaplan's Platform Adoption Specialist, Seb McMillan, will showcase the best submissions from September’s Community UX Challenge. This is your opportunity to…
-
User Experience Design Thinking
The quality of the User Experience is crucial for the successful deployment of your Anaplan applications Whether designing a new application or re-imagining an existing one, the approach you take can make the difference between an OK experience for your users and a great one. Join Anaplan experts for a deep dive into how…
-
Anaplan Quarterly Customer Platform Release
Anaplan's next quarterly platform release webinar will be held October 28, 2026 at 8:00 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience! Our expert-led session will equip you with live demonstrations to help you get the most out of new features and…