-
Circular References - CUMULATE
Hi, Anaplan is returning a circular reference eroor in the following circumstance (below are the line items - simplified); 1. Opening balance 2. Variable that depends on opening balance (1) 3. Cumulate of 2 4. Closing balance (sum of 1 & 3) - circular reference error message. Any ideas how this can be resolved? If I manage…
-
Include data changes by actions in model history
Description of enhancement requested: Capture all before/after values in history - show what values were before and after for all changes, even if executed by an action How would this help the business process: Administratrators use this information to see what specifically was changed
-
Import Mapping
Hello, please see the attached screenshot: can anybody give me a hint why the "automatic" mapping does not work thought the strings are equal? (None of the pairs do...) Kind regards, David Mandl
-
Hide models I don't wan to see
There are a ton of models on my list everytime I log into Anaplan. I would like to hide the ones I do not care to see. I know I can mark favorites and sort them, but I just don't need a zillion other models on my list. It's messy. Is this going to change with the new UI?
-
How to Apply two dimensions
I'm creating a scenario model which is based on two measures. I'd like my model to only apply a specific forecasted % to a row, if the measure is "total company" and profit share measure "Construction". However, I cant use the NESTED IF function which I would use in excel as its not letting me use multiple items on the…
-
Can anyone provide me an explanation of how calculation of numbers with decimals is being done?
I have been trying to sum up the decimal numbers in "Data" column , the column "indicator" is converting individual values from "Data" column into Text whereas "Bool" is converting the Summary of "Data" into text. Can anyone provide me with an explanation why I am getting a lesser value in Bool ?
-
Time List
Hi, I'm using week calendar type & using 4-4-5 for week grouping into months/qtrs in the model. So whenever i used month as a time scale in a particular module and tried to use month() function, it's showing peculiar values, as shown in the attached screenshots. Can anybody tell a workaround to fix this.
-
Date Formula
Hi, I need to get the number of days spent to finish a task. What I have is "Date Start" and "Date End", currently, in excel its a simple Date End minus Date Start and it will give the number of days spent. I tried to convert date to text or number, but it doesn't convert it that way. How can I do this in Anaplan? Big…
-
Calculation of MODE in Anaplan
Does anyone know how to obtain the MODE of a set of values (in Anaplan)? For example, lets say I have a list of employees and each employee has a salary. I'd like to find the salary that occurs most often in a group (i.e. the MODE). Working with MODE in Excel, there will be times when a MODE value doesn't exist (because…
-
Order of subsets in applies to should respect order in general lists
Detail description of the enhancement that is being requested: There is a current inconsistency between the order subsets are shown in the applies to dialog and the order in the general lists screen The order subsets are shown in the applies to reflects the order in which the main lists were created, not the current order…
-
Time where a value is max
Hi, guys What I am trying to acheive is pretty simple as in the attached file. I would like to identify a month where "sales" is maxium among "TIME" dimension(Jan 2018 to Dec 2018) Any pointers? Thanks in advance Greg
-
Diagonal sums over flat list dimension on Anaplan
Hello, To put the problem simply, I need to know how to do the diagonal sums of an array in Anaplan. To explain in detail: I have a module called "Daily Matrix". It has the dimensions: Time, Days after Registration (a List, that "Applies to" the entire module), and one of the line items in this module is a "Daily Rate %"…
-
Anaplan Connect 1.4 Null pointer exceptions
I am getting NullPointerException errors from Anaplan Connect when I include -process -execute instructions. I started from the example.sh script. The process runs two Import actions that import from the same file, first into a List and then into a Module. Here is my script: #!/bin/sh # This example uploads a file and runs…
-
Allow list imports to retain the order of the list items in the source file or source module.
Description of the enhancement required: Allow list imports to retain the order of the list items in the source file or source module. An example of the enhancement: When importing to a list, the list should reflect the position of new members of the list as it does in the source file (or module) instead of adding new…
-
Best practice for Organisation Hierarchy in Matrix Style Business
Hi, My company uses a matrix style hierarchy where we look at client and country on separate dimensions as per the below image. I'd like to recreate this view in Anaplan (without the sparsity). Where client leads can see their client across all countries, and country leads can view their country across all clients. I'm…
-
Limiting on time selection
Have a module for marketing deals that have start and end dates inputted as weeks (eg W/e 19 Jan 2018), but whenever somone loads a new deal this defaults to the first week in the model, in this instance it's the start of 2016 which means a lot of scrolling / typing in the right date. Is there a way to have the drop-down…
-
Do not count null cell values when creating modules
Hi, I would like to suggest you do not count null cell values when creating modules.
-
MAILTO should also use list formatted line item as a parameter
Currently MAILTO function does not work when there is a parameter (To,CC,BCC) with list formatted line item to select which email ID to select for email notifiaction. Currently either it must be text formated or hardcoded in the MAILTO formula.End user should be able to select the given list of approvers if there is a…
-
Partioned Dashboard Elements
BLUF: Different users require minor variations to dashboards - due to the complex structure of the underlying data sometimes it would be beneficial to compartmentalise simple elements of the dashboard so they are only linked to whatever visual elements are displayed. E.g. * Recently we have been asked to provide an update…
-
Time Dependent Hierarchies
Hi, I would like to have time dependent hierachies for financial consolidation purposes. It would help us when we have changes on the ownership structure from one month to other.
-
More granular forumula scope for versions
Description of enhancement: Ability to set formula scope for selected versions rather than just the limited options of All/Actual/All except Actual/Current. Business case: This would give us the ability to control what versions applied to a given formula. Would allow us to create snapshots. Would allow us to work in two…
-
Make Users List import available for Deployed Mode Models
Description of the enhancement required: It should work in the same way as for Standard model, could you please make available Users List import for Deployed Mode Models? Currently user access settings can be amended manually only. A story for why they want the enhancement: We have one list which includes 10596 items. This…
-
Hide column time members without using Filter
Hi Experts, I am new to ANAPLAN.Please kindly suggest me .How to solve the below requirement The Requirement is like as followes, They are three Versions 1)Actual 2)Plan 3)Forecaste. I Developed Filter module.In Filter module we have plan,forecaste list items. user select plan version If Plan list item is 1 those columns…
-
Anaplan Certification Types
Hello Friends, Can someone help me about what types of Anaplan Certifications are available? Are all of them chargeable? And what is the minimum cost for any Anaplan certification? Thank You. Regards, Sammy.
-
Values from multiple line items into one line item split by a dimension
Not sure if this is possible. I have multiple line spread across multiple modules. I want to be able to bring all the values into one line item in a seperate module which it split by a dimension reprenting each of the unique line items. So I have: Module 1 with Line Item A Module 2 with Line Item B I want Module 3 with…
-
How to override columns without using filter
How to override columns without using filter
-
How to hide column using formula
How to hide columns using formula and which formula to use. For example, if my column value is equal to 0, it should automtically hide those columns and if cell value if equal to 1 then it should display the values of that column.
-
Ability to set different summary options for each list a line item applies to
Currently, at a line item level, it is possible to set a specific summary option for Time. It would be beneficial in terms of space and performance to be able to do so for each list a line item applies to. For example, we often have a list called "scenario" with a top level item so that we can create scenarii by "copy…
-
Changing Current year
Hi, I am working for a client for which we need to change the current year in time settings from 2018 to 2019. We have one future year and one prior year in the settings. I want to know whether updating the year will impact any structure of modules, reports, live model synchroisation etc.? or I am good to change the…
-
SUM Question...
I need a hand on this, should be something easy, hopefully someone can help me. I have a LIST of 62 items (Products) These products has their transactional data in another LIST. I have a Module A with 4 categories of these items. 2 Categories are coming as they are in the Product List, the other 2 are determined based on…