Modeling

Nested Dimensions
If we could have 4 nested dimensions, this would enable additional functionality, like JE creation, advanced filtering, etc.
TEXT(ROUND())
Have the TEXT function convert the results of the ROUND function identically.
After logging-in user continues to linked-to model
Annoyance: URL link provided for specific model > user clicks it > user not signed in to Anaplan so taken to log-in screen > after logging-in, user is taken to models dashboard, *does not* continue on to model at original link. All other tools used by me at Anaplan (with the frustrating exception of SFDC) would drop you…
Copy Branch for Selected Line Items
Hi, I have a module with a numbered list. Among the module line items are Submit and Approve boolean, which I use for some kind of worlflow. When I use Copy Branch action to copy a particular numbered list, both booleans are also copied. On the other hand, I just want to copy other line items but the Submit and Approve…
Set up filter to select levels of hierarchy to show
I have three lists all in one hierarchy (L1, L2, and L3). How can I set up a filter using booleans to allow users to select which level of the list they want to see? L1 is parent of L2, and L2 is parent of L3. I'm trying to replicate the functionality of "Select Levels to Show" so that I can set the filter on multiple…
Need to enter data in three currencies and can also view in three currencies
Hi team I have a requirement in a module where User can have option to enter data in three currencies Curr1, Curr2 and Curr3. So when one user entering data by selecting Curr1 from page selector and the next time when another user wants to enter data in some other currency suppose in Curr2, so when second user selecting…
Filter function is limited when there is 3 nested columns in a module
Filter function is limited to a module with 3 nested columns, which resulted the filter not able to get its desired result. It will be great if can remove such limitation for 3 nested columns
Comparing TEXT values
Hi, Very simple task from the looks of it. I have a line item where user (or formula, I don't think it matters) enters text. I want this text be unique, and if it isn't - I want user to know about it. How do I make a check? If it were cells formatted as list members - I can think of a way to compare those, but many…
Count items in a list
Hi, I want to do something that seems simple, i have a list (Complaint list), and it has a field (text) called custRef which is not unique. I am in another module and when a user enters a CustRef (text field) i want to then count how many times that appears in the Complaint list. As the CustRef is not from a list, and just…
How to create a lineitem-dynamic graph and chart basing on a driver lineitem/list
Hi, everyone, I have an requirement from client that users select a standard/method (may be list types) from a drop-down in a lineitem (list formatted), and the graph/charts will automatically change the data items accordingly. Let me put it in more details with some examples. Driver (parameters) Image:…
Data Integration
Data Integration can be a large and complex topic. These lessons will help you get on the road to understanding your integration options. Note: These courses are also part of the Level 3 Model Builder Training available on the Learning Center (learning.anaplan.com). They are provided here as informational only. If you need…
nested ifs
I have the following nested if, for the highlighted line item (see picture): IF NOT 'exclude' AND 'Sum fill rate gallons actuals' > 0 THEN 'Sum fill rate gallons actuals' ELSE IF 'Sum fill rate gallons PY' > 0 THEN 'Sum fill rate gallons PY' ELSE IF 'fill rate gallons FOR movement avg' > 0 THEN 'fill rate gallons FOR…
Can I configure a chart to respect a dynamic Time filter?
I have a chart with Time on the x-axis. The saved view used to create the filter has a filter applied to Time. The initial view published on the dashboard respects the filter. However, when I change the selections in my driving filter, the chart is not updated. See example screenshot below.
Is there a way to use SUM with Rules, such as IF
Sorry for the wall of text, I am attempting to articulate fully what my inquiry is, and due to information privacy, I am using sudo names as place holders. I am attempting to generate a summary module. I am using 2 independant heirchies, with one of the line items/fields in the first heirarchy matches a value in the second…
Unable to export full model to model import error log
Enhance the way that errors are seen within model to model import error logs. . An example of the enhancement - I’ve faced an issue when only first 50000 lines are exported in import error log. I have many duplicates so most of the “errors” are not interesting to me. But since the amount of lines is limited to 50k, I…
Minimum item in a list grouping
Lets say I have a list to map any day in the year to an accounting month, because our accounting months don't always begin or end on calendar month boundaries. Accounting Period Date List (sample) Parent Code Accounting Month ... ... ... ... 5/24/2018 May 18 5/25/2018 May 18 5/26/2018 Jun 18 5/27/2018 Jun 18 ... ... ...…
Reducing Model Size – Introduction to Sparsity
Summary: Unnecessary model size has a large impact on your Anaplan environment from using valuable space to slowing down key processes. Sparsity is one of the biggest causes of inflated models. Understanding what sparsity is and how it impacts a model is the first step in knowing how to reduce it. Course Objectives: By the…
Display the number of cells and Gb when insert a new module
As a model builder i would like to see in the upper right corner off the "insert module" window a field with the number of cells and Gb and the treshold of my workspace. This will be the first alert to avoid to reach the maximum limit of a workspace. This ratio 'size of the module' / ' size of the application' display in…
User List formula to include admins
A description of the enhancement required: Right now in the Anaplan if User List is used as a dimension, all non-admins can see themselves only. As for the admins, they can see all of the users in the dimension. Thus there is no way how to use personal filters (Booleans on user list dimension) for non-admin. Could you,…
User-defined, collapsible groups in Actions / Dashboards / Modules Lists
As a model builder, I would like to be able to create & name my own groups within Actions / Modules / Dashboards lists, as well as collapse those groups I don't want to view at the moment, to help me decluttter the Anaplan screen & better focus on what I'm trying to accomplish at that moment. Additionally, if I perform a…
Mousing-over part of a formula should show its current computed value
Normally when writing code I can troubleshoot my code by stepping through it piece by piece to see where things fall apart. In order to accomplish this in Anaplan i tend to have to create separate line items with pieces of my formula to see how they compute. To help a modelbuilder better troubleshoot formulas without…
Add CTRL + SHIFT + S Hotkey to search in Module / Dashboard / Actions Lists
Just like searching in a published module on a dashboard, for consistency when model building, I would like to be able to hit the same CTRL+SHIFT+S hotkey when looking through the list of modules / actions / dashboards etc. to quickly search, instead of having to manually click the search button.
SELECT unavailable
I have come across an issue where a line item is dependent on dimensions not part of the Module makeup, I would like to use the 2021 by month line item in a new summary module but seem to be forced to add in Reinvestment Group as a dimension where in reality I want only the top level view summarised only by GL account cost…
Using No data line item to enter comments (Admin)
Hi, a short tip ad trick to document the blueprint. I use No Data Line items, hidden in dashboard, to define distinct /homogenous chapter / parts in the blueprint. No Data line item are supposed to be No data, and they are, BUT you can nevertheless enter a formula in them. I use this feature to enter a text formula which…
How we can concatenate two number line items?
I have got two number line items as shown below. LineItem1 , LineItem2 , Result 1 2 1(2) 3 4 3(4) 7 10 7(10) I want to get the result as shown above for the two line items. Ideally i need a concatinated value. Could you please assist me in achieving the same in Anaplan.
Group option in RANK Function
Hi, I have a module with 3 or more lists, and Value and Rank line item. I want to rank Value for each combination of items in those 3 lists. However, I find that RANK function can only accommodate 1 list in the Group option. How can this be done? Regards, Andre
Schedule Module as Report
Beginner Question: Is there a functionality to schedule the export of the current view of a module to a specified user?
Ruler in design mode
Hi everyone, I think it would be useful to have a ruler on the top of the window in dashboard design mode. that ruler would help us positionning dashboard differents elements and make dashboard designing easier and fun. have a nice day Regards Patrick
Single Sign On(SSO) with new workflow method
Hi everyone, A question about how SSO works with new workflow method - since the new workflow method will enable an automatic notification email which contains the URL linking to the dashboards that the users need to update, how does it work with SSO? For instance, if an user doesn't have Anaplan logged in at the moment,…
Dynamic Cell Access or line items with formula
I have a module with imported data. Some line items need to be editable and some do not. to make a line item not editable It seems there are two ways to do this... 1. create extra line item that references, and then hide the line item i don't want to be editable 2. use dynamic cell access I'm wondering folks opinions of…

Modeling

Discussion List