Modeling

Referring Property values of one List from another List
Hi Team, I am trying to pull the values to my numbered list property from another flat list property. Here L1 and L2 are my lists and A, B, C are my properties as below. I need to pull data to property B (text or list formatted) from property C. L1 (numbered list)A (list formatted to L2)B L2 (flat list)C (list formatted )…
A Good Plan: Ownership Leads to Accountability
From the very moment an organization decides to implement Anaplan, it is imperative that it starts building the foundation for ownership of the solution from the beginning of requirements gathering to the end of user acceptance testing (UAT). When this is done successfully, clients feel confident in the solution and…
Ability to Set a Character Limit in a Text Field
In certain cases the Name of something that goes into a report can only be so long before it starts to conflict and overlap with something else and make the report unreadable. In other cases the user is expected to be concise and not write a whole dissertation to name something or. I'd like to be able to set a numerical…
LAG function constraints don't allow for some valid scenarios
I would like to submit an enhancement request for the LAG function to be used between time ranges that are not the same but have valid overlap. The constraint that disallows the use of LAG between any line items that do not have the same time range gives the function minimal utility. I understand disallowing instances…
Smart Sheet Add-In
Hi Anaplan, It would be great if Anaplan developed a Smart Sheet Add-In. This is a great alternative to presenting data in excel due to browser based flexibility and functionality of Smart Sheet. Thanks, Usman
The Anaplan Way - Badges
Hi , I have already completed The Anaplan Way. what is the process to get add "the Anaplan way" badges in my profile. Thanks, Ramjee
Option to Right-Click action button ---> take me to that action in the Actions List
As a model builder, I would like to be able to get from a dashboard button directly to the action in the Actions list. It would be really helpful to have a right-click "Open in Action List" option somewhat equivalent to a module's "open source" module option but for actions. This would be a far better than the current…
Ability to show column-specific tooltips when mousing over a table on a dashboard
Some dashboards end up with large tables with lots of columns shown. It is normal that some of these columns may need a few notes to help a user understand its purpose / intended interactions etc. Currently I use an instructional text box at the top, but this can be very long, hard to read, and frankly overwhelming amount…
New Line Items in source Modules, within Saved Views, should be hidden by default.
Current behavior: Create a Saved View within a Module, navigate to that Saved View, publish to a dashboard. Then, close the Saved View and add a new Line Item within that same Module. You will find that the newly created line item is present in the published Module Saved View. Requested behavior: Module Saved Views would…
Remapping Line Items between Modules
Is there a best practice way to remap line items between modules? What I mean by this is taking a set of line items from a module and remapping them to another set of line items in a module, as per the screenshot below? My use case for this would be to summarise P&L lines or to reclassify line P&L lines into a different…
Date Format conversion
I have a module in Anaplan whose one line item is date formatted. I imported a csv file which is having a date column with the format MM-DD-YYYY. The import results showed a failed report becasue it accepts date format as MM/DD/YYYY. Is there any way to map my csv file having the abovementioned format with the date…
Line Item Date Format
Hi, I am developing a model in India and the client is from US. I created a line item 'Creation date and gave formate date where they can select particular date from the drop down. The format of the date is DD/MM/YYYY. But client wants it in MM/DD/YYYY. Can we do it directly? I know a work around of making it text and just…
review query 299
Hi, Can people in one region can book a slot for other region for 299 model review? for examaple, india consultants can they book review in emea or americas?
Import of partial list
Hi All, Is there any way i can import a part of list into a model from a huge list from another model?
Linking a set date to a specific time range
I spend the last 2 days trying to dynamically linked a specific date (specified by a user) I created a module to have visible the versions, country and initiatives (as my lists) and of course the line cost items and calculate the monthly charge per cost line item per costing type based on the elapse time between start and…
API Usage Limits
Does anyone know what the Usage Limits are for the Anaplan APIs? Also, is there any max of concurrent calls for the available APIs?
Add a "Close all Other Tabs" option to the right click menu
When building in Anaplan, it is common to find a LOT of tabs open. Currently right-clicking on a tab in Anaplan a user is presented with the "Undock, Close, Close All" options. It would be really helpful to have an option to "Close All Other Tabs", which would close all, except it would leave open the one I currently have…
Optimizer on rearranging Applies To for optimal performance
In our current models we have been struggling with performance. 1 big impact is the arranging of applies to. It would be great if we have an optimizer that could determine the optimal Applies to for the performance of a given model. This is based a certain constraints from what i understand 1: Size of given list 2: Arrange…
Right-click to Add / Delete line items in a module
Excel's handling of adding / removing rows is very natural feeling. Sure you can go into the ribbon bar and find the button, but that's much slower and breaks one's workflow more easily than simply right-clicking on a row and selecting "Insert" or "Delete" In Anaplan, adding / removing a line item item are ONLY available…
Dependent Dropdowns - Many to Many
Is there a way to enable a many-to-many relationship on dependent dropdowns? If so, how do you do this? To provide some context, I have two lists: * Departments * Employees Employees can belong to many departments. (Currently have a module which assigns employees to departments using two dimensions, employees and…
Delete multiple items/rows from list.(more than 5000)
Hello Members, I wanted to delete more than 5000 rows(nearly all) from an independent numbered list but at the same time wants to save the list and its properties. If we delete any items/row from the list containing more than 5000 rows, it says to select and delete and by this only one is getting selected and not more than…
Advanced Search: Allow use of Boolean Operators etc. in model search
I use the search functionality in Anaplan a lot because otherwise it's difficult to find things. It would be helpful to use operators (like in a google search) to find things. Here's an example: Pretend I have a dashboard named "David's XYZ Extravagant Dashboard - Cost Sheet" When searching, if I miss a single character…
Option to allow the system to automatically set the datatype for a line item
It would be really helpful to me when building complex formulas if I could build it up in pieces without creating lots of line items to do so. Ideally I could build it in pieces without getting plagued with "wrong data type" errors. I'd like the option to let the system adjust the datatype for me instead of just rejecting…
displaying numbers instead of names
I don't no why it has been changed suddenly , i didn't make any changes. Can you say me what is the problem? @DavidSmith
Converting data between line items with different lists
An important factor of Anaplan is transforming data between dimensions of modules and line items. For example, if I wanted to convert my sales amounts, which are currently stored by employee and product, to a summarized level of sales region and product, I’d need to do a conversion to summarize the data assuming sales…
Lookup on Parent Elements
Got the idea I'm trying from here: https://community.anaplan.com/t5/Anaplan-Discussions/Lookup-on-Parent-elements/m-p/1478#M2397. But, we needed to change it up a bit as I need it to be user specific but it's not working. I created a very simplified version of what we are trying to do on a larger scale. I started with a…
Filter on the basis of selective access
Hi Team, In a module there is a list formatted line item(List is having selective access). Suppose the list has the members L1,L2,L3,L4,L5.... And in the module at list formatted line item records having above list members. I want to filter the data on the basis of selective access. A user having access on L1, L2,L3 can…
Sumif quantity between two dates without time dimension
Here is my problem, I have two different modules without timescale or dimension. One module has quantity and dates. Second module has start date and end date and I would like to sumif within the range of the start and end dates. Please guide me if there is a way to solve this.
Bespoke 4-4-5 / 4-5-4 Calendar
Hi, My client want to recreate their bespoke calendar in Anaplan. It is two quarters of 5-4-4, followed by one quarter of 4-5-4 and another quarter of 5-4-4. See below: Does anyone know if this is possible or is dummy time the best option here? Many thanks, Matt
Input at multiple levels and view the Roll-up
Hey Experts! Well, this is something really 'Out of the Box' ask from one of our requirements. And upon first look, I really think that It's kinda out of scope of anaplan. Here's the ask: So if you have a look at the below snap, we tried to replicate a part of our existing Sales hierarchy : Let's say that in one of our…

Modeling

Discussion List