-
Finally HyperModel is Here!!
Finally Great News! HyperModel is here and will be available in August.Forget about 130 now and scale up seamlessly. Read more Anaplan HyperModel: Model complex problems at scal... - Anaplan Community Anaplan is so obsessed with the Word "Hyper":)
-
Question for Level 1 part 4.8.2 Activity: Import Data into E2 Employees# List
By following the cours, I'm in the level 1, part 4. I'd like to import the employees liste in my module. The E2 Employees# list is already created under General Lists in Model Settings and its list Subset. If I understand, this is a number liste, I import its liste like other fich csv. But the import is failed,It shows :…
-
Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods
Hi! I was hoping someone could share if I am missing something in this activity: and this is what I have in my module: I am having trouble matching the rounded cells and I think it's throwing off the rest of the data. Anyone have advice on how to fix this or if I am correct because I don't understand how 59.47 rounds to…
-
Sum between Anaplan time and custom time
I have a use case where I am trying to sum from Anaplan time (days) to a custom time dimension called Cohort Time which is in months. I have a module (Attachment 1) which has number of leads per day in Anaplan time with a Cohort Time line item coming from a separate module. Worth mentioning that the months in Anaplan time…
-
Breakback and Hold - New UX or otherwise?
Hello, I'm looking to permanently set the Hold on a Breakback cell total so that any weekly percentages entered always total 100% and the user cannot change the total monthly cell. I've attached a video for reference . Essentially, any percentage that a user enters in the week cell should always then calculate out of 100%…
-
Time Estimation Required
Dear Team, I require a rough estimation relating to creation/testing of Modules/Dashboard/List. Lets assume that the design part has been already completed & we are in Sprint Build stage. I have categorized the difficulty level into 3 parts - Low(Simple), Medium & High(Complex).. Modules - Input Modules -…
-
Circular Reference Issue in rank traversal
I have a problem statement where I am trying to do some allocation basis rank traversal there is fixed quantity Q= 900 which i have to distribute amongst vendors . e.g if i allocate 100 to V1 basis some logic, then I am calculating remaining quantity for allocation to other vendors V2 where I calculating remaining quantity…
-
Any automation for setup migration
Hi We have done the setup in our Anaplan Dev environment for one of our project and validated successfully. Now, we need to migrate the setup (including Definition of Lists,Modules, Actions, processes) into our Production environment. Instead of doing the setups manually in Production, we are looking for any automation…
-
Error message while applying formula in EMP02 Employee Expenses level 1
Kindly refer to the screenshot below for the same
-
Remove indention of list in module
Hi, Is there a way I can removed the indention in the list i used in the module. Thanks, Tom
-
Simulating parent and child together
Hi, I have a module where I have 2 lists and few line items. Line items are used for simulation(shifting data from particular Time period say Apr to Aug). This happens for all the list items which are there in Applies to. Requirement is such that, simulation should happen for only few list items as per user selection.…
-
How to add last year and current year
Hi I have monthly data by segment by product family. - Refer to document attached I would like to build dashboard to display last year, current year and variance column. Therefore, i build 1 module, source, last year, current year and variance line item Question:- How to input formula to grab data for FY20? How to input…
-
Lookup between Time Periods and Text
I'm reaching out for guidance on how to build a link between Full-Year time periods and a list-equivalent Fake Years. i.e.: FY19 = "Year One", FY20 = "Year Two", etc. Some background, I have a P&L line item "Revenue" that has a year ending balance of $100,000 in 2019 and $150,000 in 2020. These revenue amounts begin to…
-
Experience of implementing LINEST in anaplan
Hello colleagues. At the moment I am implementing statistical data analysis in anaplan, the analysis methodology was developed in an excel. In excel, the LINEST function was used to search for the four unknowns using the least squares method. I did not find an analogue of this function and I do not imagine how to obtain…
-
Rolling Forecast
Hi We have monthly rolling forecast as real versions and one version list with Last Month, LAG1, LAG2 as list items and in source module we have real versions as dimension, In destination module we have versions list Mapping needs to be done in such a way if current period is July then Last Month= June LAG1= May LAG2=April…
-
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
-
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?
-
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…
-
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…
-
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…
-
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
-
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 .