Modeling

File Missing in Level 2 Sprint 3
Hi, Is there a .csv file for the Shipping Methods and Time taken for delivery? If not then it is not mentioned how should I populate it? Regards,
MLM Implementation
Hi , Anyone has idea about MLM (Multi Layer Marketing ) model Implementation in Anaplan . Or is there any App available ? I am not able to find any app in App hub. Thanks !
Add Filters for Data Import
I have Module A form where I want to import Data to Module B. I can't touch Module A, so I can't use Export function from Module A. As shown in the pictures, I want a filter Import of a particular country. I have worked on creating saved views and exporting but not sure whether same can be for Import as well. Any inputs…
Add a new Data Hub
What are best practices when is needed to create a new Data Hub due to workspace space limitation to 130GB? I have already built the Data Hub which contains historic data and data validation processes. I still need to load further years. The only option I have, without deleting the data already loaded is to create a new…
Auto Allocate List Item to Line Item based on Boolean
Hi Team, I'm trying to allocate unused #Job Roles to an Employee list through a Boolean identifier but cannot figure out what method I should use The scenario is: - I have a list of #Job Roles & a boolean line item which indicates which list items have not been allocated to employees (Module EM43) - I have a list of…
Safety stock import filling missing
I find the safety stock import .csv file is not uploaded in the Sprint. The image I uploaded is an old one shared in the community. Can someone please share the file or assist how can I download it?
So long and thanks for all the fish!
As you may know by now, I have taken on a new role in the Product organisation of Anaplan. I've taken responsibility for the evolution of the Core Platform. This will be quite a departure for me, having worked for 20 years on the "other side of the fence" but I'm looking forward to brining all of my experience to date of…
Warning message before, not after Synchronisation [Lack of Space]
Hello everyone, I think it would be good to have some sort of warning message appearing before you decide to push Synchronise in the Compare/Sync windows. Many times (and not just myself, but my colleagues as well) when the synchronisation starts we need to wait for Anaplan to push all the required changes - or at least…
Formula Bar Changes Color When It Is Active
It would be helpful if the formula bar changed color when it is active. As an indicator, This could help people avoid clicking around on different line items and entering in incorrect formulas. See the screenshot below as an indicator of what this could look like.
How to import data without manual mapping for Numbered list?
Hi, I want to upload data into a module that has a numbered list as a dimension, as a result of this I have to manually map list elements manually to excel file rows Any technique for automatic data mapping of numbered list elements to excel rows? PFA Screenshots of my mappings for more clarifications:- 1. Source or Excel…
Issue with value addition
Hi Community, Can someone help me understand, why am I not able to fill in any values for Volume Line Items even manually.
IF and Then for ISACTUALVERSION and Forecast periods
Hello, I am working on Strategic Planning where I have actuals for 2019 and I am projecting for 2020, 2021, and 2022. I have a formula where I want to apply a 3% escalation starting in 2021. My current formula uses ISACTUALVERSION and Offset. Here is the formula: IF ISACTUALVERSION() THEN 'Actuals'.Period[SUM: 'Actuals'.AU…
New to AnaPlan
Hello Team , I am very very new to Anaplan, and I want to learn (Functionally & Technically) and want explore this tool. Please suggest topics and study material.
What do the bold & italics sentence mean?
Not available unless: You are a member of the Audience: Level 2 Model Building Completed
Archive selected modules in Anaplan
We needed to create a new hierarchy and **** the old one. We've been running two major modules alongside one another for a few months now. We want to archive the old hierarchy and all modules associated with it. Is there a way of archiving modules and lists but not the entire model itself? Thanks.
Model History Restore
Hi! Can the model history be restored after executing a delete using selection action deleting a bunch of items (around 50 million items) from a particular list? The model is in the standard offline mode. Thanks, Somain
Modeling
Hi Team, Below is my requirement, Could any one please help me? I need to publish the latest inserted list item to Dashboard. How to proceed? Thanks.
Selective push of line items through ALM
Hello fellow Anaplaners, I was wondering if it would be possible to selectively push line items/modules while synching models through ALM? The idea is - I would like to setup a master model and then migrate only the required functionalities/calculations to two different target models. With this setup, I will have to design…
Real to Fake Timescale
I am trying to map the Anaplan monthly timescale to a fake timescale that I have created. I have a location that has a date MM/DD/YY in which I am wanting to map that to my Month list that consists of Month 1 through Month 60. I am trying to do a formula that will map that date as the Month 1 list item and then each month…
Anaplan picking up double quotes instead of single quotes in a line item name
Hi all, Just wanted to check if anyone else is also facing this issue. off late if a line item name is having single quote (') in it, then if that line item gets referenced, Anaplan replaces that single quote (') with double quotes (") in the target place. I faced this issue while drafting a complex formula in notepad and…
Lookup data from two line items with different format and "applies to" lists.
Hi, My current build has been full of surprises. Right now I need to lookup start dates for new employees, but, the module I am building and the model from where I need to take the data, both use different lists. As you can imagine the lookup does not work and I cannot just pull data directly over without a formula. Do any…
Need to use lookup or similar, dependent on two different flat lists
Hi, I am quite new to the Anaplan Community. I have searched quite a bit, but, have not found an answer to the question I have, so I'll ask it and see if someone might be able to help me. I am currently building a module where an employee should be able to see his/hers ramp % for both current and previous roles. The ramp %…
Anaplan sales planning with AI
Anaplan yesterday announced that now platform has capability of AI predictions for sales planning I am not able to find any documentation or anything on platform does anyone have idea where to find it?
VARIANCE command
When we define an item we can set the number Format to Numeric and tag if an "Increase in Value" is Good/Bad/Neutral. Why do we not have a VARIANCE function to utilise that increase in value indicator? So if we have three different Versions ("Actual", "Budget" and "Actual vs Budget" and 1 item called "Sales" (with an…
Mac Versus PC - Different Browsers - What works and what doesn't on Anaplan?
Hi Community, I just wanted to create a post to allow users / model builders to share their experiences on the differences / issues they face when viewing a model / dashboard on a PC vs MAC and different browsers: It would be great if we could all share and then we can produce a list together of the known differences! So…
Copy last entered cell value to all
Hi, I am facing a problem, can someone solve it, please. I have a module which has Employee, Time Range(FY01 to FY15) as Dimensions Line Item - IP(List format), Growth % (Number Format) IP Line item is user input, by selecting a list item from a dropdown. Growth % - Value(Name(IP)) - Will change to number format. Let's…
Previous function in a if then statement
Hey there, I am trying to figure out the calc logic where the user has the ability to input a percentage in which will then be applied/reduce to the number. However i need a logic statement where the reduction is applied from previous quarter to next quarter. For example i have 100 in Q1Fy19 and then will have 99 in Q2…
Fp&A case study access
Hi, I am not able to access 299 FP&A case study. Please provide the access for the same. Thanks Nitin
Switchover workaround
Hello! I have a question on best practice with regards to version and switchover date... My model uses 3 separate data sources for Salary, Income and Other Costs, which are stored in 3 separate modules. Initially, I built the model assuming that each of my 3 data sources will be actualised to the same time point. At the…
Level 1: Create Saved Views for EMP02 module
Hi, I have moved on to the save dashboards section. I am trying to create the EMP02: Forecast Periods. The instructions ask to filter by forecast months only. However, it is not clear to me how I can filter based on that when I create a filter. The only time options in filter are about start date. I tried to set that to be…

Modeling

Discussion List