-
Level 2 sprint 3: Create DAT04 Distribution Center Parameters module & import data from Data Hub
Hi Team, I am confused as in, In the activity, we were told to import from the data hub model, which has half-yearly as line item along with weekly safety stock. Because of which I cant map it while importing. My importing was complete but with error and I can see the data in the supply chain model as well. Do I need to…
-
Lookup value
Hi, Would like to ask if I can lookup a list item which is classify as a parent list? I tried it but it does not work. I got values using lookup if the list classify as child list. Thank you. Darlene
-
Level 2 Sprint 2 DEM Restricting export functionality
Hi Team, I have cleared level 2 sprint 2 exam, but with one wrong answer. In one of the activity, we need to restrict the export for the 3 module from DB. So I unchecked button DATA-EXPORT checkbox in menu options. But it seems it is an incorrect option. What should have been done then?
-
Comparing User Dimensioned Answers
Hello, I have a module where users indicate the "priority" of list members using a list formatted line item. These users can potentially assign different priorities to the same line items; a screenshot is attached that illustrates how two users have indicated different levels of priority (one High, one Medium). Is there an…
-
Comparing list items (formula help)
I am trying to see if items I have in one list exist in the other. I have created a module with a boolean line item and my idea was to use the formula = IF ISNOTBLANK(FIND('IN3 Vehicle'.anacode, Total Vehicles.anacode)) THEN TRUE ELSE FALSE to find if the values exist in both list. (If it does appear in both list return…
-
Model Building Courses and Certifications
Is there a way to complete the Model Building courses and certification exams for students. I find this platform quite interesting and was wondering if I could learn more about it. But when I checked out the Level 1 Model Building Course, it says that the workspace access is only available to the Anaplan employees,…
-
First Year of a month identification
In my Level 2 Supply Chain Lowel Bolin model I have multiple Time Settings module. SYS00 Time Settings by Month SYS01 Time Settings By Week SYS02 Time Settings by Year SYS03 Time Settings by Half Year So, I have question regarding Weeks and Months. My SYS01 Time Settings By Week has (Jan)Week 1 FY 20 - 12/29/2019-1/4/2020…
-
Why this Aggregation doesn't Work
Hello Team, I am facing some error while aggregating value by period(month) in the same module which having period.it works against normal list but not against time dimention
-
Level 2 Sprint 2: Test as End Users
Hi Team, I am testing as an account manager and my testing is successful as per selective access applied, But in the activity account manager name was also given but in the training, it's nowhere mentioned that manager role wise testing needs to do. Is that just for reference or I missed something?
-
Data dependent locking of cell data
A boolean property on a list; if the boolean is checked, data for that list item is locked throughout the model. Need to define how/who can unlock it. Could be very useful for custom task flows & locking mechanisms. Useful for custom workflows.
-
Import (Upload) Action on Break Back line items
Hi - I have a module with three dimensions and have a line item activated with break-back functionality. A specific team from the business will always update the data at a higher level in the hierarchy across three dimensions - and to make it easy, let's presume - we know the higher level at which business updates the…
-
Selective Parent to Child Rollup
Hello Everyone. Is there any way from which i can control what all members in a hierarchy rolls up to their parent level. Example- I have 2 lists L1 and L2. L1 is parent of L2. L2 list has a property called status which can be Approved,Declined,Proposed etc. I need to provide a control on the dashboard where in a user can…
-
Not able to view any data
Hello All, I am currently in my Level 2 Sprint 2 training, DCA module. I was assigning roles to product managers as told when all of a sudden I realized that I was not able to see any type of data in my Supply Chain model. The whole model with the formulas is intact but I am not able to see any data whatsoever. I have full…
-
Formula Help
Hi, I have a module with Versions list(version1, verrsion 2, Version 3 in Line items) in dimension. I want to copy Line item 1 of version 1 to Line item 2 of version 2. Please let me know how to write the formula. Also if I have 2 similar modules and I want to copy Line item 1 of version 1 from Module 1 to Line item 2 of…
-
How to get a count in Anaplan?
OPI #Mgr 1. OPI #Mgr2. OPI #Mgr3. OPI #Mgr4. OPI…
-
Lionpoint Group: Enhanced Anaplan Model Performance
Maximizing your Anaplan models helps ensure that you're getting the best results. Lionpoint Group provides a unique perspective and tactical applications to improve overall model performance by achieving a more thorough understanding of how the Anaplan engine works. Here we share our viewpoint and approach to optimal…
-
Level 3 Experience - Please Read!
Anaplan Community, Just wanted to share the very positive experience I had with level 3; and, to encourage everyone to seriously consider working your way towards this certification. What to Expect * Very professionally done * Quality of videos and articles 11 out of 10 * Incorporating other master anaplanners best…
-
Anaplan model size Issues
We have a DEV model with around 15 Lists. Each Lists have lot of List items. Also our Data Import load file(Excel file loaded into Anaplan) has too many records(more than 40,000 records) for various combinations. Also we have requirement that a single output module must contain most of these list as Dimensions. Since most…
-
Hold and Release functionality with NUX
Can anyone help me find Hold and Release functionality with NUX or is that something missing in the new UX? Thanks, Sandeep
-
Need to fetch values from a line item based on another line item value in the same module
Hi Need help to get this requirement done.Please see the screenshot attached.I need to show the items which have blank value in the Config line item, in another module.(ex.HDD0037,HDD0037) Can you suggest the formula that I need to use in the target module? Thanks Regards Prabakaran
-
How to get Start Period of Time Range?
Hi experts, Is there a way to get start period of a time range in a LineItem? Regards, Inoue
-
When the import process fails depending on the user
Hi,everyone. I have a question. When importing data from module to module, the data is not imported due to "ignored". In the case of WorkSpace Administrator, it does not become "ignored" and it ends normally. I assume it's because of permissions, but setting permissions seems to be fine. What are the other possible causes?…
-
Unable to open our workspace access pertaining to ANAPLAN LEVEL MODEL BUILDING Training course
Dear ANAPLAN Team Due to technical difficulties we are unable to open our workspace access pertaining to ANAPLAN LEVEL MODEL BUILDING Training course and we tried to forget the password but no mail was received from your side .
-
Level 1 Cetification Exam
Hi How much time is alloted to complete the exam for Level 1 Certification? How many qusetions are there? Soma
-
Move data Adhoc
Hi, I have a requirement to move data from 1 line item of April to 2nd line item June and the No. of months data should get shifted is based on the user input(adhoc). For Example, if the user selects 3 months, it should move from April to July, if he selects 5 months, it should move from April to Sep. Please can you let me…
-
Certification Exam
Hi my name is Gabriella and I am having trouble with the certification exam. I need to get an 80% or higher and I am having trouble achieving that score.
-
Comparing two modules
Hi, I am trying to make a module to compare two modules to see which values they share and which are missing from either. The values I’m comparing are 3 text line items and I wish to make 2 columns holding the results of if the value is missing from that module Boolean. I’ve tried using compare but I’m having issues as…
-
Workflow Process
Hi All, I want to know how workflow works in Anaplan . Are there any default dimensions that we need to use for workflow. Can any please provide step by step process to set up the workflow....? How about providing access to workflow for a user..? How does it go to the next level i.e for approval/reject...? How can we…
-
How to Set Up a Count Based on an Attribute
This example will teach you how to set up a count in order to count items in a source module based on specific attributes in that source module. Anaplan does not contain a 'Count' function like Excel, but it’s very easy to simulate the same behavior. All you need to do is add in a line item called 'Count' and set the…
-
Help to find get items from a list to another
I have a transaction form which has two line items lets say A,B (both text) -> Concatenating A,B gives C Row 1 of A -> SDF AB9 Row 1 of B -> 20 Row 1 of C -> SDF AB9 - 20 I have another list which basically have some items of A, B column and i manually concatenate and upload in Code column to get C It's number list BTW My…