-
Tagging Duplicate Items
Hi All, I was hoping to get some with a problem that I'm trying to solve. I have a module with a line item that is list formatted. In this module, the 'applies to' is a list that has 7 values. The line item in the module has the following items shown for each of the 7 rows: item 1: Product A item 2: Product B item 3:…
-
Master Data based on Scenarios
Hi Can I know how to change master data based on scenarios ? Example I have Regions List consisting of 3 regions and Scenarios list having 3 scenarios (Base Scenario , Scenario1 , Scenario2 ). The data related to these 3 regions should be base Scenario and in future if I add another region the data related to these 4…
-
What is the Longest Model Time Range You've Used?
If you feel comfortable, try include: * Model time range (actuals + forecast periods) * Industry * Usage Mine is: - Model time range: 2 years actuals + 10 years forecast - REIT - PB&F
-
Creating an As-Of Version
Hi, I was wondering if users can create an as-of version in Anaplan. Thanks in Advance, Daniel
-
How to model annual inflation in Anaplan?
Hi Anaplan Modeling Experts, I found it is not that straightforward to play with timeseries data in Anaplan, when the calculation logic for a specific item is referring to the values of itself from the previous period. In this example, I am trying to model the annual inflation rates. In Excel, it is quite easy, just type…
-
Roll up blank children into parent list?
Hi all, I'm working on an incarnation of a the Anaplan Agile app, where we track user stories in a list and those roll up into epics in a parent list. In my user story module, the user stories can be tagged with a status (not started / in progress / complete / removed), or that cell can be left blank by the end user. In my…
-
Import data to a module, best practice?
Hello, I have the following data: Name/Formula/Format/Notes Transaction # /CODE(ITEM(# Transactions))/Text/(# Transactions is the numbered list I created with Properties of Account (Text Format), Cost Center (Text Format), Cost Pool (Text Format), Amount (Number Format), Version (Text Format), Period Text Format) Cost…
-
Meeting Invite Through Anaplan
Hi Can we schedule a Meeting invite into our mail calendar through Anaplan? Thanks Tejaswini
-
Platform for new users
Hi All, Recently, have started exploring the Anaplan, can someone please let me know how I get a platform to test and explore options. I want a platform to work on my ideas.
-
Fake to Real Timescale
I am trying to map a fake time list (months) to the real months timescale so that I can create a time filter off of the real timescale for the fake timescale. What would be the best way to do that? The fake months list has the same format at the real one does (MMM YY).
-
Internal Learning on Demand
Hi - does anyone know if the Anaplan Learning Center is compatible with Learning on Demand Platforms (i.e. Cornerstone (CSOD))? I'd like to be able to track enrollment and group with other internal on-boarding trainings. Thanks!
-
How to flag a period using boolean?
I have 12 months worth of data, but only want to flag Aug-Dec. I can't do it by checking all the boxes as there are over the 10k limit, so I'm trying to develop a formula where it essentially says, if period > July, true else false... Any ideas on how to easily accomplish that?
-
How to "do nothing"?
I have a situation where if a given condition is met I want to take action, but if it is not met, I don't want to do anything. The line item is of type number and setting it to 0 is not a viable option for the ELSE side. So how can I code "do nothing"? Thanks in advance!
-
Anaplan way course los angeles
Is there an Anaplan way course on-demand or available in Los Angeles area? I'm working on level 1 and level 2 model builder but was hoping to get model builder certification. The Anaplan way course seems to be a requirement but I only find classes in SF, London, Singapore. Thanks Jason
-
Creating an Automated E-mail Job for Anaplan Data Outputs
Overview E-mail functionality to send automated notifications and data outputs can be achieved for Anaplan Customers utilizing Anaplan Connect. This is a solution that utilizes a portion of the error handling script found on community…
-
Looping in Anaplan
How to apply this formula in anaplan ? CF Inc/dec in Receivables = (@PRIOR(Customer Accounts Receivable)+@PRIOR(Other Receivables)-@PRIOR(Accounts Payable - Intercompany))- ((Customer Accounts Receivable)+(Other Receivables)-(Accounts Payable - Intercompany))-CF Inc/dec in Receivables
-
Limitations on data load
Is there any limit on data load? i.e. If the data is importing from CSV, What could be the maximum size of the CSV File?
-
Cost Optimization for 2 plants
If I am doing cost optimization for 2 plants where I have demand & Supply for the 2 plants seperately. For a specific time period if my constraints are getting satisfied for plant and not for other plant, I am not getting the optimal solution for that plant with satisfied constraints. Can I get the solution for only that…
-
Limit on No.of Users
Is there any limit on addition of users to the workspace?
-
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 !
-
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…
-
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…
-
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.
-
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.
-
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…
-
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 %…
-
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…