Modeling

To save records in the module, some kind of archiving within the model not the actual archiving.
So I am developing a model where I need to save the same module with different versions of it. Basically, I wish to make some changes and save it and someone else also should be able to make the changes and see it. I want to capture these modules with the changes made for the future reference.
Lookup in Anaplan but with different dimensions
Hi Everyone, I have 2 modules: The first being 'Module - Calculate' with 2 dimensions: 'Site and Services' and Time. It has 2 line items, number of days and total cost. The second 'Module - Rate Table' with 2 dimensions: 'Site' and 'Numbers'. It has 2 line items, number of days and Rate. Reason for separating the Rate…
Updated forecast version based on updated Actuals
Hi, I need some modeling suggestions on the following task. I am new to Anaplan versions and would appreciate your help. There is a demand forecasting module (Demand) subject to Actual and Forecast versions. Let us assume the only line item here is Demand.Units. The forecast values are for future timeperiods and are based…
Circular references Cash flow planning
Hello! The model that I’m building for the client includes circular reference. I need to calculate the amount of the loans and net debt that depend on the Free cash flow sum for the period. Free cash flow at the same time includes interests paid, that is calculated for the net debt. When i'm changing any parametrs that…
Merged: Native User Subsets
This discussion has been merged.
Standard lineitem format for each module (different from number)
We would like to have an option to set a standard line item format for each model / module. It would be nice if we could set a standard lineitem format for each module, so we can differ from the current standard of number formatted lineitems. For example, in my access driver module, I would like to have a standard boolean…
how to add new member in a list (not numbered) from a dashboard
Hi Experts, I have to create a dashboard and use it to update an list. New members will be added in the dasboard which will add member in the list. This list is not a numbered so i cannot use create button. I have manage to udpdate the list properties via import but cant figure out how a new member would get created or…
Front door SDP Launch pad Customer display
On frontdoor when logged in showing available models and workspaces, instead of Customer with drop down, show selected customer name
Version Selection
Hi Experts, In page selector When i select Version selection.The following periods need to show remaining periods are hide Version is actual then i show previous 6 months actual periods non-editable Version is forecaste then current period to end of the with in the year data. Version is Budget then next year all periods…
Ability to double click and open a summary line item
Hi, It would be nice if we have the ability double clicking to open a summary line item.
Identifying if a list item is a property on a separate list
Hi, I have two numbered lists, City and Product. Product has City as a property. All Products have a City as a property, and multiple Products can have the same City as a property, but not all Cities may be linked with a Product. In a module with City list as a dimension, how could I identify if a City has been linked with…
Create a composite hierarchy from a file where parent-child relations are expressed as two columns
Hi, Anaplaners I have a question regarding how to create a composite hierarchy from a file where two columns alone indicate a hierarchy (parent-child relationship). Please see the attached for the detail. Is such a transformation possible ? Thank you. GregModeling
Test if a specific month is selected then do something
Hello, I have a module,and within it I use Time as a Page selector in it. My time is formatted like this : Calendar Type : Calendar Months/Quarters/Years, Fiscal Year Start Month: Jan, Current FY : 1 Jan 2018 - 31 Dec 2018. For a specific line item in my module I want to test something like this : IF Jun is selected THEN…
HOW TO READ CURRENT PERIOD BY USING FORMULA
Hi, In one module i want to read current period.Can you please suggest me what formula i use Foe suppose we are in jan-19.I want to read current Period(Jan-2019) in Filter module. Regards, Uma
Is it Real to make dynamic List
Dear Anaplanners, I have a modeling issue. We have an "Agreement Register" in anaplan, it has the structure you can see in attached photo: The values for each agreement are being changed every month. Also every month we need to Export "Unique code + Value" to other system, and each line there becomes enrighed with…
requires cell info loaded in particular year
Hi All, I am trying to write an formula which should plot "year" info, where it was loaded in a list. This is about dates we manually loaded in a particular year. Now i want to extract the year info on the cell where this was loaded and not the year that the date mentions. For example we loaded 31-Dec-2018 in Year "2019"…
Hide Blank Rows
Hi, I have a module in which few rows have blank value with changing parameter. Can i put some formula or any way in which only the rows which are non blank will be displayed irrespective of there changing parameter?
Version formula with valid Circular Reference error does not appear only until a new module with Ver
Description of the enhancement requiredIt would be useful to have a preventive check that would prevent Version formula with valid Circular Reference to be saved during initial setup of the model prior to any new module creations.An example of the enhancement:When creating a new model from scratch, when the model builder…
Ability to export model history in an action that may be published as a button
Description of the enhancement required: Ability to export the Model History (via button from dashboard) for Non-Workspace admin users. An example of the enhancement: Create an Audit History for a defined time range eg. 1-Jun-2018 to 30-Jun-2018 Save the Export while extracting Publish the Export (saved from #2) to one of…
Summing from week to quarter between timeranges
Hi everyone, I have encouterend a problem that keeps bugging me, so I would like to share this with you guys! In a model I have two timeranges: Model timerange: 2 years, months, no quarter totals. additional timerage "Long term": 5 years, quarter totals. Module A: Model timerange: Lineitem 1: timesettings: weeks Lineitem…
If a model saves during a process, the progress bar will read as 'Generating failure dump' which is
When running a process, if the model saves it incorrectly tells the user that it is 'Generating failure dump' instead of 'Saving model'. This is causing confusion for customers as there are no failures after the import has completed.
Ability to select multiple items in the Manage Views screen
Description of the enhancement required: Ability to select multiple items in the Manage Views screen An example of the enhancement: Within a module, select Views > Manage Views. Be able to hold Ctrl/Cmd or Shift, and select multiple items in the list, and then Delete them. A story for why you want the enhancement (How…
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…

Modeling

Discussion List