Modeling

Load Data between two model from Numbered list to another Numbered list
Hi, How can i automatically map my data load from data hub to FPA model? In my data hub, i am using a numbered list(Coded) and trying to load this module in my FPA model using the same numbered list (Coded) but the mapping are not automatically updating. > I have mapped the building Code-Dum to the coded building column. >…
calling out previous data
Hi team, How to call out previous data from numbered list similar to previous if time bounded? Please see attached reference file. Thanks, Eia
Model builder level 1 exam - SKU volumes not pulling through
Hi, I am trying to complete the module builder level 1 exam but the volumes file isnt uploading correctly, the data is only pulling through in Jan-19. I have revisited the content but not getting any answers, some please help!
New UX Process
Hi Friends, I would like to know, if the Process button (Action button) that is in the Worksheet can be published in the Board?
Toolbar new UX Dashboard
Hi Members, Please help me find this button. It is not displaying in my Worksheet Designer.
Level 2: Conclusion: Activity: Add Currency Conversion Functionality
Hello, I am having trouble pulling in all the data for all the Time/years. What does it mean in the Activity Instructions: ..."contains data needed to set up this module. Use the Symbol as the Code for each currency." The CODE used throughout is not the column in the data extract under Symbol (eg USD) vs. Code of "US". I…
Sum Data From start year in model
Hi, is there a way i can sum our balances from the start date i set in my time setting? See attached screenshot. The balances should be for FY14 = FY13+FY14, for FY17 = FY13+FY14+FY15+FY16+FY17 Thanks in advance for the help. Tom
Requesting conception about new UX
Good evening Friends, This is an existing Model in App Hub, I downloaded it. Now what we find is that: It was Process and Delete Actions created (first two pic). In the third pic, we have the module names and fourth the list names. Now my question is: If I want to migrate to new UX, will I have to create every Module again…
Level 2 Sprint 3 Create filter & Saved views
Hi Team, I created the line item in SYS00 & 01 as mentioned in the requirement below. I am confused with the requirement mentioning not showing HY value until all weeks are checked. Please help.
Worksheet or Board?
To publish data in new UX, which is better Worksheet or Board?
LEVEL 2 SPRINT 3 INV01 Module PO line item
Hi Team, @einas.ibrahim I am stuck in below Formulas attached in PO1: My formulas are attached in PO2 Problem Statement: I used POST function for "Confirm PO Delivery" & " Confirm PO Receipt" but when i ticked my checkbox for week1 its not posting inventory values automatically to WEEK 3. when tick my week 3 checkbox also…
TR02
Hi All, Need your advise. I have created the TR02 module using an unorthodox process to ensure that the final sales target matches with the initial sales target(Parent level) taking into account of Overrides & Hold. BUT, details at the country's line item level is not matching with 8.4 Check Your Build. Have I missed any…
Calculating final sales forecast
Hi, In order to calculate the final sales forecast, I have used a very unorthodox process (attached below). Now, even though the overall amount at the Account parent level is matching, however there are some mismatch with individual account line level (mismatch between my module & what is there in the Sprint 1 screenshot)…
Color Map
Can we build something like this in Anaplan with the five colors? I can get the data together but can't think of a way to get five colors? Thanks, Debbie
SUM and LOOKUP for Retail
Hi Retail Team! Here's a handy cheat sheet for how to use SUM and LOOKUP using a retail use-case. I provide the use case and then implement it in Anaplan. I also use D.I.S.C.O using system modules so you get the best practice. Use Case 1 - Lookup User Story: SVP of Store Operations wants to provide top down guidance to the…
Copy Module Glitch - Ratios Reset
Hey community members, Our team discovered a potentially huge glitch in Anaplan this afternoon, and we are wondering if anyone else has experienced something similar. We have a module that uses Ratio as a summary method on a couple line items, and after we copied this module to build out a separate part of the model, we…
Level 2 Sprint 1 -- User Story 3
Hi Everyone! As I've been going through Level 2, I have come upon an issue with importing the Historic and Volumes file into the DAT03 Historic Volumes Module. This is the error I have been getting, any help would be great, thanks in advance!
SUM Function
Hi, Is there a way to post the sum total to a separate column for each line items. Example - I want 27,484,445 to be displayed against each line item under Total column. Is it possible?? Thanks AB
Finally HyperModel is Here!!
Finally Great News! HyperModel is here and will be available in August.Forget about 130 now and scale up seamlessly. Read more Anaplan HyperModel: Model complex problems at scal... - Anaplan Community Anaplan is so obsessed with the Word "Hyper":)
Show only transactional data combinations
Since we will be having hyper models enabling us to have bigger spaces, it would be nice to have the functionality of a toggle to show the data master data combinations with data only. Example 100 Customers, 100 Products but we only have 10 % of the combinations with actual data. So a module containing these list items…
Question for Level 1 part 4.8.2 Activity: Import Data into E2 Employees# List
By following the cours, I'm in the level 1, part 4. I'd like to import the employees liste in my module. The E2 Employees# list is already created under General Lists in Model Settings and its list Subset. If I understand, this is a number liste, I import its liste like other fich csv. But the import is failed,It shows :…
Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods
Hi! I was hoping someone could share if I am missing something in this activity: and this is what I have in my module: I am having trouble matching the rounded cells and I think it's throwing off the rest of the data. Anyone have advice on how to fix this or if I am correct because I don't understand how 59.47 rounds to…
Sum between Anaplan time and custom time
I have a use case where I am trying to sum from Anaplan time (days) to a custom time dimension called Cohort Time which is in months. I have a module (Attachment 1) which has number of leads per day in Anaplan time with a Cohort Time line item coming from a separate module. Worth mentioning that the months in Anaplan time…
Breakback and Hold - New UX or otherwise?
Hello, I'm looking to permanently set the Hold on a Breakback cell total so that any weekly percentages entered always total 100% and the user cannot change the total monthly cell. I've attached a video for reference . Essentially, any percentage that a user enters in the week cell should always then calculate out of 100%…
Time Estimation Required
Dear Team, I require a rough estimation relating to creation/testing of Modules/Dashboard/List. Lets assume that the design part has been already completed & we are in Sprint Build stage. I have categorized the difficulty level into 3 parts - Low(Simple), Medium & High(Complex).. Modules - Input Modules -…
Circular Reference Issue in rank traversal
I have a problem statement where I am trying to do some allocation basis rank traversal there is fixed quantity Q= 900 which i have to distribute amongst vendors . e.g if i allocate 100 to V1 basis some logic, then I am calculating remaining quantity for allocation to other vendors V2 where I calculating remaining quantity…
Urgent--- Can we copy a model from
Can we copy a model from one workspace to another? If yes, please describe.
Any automation for setup migration
Hi We have done the setup in our Anaplan Dev environment for one of our project and validated successfully. Now, we need to migrate the setup (including Definition of Lists,Modules, Actions, processes) into our Production environment. Instead of doing the setups manually in Production, we are looking for any automation…
Model security
Hello, I am running into an issue and need some help. I need a way for a user to be able to pull data from one model into another but not see the model where the data is coming from as it is sensitive information. The user has actions that reference sensitive data on the sensitive model. I need the user to be able to pull…
Error message while applying formula in EMP02 Employee Expenses level 1
Kindly refer to the screenshot below for the same

Modeling

Discussion List