Modeling

Inputting product mix % via a dashboard
I have a mix of products which must always total 100%. When forecasting, I would like the ability for the user to either a) type in the product % mix, or b) increase one whilst simultaneously decreasing another (of their choosing) via a dashboard. If possible, could anyone help with how to set up point b?
Get Lastoccurrence data
Hi, Please help how can I get the last value in my module. I tried to use a rank function but can't reverse the ranking to ascending because the source value are the same amount. Thanks in advance for the help. Tom
Count Function
Hi, I have a line item 'country' based on which my account module is developed. These accounts are mapped to countries. I need to find out the count of accounts from each country. In the sample below, there are 5 US accounts, 2 Canada and so on. How to come up with the count of UNIQUE accounts based on each country? for…
Lookup or SUM between Modules with Different Dimensions
Hi all and thanks in advance. I just want to lookup an amount from one module to another one. However, they have different dimensions, so, I created a unique code to work as link between those Modules (it is a string type). How can I perform the Lookup or Sum using this unique code? I mean, I try lots of ways, and it is…
Include Row Labels in Modules
Similar to Include Row Labels within the export dialogue, it would be really useful if model builders could display list properties in modules. This would be useful in both the NUX and classic dashboards. Illustrating with an example: consider the list hierarchy L1 Regions, L2 Countries, L3 Cities. The L3 Cities list has a…
how to solve level mismatch
Hi, Table A FactoryModelModel.LineamountLine.Factory JapanA X100Japan BX200Japan CY400Japan Table B Lineammount X300 Y400 I have "amount" (by Factory,Model) in tableA. I want to aggregate "amount" by Model.Line in Table B. I use the formula like "amount" = "TableA.amount[lookup:TableA.Model.Line]" but the formula error has…
Anaplan User activity Record from History
I need to make application for ANAPLAN in which I can load per day user activity in the model building , any idea what can work ?
Dimension as User ID
How to set USER ID as dimensioned in Module for making user contribution application
Level 1 Exam
Role not pulling through correctly when importing into the SYS08 Module. I have changes the format to text and to role but it's still not working. Please someone help an amateur anaplanner out!
Scale With Anaplan: The 3 Tenets of Planning at Scale
As organizations evolve and expand to serve a growing number of use cases, customers, and employees, scalability—the ability to support greater demand without impacting performance—is critical to success. Yet, with many traditional point or on-premises planning tools that operate in silos, scalability can appear as an…
Block any other transactions being processed between actions in a Process
Description of the enhancement required: We are requesting that Anaplan implement changes so that, when a process with multiple actions is run, no updates (manual data updates or configuration updates) are allowed to occur in between each action's running. This means that the process should be treated as a global action…
Level 2 Sprint 3 Create Combination Chart for Dashboard
Hi Team, Before you publish the SYS01 Time Settings by Month module, showing the Planning Period Filter line item, filter it to show months only and save the view as Filter for Product Replenishment Dashboard. This is the requirement of the course. I applied the filter on months only & saved it as "Product replenishment…
Returning the Date of when a contract starts
I have contracts with revenue and expenses by dates (differing start and end dates) in a module (Start date ="1", the second period ="2", so on until it ends of reached end of time periods). I'm building a dashboard which reports the start and end date of each contract, and then allows a user to input a revised start/end…
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!

Modeling

Discussion List