Modeling

Exporting into multiple files/tabs
Hi, I have a module that is dimensioned by product. I would like to export this module for each product in a single excel workbook, with each product on a new tab. Is this possible? Thanks
How to add a Dimension to your your Module that has already been made?
Hi, I created a Module and forgot to add a List as one of my dimensions to the Module. I need to know how to add the List Item to my Module without deleting it and starting all over again? Please advice. Thank you
Financial planning tool selection - Adaptive planning vs Anaplan
Looking for advice as to how to make an informed decision on choosing adaptive vs anaplan for financial planning. Data sets are not too huge and the cost and simplicity of the tools are important factors in the selection process.
X[Min:y] doesn't return results consistently
Hi, In the first screenshot below, the formula in Min Start Date TEST is trying to get the earliest Activity Start Date by line item Campaign New from the second screenshot. There is no empty date in second screenshot, but the formula returns nothing in the first screenshot. This formula works in most other campaigns in…
Text formatted line item duplication
Hi, I have a line item which is text formatted. User enters values like Apple, mango and apple again. For the 3rd value(apple)- it should show me an msg pop up, that it exists already. Please can anyone help me on how to write logic for line item 2. Regards, Rajasekhar
How can I get hands on training on Sales Performance Management modules
Hi , Would like to know the learning path for Sales Performance Management. Is there a way I can simulate sales plan, quota setting, forecasting in a test environment? Thanks in advance. Murali
Change name of Numbered List's Display Name from a Module dimensioned by it
Hi, Is it possible to have a field where the end user can edit the display name in the new ux from a module dimensioned by a list with the display name you want to change? Best regards, Johan
Allowing circular references
I have a case where I want to allow Anaplan to make circular references, what do I want to do? Basically to make a coffee I need: 1 Cup 1 cookie 50 grams of flour 5 grams of butter ... 150 ml of coffee 160 ml of water 3 grams of coffee powder So when I needs 2 cups of coffee I can go down the "hierarchy" and calculate how…
Curated tips section on Anapedia
I think it could be a good idea to have a curated tips section at the bottom of each Anapedia page. These will be things people have found work but are not specifically stated as working in the entry in Anapedia. These could then help for the basis for Updates to the entry in the future. These could be based on entries…
Ability to Define Custom Weeks pattern for Each Quarter differently in Model Time
Currently Anaplan allows only to select one Week Pattern from 3 available to apply across all quarters in a Fiscal Year Time Calendar (https://help.anaplan.com/anapedia/Content/Modeling/Dimensions/Weeks_4-4-5,_4-5-4_or_5-4-4.htm) Example - Pick any one week configuration pattern from 4-4-5, 5-4-4, or 4-5-4 for all…
How to show only the last uploaded data from a module in a dashboard
Dear Community, Could anyone please help me to implement a requirement? We are getting a monthly file from various manf. locations that tells the available inventory bucket values for various product lots. Here is a sample of the file we are getting I am loading the file every month to a Data module dimensioned by…
Level 1 model building exam - model building activity 2
Hello. Can anybody help? I struggle with the Level 1 model building exam. "in the level 1 model , update the REV02 volume inputs module to include a formula to pull data from the DATA 02 SKU Volumes module".
Order / Sorting on a List
Just in case you'd missed it, the functionality for Ordering a List via an action was launched two weeks ago It has been a great success (used 2,300x since then) Details of the feature are here https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Order-list.html This is a video of it in action…
Getting 4x the value of import in target module
Hi, I'm importing OPEX data from a datahub to a spoke model with the same dimensions but are getting 4x the values for every cell in the target module. Does anyone know why this might be? Best regards, Johan
Reorder flag
In module 2 sprint 3 it says keep the reorder flag referencing to Suggested order amount. WHile my formula for reorder flag is OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0 I cant get it Pls clarify
INV 01 inventory ordering final forecast figures
HI My final figures for Forecast Demand in Inventory ordering s not matching with the one shown in training module LEvel2 sprint 3 .Please find attached the screen shots training and mine.i know figures are being pulled from DEM03 final forecast hence pls find below the blueprint view for the same too and let me know what…
Accessing Data in other module
Hi, I have 2 modules say A and B Module A has id, name, key, value, key2_value For example: id name key value key2_value 1 x k1 v1 row_numidnamekeyvaluekey2_value1 1 xk1 v11 21xk2v12v1231xk3v13 42yk1 v21 52yk2v22v2262yk3v23 The formula for key2_value is IF key = "k2" THEN value ELSE BLANK Module B has name as rows and line…
How to make DCA line item go blank when FALSE
Hi, Module: I have created a module to submit and approve new employees. Line items of interest: Submit, Approve. Submit is boolean formatted and is TRUE when a person is submitted for approval, FALSE otherwise. Approve is a list-formatted line item with 2 list items (Approve, Reject) and DCA driven by the Submit line…
Unhide specific columns without having to unhide all columns in a module
Description: Unhide specific columns instead of the only available current feature of unhiding all columns just to see one or a few specific columns Example of enhancement: Currently, in any module, unhiding one column that was previously hidden is not possible other than unhiding all columns along with the one column you…
model building activity 6 add formulas to REP04 module line items
hello. is there anybody, who can help with the LEVEL 1 Model Building Exam? I do not know what formulas to write in the model building activity 6
Level2 sprint 3
My figures in Inv 01 ordering is not matching with one given in training module I have attached both figures and formulas used please guide whta I am doing wrong
Level 2 Sprint 3 Module INV01 : Formula for Shipping Method
HI I am using the above formula but getting an error. I understand I have to look into SYS07 Module(Distribution Center Details) for Default Shipping Line item looking up SYS08 SKU Details'.Code and SYS08 SKU Details'.Supplied By ..pls guide
INV01 - Beginning Inventory off by 2
Hi all, I've been wracking my brain on INV01 and just when i think i have it, I notice that my numbers starting in Week 3 for beginning Inventory are off by 2. See screen shot attached from my module - in Week 3 FY 20 i'm showing 8,904 and in the example 3.3.5.3 Check Your Work it's showing 8,902. I'm also seeing my…
Custom Timescale Filter instead of Time Period Drop Down
Current Timescale Selection * Current UX: Selecting a year (e.g. FY20) in the page filter will will sync any worksheets to January - December. There's no native way to show something custom like the trailing 24 months. * Modules/Classic dashboards: manually show/hide dates, or apply a filter which you'll have to do for…
Monthvalue in Anapedia
Hi I'm confused by the guidance in Anapedia on Monthvalue and Yearvalue functions whilst doing the Level 2 Model building. Having been advised to use these as part of the training to result in a boolean (which works) I was baffled by the Anapedia guidance that states it must result in a number. Is it a platform change…
Default Export File Type to CSV
This one is simple. Anaplan's recommended export file type is CSV, yet the export dialog defaults to Excel / XLS. Yesterday we had an integration mysteriously run for 7 hours, later realizing it was because the export file type wasn't changed to CSV. Please allow model admin to set the default export file type to CSV. This…
How to post a Month from current year to previous year
Hi, I have a scenario where I have to post a line item which is month formatted from current year and post it in previous year . Module is by Year dimension . for example - I select FY 20 as dimension Line item -entry is jan 19 , Result - Want to post jan 19 in Jan 19 (though I input in FY 20 as dimension) Post /lag works…
show summary with Selective access enabled
Hi All, Can I show Summary when selective access is enabled at children level? there are lists in a hierarchy say A(PARENT) B(Children of A) C(Children of B) Selective access is enables at C but want to show the summary at B(at parent of C) , attached the screenshot for reference Please suggest if this approach is not…
Hierarchy Management
There are peculiar scenarios like mergers or acquisitions when the Master Data of the company changes. Name and/or Code gets changed in the source system, and we want to update the hierarchy with these new details in Anaplan without creating new entries —which will increase the model size exponentially. We also want to…
Mapping issue - only populate Manager that is from that Department
Hi, I'm wondering how to only get the name of a person who is part of a department in a module that has department as one if the dimensions. SYSTEM Module for Users: Dimensions: Users Line Item: Departments (List-format with department which is populated based on a formula using the lookup function). Module Mapping:…

Modeling

Discussion List