Modeling

New Bee How to get Workspace
Hi All, I ma new Bee and little confused with the process to learn Anaplan. While activating account, I did apply for 90 day workspace and started the course for level 1 Modelling. The course steps asked me to confirm if I have workspace and admin privileges'. Not sure where to look for to see I have workspace allocation…
2.4.11.1 Create Product Family Manager Role
In the Supply Chain model, add a new role: Product Family Manager. Each Product Family Manager should be able to make changes to the Volume Growth Rates for only their assigned Product Family, but only view the data for the other three Product Families. The Product Family Manager role should be able to see the Detailed…
Restriction line item based on another line item
HI all, I have a module Fnem00, here we have to Select the Account and program. Based on that we have provided the DCA to enter the values in Fnem01. Now if I delete the Account and program in Fnem00 the Values in Fnem01 is Values are not getting erased. How can i fix this?
User list used as a dimension, allow to create a subset to reduce module size
I would like to use the user list as a dimension so users are not overwriting each others settings, but the module with the data the settings select is big and so is my user list, so this adds a lot of unnecessary model size. Can't there be the ability to create subsets of the user list when used as a dimension, like for…
How to keep the input value after switchover
Hi All, i have a question about switchover Currently the forecast period is started from Jan 23 and i have input a $10 in this period however after i have switchover to Feb 23, the input value will gone. how can i resolve this issue? thanks Before switchover After switchover Blueprint
3.3.5.4 Update INV01 to Allow Override of Order Amount
@Misbah Can u let me know if its right? are my formulas right?
3.3.7.2 Add DCA to INV01 Inventory Ordering
Add Read and Write Access Drivers to INV01 Inventory Ordering module to set up Dynamic Cell Access to perform as shown in the example below: Week 1 & 2 (blue highlight) * Week 1 shows the result when Submit Purchase Order Request is NOT checked. * Week 2 shows the result when Submit Purchase Order Request is checked…
level 1 lesson 8.5.3 mapping
Unable to import file properly and map Could you please help me ...
Level 2 - Sprint 3 - 3.3.5.3
3.3.5.3 Check Your Work After you have added the line items and formulas for the INV01 module, compare your model with this example: Expected resultMy result Above are snapshots for the expected numbers and what I got after entering the formulas required. They are discrepancies, can anybody please let me knw what went…
Anaplan natural rollup is not equal to sum of values from its children
Hi, fellow Anaplaners I observed some weird behaviour of Anaplan natural rollup (meaning set line item as number & sum as summary method, then parent item will take sum of all its children's values). I have 2 line items here: 1. Commercial input is number formatted; no formula, is for planners to manual input forecast…
Improved Formula Editor/Bar
If the following features could be added to the formula bar in Anaplan it would make model building and maintenance a lot easier! * Colour coded statements and keywords (e.g. IF THEN ELSE, line items, constants) * Ability to indent and enter new lines. Particularly useful for IF statements * Keyword autocompletion *…
Activity 8.8.2
Hi, I am unable to add the right data in Fy 21 and FY 20 in the REP 01 Country Margin Report Module. I have added the exact formula as well but it is showing the correct answer in only the FY 19 rest two years are incorrect. I have check my other modules i.e., the referring module for this formula is also correct but the…
3.2.11.3 Create Saved View for Combination Chart
3.2.11.3 Create Saved View for Combination Chart The Product Replenishment User Experience page will include a combination chart of data from the INV01 Inventory Ordering module that displays the weekly data for the months selected with the Planning Period Filter. In the INV01 Inventory Ordering module, create a saved…
UX dashboard filter not defaulting to current user
In an attempt to reduce the size of a line item(used for dashboard filtering), we created a dummy list that contains a small subset of people. The subset of people has selective access enabled. I then used FINDITEM to link the Users list to the subset. The linking worked successfully. However I ran into an issue when I…
Will the Action work fine after renaming the list involved?
Has anyone faced this issues? Scenario: I have a list named "List A" and Source module "X" and "Y". Process followed: 1. I created an action "AC01" to import data from "X" to "Y" in Dev model. 2. Synced this action to test model. 3. If I run "AC01", it works fine. 4. Later remaned "List A" to "List B" in Dev model and…
7.2.3
I'm stuck trying to map this import. Below is an image of how I was trying to map it. If anyone knows how to map this correctly I would appreciate it.
3.2.11.3 Create Saved View for Combination Chart
3.2.11.3 Create Saved View for Combination Chart The Product Replenishment User Experience page will include a combination chart of data from the INV01 Inventory Ordering module that displays the weekly data for the months selected with the Planning Period Filter. In the INV01 Inventory Ordering module, create a saved…
Level 1 lesson 8.5.2 Mapping options
While doing this activity i faced issues while mapping it. But in my workspace there were an additional tab of time while i was mapping it. Could you please help me out to complete it correctly.
LEVEL 2 - SPRINT 3 - 3.2.11.1
added the formulas , Let me know if anything else is required to be done in the activity Are the last 2 line items formulas correct? Anything else to be done?
Modeling in Anaplan with alternative tools: Part 4
One goal of the Anaplan Community blog is to showcase the variety of skills, thought leadership, and knowledge that exists in our ecosystem. There are so many stories and talented people we want to highlight! One of those people who stood out this year is Certified Master Anaplanner Mitch Aist. Mitch has graciously given…
Multiple Model Builders changing Actuals Through Switchover
Hi everyone - We have a large team of builders and one of the most used modules is pulling Actuals Through from the Lookup Reference module. It can be frustrating when Actuals Through Switchover dates keep changing due to people working on different things. Has anyone found a workaround or have a suggestion for best…
Level 2 - SPrint 3 - 3.3.6
Attaching below are what is expected and what i got, need assistance regarding this. Let me know if i have to attach my formulas too
Level 2 - 1.3.10.2 Import Data into G2 Country List - Error
Hi, 1.3.10.2 Import Data into G2 Country List In the Data Hub model, import data from the source saved view into the target list: * Source: SYS06 Country Details module, Build Country saved view * Target: G2 Country list NOTE: This list is part of the geographic hierarchy. Remember to designate the Parent when importing…
7.2.3 Activity: Import Data into Employee Details Module
I could not do the mapping correctly. I can not see all the required columns. Could you please help me to understand what I did wrong? Thank you!
Ability to attach an export to email notification and send it to non-Anaplan users
Hi there, It would be good to have an option to send a notification to non-Anaplan users and add an export file to the email notification. So, this will give a flexibility to the end user to inform non-Anaplan user while staying in Anaplan. Thanks, Humay Kh.
Looking for an "action log"
Hello, I want to ask, Is there an "action log" within Anaplan? Similar to History, but which tracks actions. It's important to be able to track when an action ran and its results. For example with import jobs, we need to know when & who they ran, if they failed, error messages, entities added, updated, etc. Thank you
Combinining list members from 2 different lists
Hi everyone, Is it possible to combine list members from 2 different already available lists in Anaplan? If you know how, please let me know. I attached explanation picture: As an example, I want to create a list called "Master List" that will get data from Customer Service Manager and Sales Manager lists. List members are…
Which approach is better? (Related to Text, Lists and Formulas)
Hi Everyone, I have a module which is dimensioned by one list. It has around 60k items. In this module there is one line item (Main_Text). I want to pull a string from this Main_Text line item and then use Finditem() function over that string. Right now, the approach that I am using is to calculate them in two different…
Restrict the hierarchy levels in page selector
Hi - I have a hierarchy with, say, 3 levels - level 3 being the child. I have a module with level 3 as one of my dimension. For some valid reasons, I want to restrict in the page selector of this module not to be able to navigate to the upper level in the hierarchy of level 3 list- can that be done? Thanks, Regards - Guru
formula summary
HI All, Why we use summary as formula. what are the scenarios that we use this ? what is the outcome of it?

Modeling

Discussion List