-
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?
-
L2 - S3 - 3.3.5.5
Want help with this formula.
-
Picklist of months: line item formatted as month
I have a line item formatted as Time then Month. The picklist only displays the individual months and not the total FY. Is there a trick to show the total FY too? I'm trying to avoid creating a list with the months and total FY.
-
Optimization in anaplan summary
HI All, Now i want to check summary of a line items wheather its required are not how can i do that. what is the possible ways to turn off the summary. Why cant we turnoff the summary of a dashboard line item.
-
Assign recipients via module in Notification designer UX - need to include people dynamically Role
is there anyway to include certain role people in notification alter via module dynamically??
-
Rankcumulate - unexpected result
Hi, I am using the rankcumulate function but I am getting some really unusual results, wondering if anyone could assist as I have no idea why this is occurring? I have attached the formulas and also the results. Thanks in advance
-
Moving values from one module to another while Line item is being used as Dimension in other
Hi everyone: Module 1: Dim - Entity (Aus 1, Aus 2....) LI - please refer below as (numbers) Module 2: Dimension: LI of first module , Parent of Entity (Aus..) Line item: Amount (which will have the values from the first module) I am getting same value distributed across all the Dim 2. Can someone help me out in this case…
-
Do saved views take increase model size?
Hi all, Do saved views take up space? If one module has 10 saved views vs. 1 saved view, does it make a difference on the model size? Thank you! Amy