Modeling

Mapping on Codes
Allow for mapping on codes in a list that is not numbered.
Maintain Flat File Mapping in Copied Models & Model Mappings
When we move models from workspace to workspace, the Anaplan model to model connections remain intact, but all flat files need to be reuploaded and mapped. This causes a large amount of work per model that we move. Adding this feature would make the workspace governance process run much more smoothly.
Automatic Sum in Drilldown View
Ability to select multiple cells in a drill down window and see the sum on the back end, as you can on a dashboard.
Boolean Format Options
When boolean is selected as a line item format, there should be an option to have single or multiple selections allowed. Currently, the default is to allow multiple selections. For instance, for single-selection, once one line item has been checked, all of the other line items have a greyed out checkbox that cannot be…
Sorting Users in Anaplan
Hi Guys Does anyone know a way to sort users in anaplan . I am talking about the User setup / Access Area . I don't want to delete users and re-add sorted lists as it will generate email notifications to users . Cheers
Referencing Model Calendar in Formula
Hi all, I am trying to see if there is a way to reference the model calendar in a formula. I want to return the fiscal year that the week is in. e.g Week 1 FY19 Result would be FY19 The intention is to use this to lookup other data, E.g IF Fiscal year = FYxx then... I have a Timing - Calendar Module (screenshot below) if…
How to read only 8 previous months data of current month.
Hi, I have created a master time dimension setting module where my current month(Boolean line item) is selected as June 18. I want all the 8 previous months value to be read by a second line item from an input module(second module having data for all period) Amount(line item) should have the values of only 8 previous month…
Getting data by line item into a dimension and generalising a complex formula
I want to calculate some values in my "Forecast" using a formula that is almost the same for each value. The only difference is that each row in the "Forecast" module gets an initial seed value from a different line item in the "Base Data" module. The formula I want to use is actually a lot more complicated than shown in…
Using different versions in formula
Hi, I'm trying to create a formula that has 2 different views of forecasts. My current and my previous. Current is pulling in fine. Struggling to create a formula that says Fcst V2 = Previous months Forecast. So if Current forecast is p4. I want my FCST V2 to equal my p3 Current forecast.
How to add a header name in module grid view
Hi Experts, I want to know how to add a header name in module grid view. As shown in the red circle in the picture. Or, I want to export this spreadsheet, so header name only in export is also welcomed. thanks in advance. Regards, Tsuyoshi
If statement not reading periods prior to forecast start
Hi All, I was wondering if someone could help with below. if statement not reading dates prior to forecast start period. Forecast start period is Mar -19 Below should return 0 rather than Mar -19, why is the if statement not reading the first part of the statement? What do I need to change to get it to work? IF…
Right-Click on an applied filter ---> take me to the module
When Opening a filter, It would be really helpful if I saw a filter I wanted to dig further into and be able to right-click and open the module it's coming from. Currently a user has to back out of the filter view, and go there manually. When there are a few filters I have to screenshot this view temporarily because I…
Don't block manual input if a line item doesn't contain all dimensions of the module
Example: We have a model that is based on dimension A and months and contains 2 line items: -Line item 1 (manual input): applies only to dimension A -Line item 2 (has a formula): applies to dimension A and months If we publish this module to a dashboard with month as page selector, it is not possible to change the value of…
Right-click a part in a formula ---> take me to that module / List / etc.
Similar to some other feature requests I've made... 1. Open From Drill Down (delivered) 2. Open From Filter View it would help model building workflow if I could right-click a module or list that appears in a formula and it give me the option to open the module, or show the list. Again, this is so I don't have to leave…
Add a tab for saved module views in Model Settings -> Modules
Description of enhancement: To add List of modules' views in the Model Settings menu. It would be great if it can include: View name Model name Actions’ names then view is used as a source Dashboards where used An example of the enhancement: It may be very similar with the Modules list. A story for why they want the…
Custom Filter
Hi Experts, I have a requirement.i am confusing how to resolve this kindly help on this. In One module Row Axis - Product and Customer lists Column axis - Lime Item and time lists Page Axis - Measure list There are 5 line items. For each line item i want to saw different time periods that also based on user selection. For…
Equivalent to LOOKUP Function but for a Text formated Line Item?
Hi All, I have an Import Module which has a Number and a Text Line Item. I have created another module with the Dimensions Provided Service and Cost Centre and in the Import Module created List fomatted Line Items for those 2 Dimension. I have successfully pulled across the Number formatted Line item from the Import Module…
SUM on non-shared Dimensionality
Hi, I have a Target module which is Dimensionalised by Line Items and Time and a Source module which is dimensionalised by a numbered list and 3 line items (1 is direct input and 2 are List Formatted (1 being Time, 1 being Line Item Sub-set of the Target module Line Items) In my Target module I wish to return the Direct…
Time Formatted Line Item - Custom Time Range
Hi, Is there a way to use Custom Time Ranges when creating a Time Period formatted Line Item? I wish to display only a certain number of periods as a selection option but currently all periods are the default Many thanks Mark
Extend the number of future years
For the purpose of calculating lease contracts in IFRS 16 it's sometimes needed to have wide time ranges in the model. Currently, the amount of future years is limited up to 50 years and past years up to 20 years (link). This means you have a maximum time range of 70 years. We experience that some lease contracts extend 70…
Consolidated Module (with list output type to combine)
Hi, I have 3 modules, all sharing the same dimensions (period, transaction# and employee list). The first 2 modules contains line item "metric" both with output type list (same list), I need to see all the data in all line items of module 1 and module 2 - it should be consolidated in module 3. In module 3, it has the same…
How to relate items to list
Hi experts I have problem in importing data. The picture is sample of failure. I want to relate specific employee under regions. How to do this in 1 step? thanks in advance. tsuyoshi
5 Steps to Become a Successful Solution Architect
Learning something new can be intimidating and overwhelming, and learning the ins-and-outs of Anaplan is certainly no different. Lists? Line items? I thought this was just like Excel, so why are all the formulas different? Like most new endeavors, there’s a learning curve with Anaplan. Once you have taken the first small…
Error when importing to a module with new line items
Hi, We have some intermittent issues with import actions that give up the following error (in pic) The target module had a new line item introduced which was on a subset of the same list as the entire module. The module was based on Subset 1 (applies to). The new line item was based on Subset 2 (applies to). Subset 1 and…
Pre-emptive alert for Anaplan function constraints based on total number of cells to be processed
A pre-emptive alert for Anaplan function constraints based on the total number of cells to be processed would be useful to detect issues early in the ALM data transfer process avoiding the synchronization unproductive time until the error or warning message regarding the same kind of effect pops up.
Look for similar Item
Good day! May I ask for any ideas how can I execute a search for similar items from a list. I have a list of stores with several properties such as type, target market, population of location etc. and if I add a new store, I want to assocoate the new store to an existing store with the similar or nearly the same…
Job scheduling optimiser user case
Hi, Has the Anaplan optimiser been succesfully used for a job scheduling problem? Objective is to minimise the time taken to complete a set of jobs. Constraints are: 1) We have a list of resources who can each supply a maximum amount of time per time period. i.e. Time spent by resource A in period X <= Time available for…
Upload modules into new model new workspace
Hello Mates, I have exported (csv) my 10 modules from my model 1. This model 1 is in workspace 1. Now i want to copy/.upload all these 10 modules (with formula, format, summary..etc..) in different model which is in different workspace. But there is no import option available. Simply, i want to replicate my work in…
Display selected item from a list for input and calculations
I developed an module displaying Rep, Customer and product. This required to enable planning to be done at Rep Level, Customer and Product levels. This will be used to input unit volumes per product / customer and Rep The easy way would be to have the total product list but each Rep are responsible for selected product and…
Filter w.r.t Different user access
I applied a filter on a module in a dashboard based on a boolean formatted line item. The filter works fine for one access. But when we switch to another access but with the same role, the filter doesn't work for that module though the "filter" option shows that the filter is applied. To make it work, we delete the rule…

Modeling

Discussion List