-
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…
-
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…
-
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?