-
User Story 1.6 L3
Hi, I can not get my module to populate. Please advise. Thank you
-
Identify records with same value in Column 1 but different value in Column 2
Hi Team I need to identify records that have same value in Column 1 but different values in Column 2. For eg, from the below data set, I want to identify the 1st 2 records may be by adding another line item NameCodeTimelineRoger F1MonthRoger Federer1QuarterRafael N2MonthRafael Nadal2Month Thanks
-
1.3.15.3 Check Your Work Level 2 Model Building
I am unable to add the action to processes. Please find the screen shot attached here. Earlier i was facing issue with adding the flat list also but i was able to add it after so many trials( 5.1, 5.2,5.3). Please help me to understand how to add the 5.4, 5.5 .
-
Time Filtering
Hey all, I'm wanting to update a time filter to use in module views but am having a hard time figuring out how to create a specific condition. I want to have a filter for the current quarter and the previous five quarters as well (so 6 quarters total). Right now I have a line item that gives each quarter a decimal value…
-
create shipping export module and create a saved view
Good Evening, In the last part of Level 2 anaplan, activity "prepare data exports", we are asked first to create a module to export later ( easy and done). But then in the same sentence they also ask to save a view for export, but they don't indicate what to pivot, if there is any filter... I don't get what to do after…
-
Cycle Shift Input Design
Hi Everyone, I am trying to design a module for shift input. It should be working in this way. When we enter shift start time and cycle period, that start time will repeat according to cycle period until we override it. I am struggling to design and figure out formulas? Any idea and tips are appreciated. Thank you.
-
Budget based on prior year outputs whilst avoiding circular references - help needed!
I have some minor account / cost centre values that I want to flex year on year based on the % change of a proxy and inflation. The solution I have tried below is creating circular references in the final part: Year 1: Period 1 Base value (final month of actuals) Inflation % Period budget (base value * inflation %) Year 1:…
-
L3 TAR01 Module
Hi, My TAR01 Detailed Sales Target is off. I'm not sure why. I tried to pull from D02 Data Module, but then my dimensions were wrong and wouldn't let me look up by product and country. I have been stuck on this one for a while. Please advise. Thank you
-
Filtered Summary View based on the presence of a list member
Hello, I'm stuck on the logic to create a filtered summary view. I have a table A, but now want to create a filtered table B (which is a list of only the cost centers & Worker Type combination with a Large Group Size (i.e. Headcount total of 21 & above across all Work Groups.) So in the image below: The summary view (table…
-
Renaming P3 SKU list from Saved View_ 1.4.6.1
Please help me in renaming the P3 SKU list from the saved view. 1.4.6.1 Rename Actions Using the recommended naming conventions for Actions: * Rename the Actions used to load the P3 SKU list and SYS12 SKU Details system module:* Organize the Actions in the correct sequence. * These Actions will be included in the Process:…
-
Scenario for calculation
Is there any formula instead of first occurance
-
Forecast range in Statistical forecast APP
Hi, I want to use Statistical forecast APP. This app presupposes forecast 1 Month? Some Forecast method only forecast 1 month like Winter's method. I want to forecast 1 year. Is there any setting to change forecast range? or I shouldn't use this method?
-
How I Built It: Waterfall calculation
We come across the need for waterfall calculations more often than we think! I’ve personally created this at least four times in different contexts, and I’ve helped colleagues who were trying to achieve something where a waterfall calculation would work perfectly well. First, let’s clarify what I mean by “waterfall…
-
TAR01 Detailed Sales Target module
In the description from '5.2 Model Build Specifications', we need to calculate the proportion of a country's total sales revenue by product family each account's product sales contributed. The TAR01 was created already in the model, it's dimentioned "A2 Account>Product#' only. However the first line item is to calculate PY…
-
Confused about Lag, Lead, Post, Offset
I got confused between these functions. It's unclear for me now. If any one can help me with simplifying this it would be very helpful for me. Is there use cases where Lag and Lead should be used instead of offset or post? Thanks in advance.
-
Level 2 - Sprint 2 - 2.3.9.1 Import DAT03 Historic Volumes module
I referred the community thread to understand my doubt while running the process. I am not able to figure it out. Attached are the screenshots .
-
Rep Count from Start date to End date (if applicable)
Hi All, We currently have a "Positions" module that is not time based. We show our current salaries, job titles, etc. that comes from our payroll data here. This "Positions" module also contains the Employee Start Date & the Termination Date (if applicable). I have created a line item that counts the amount of "Job Titles…
-
IMPORTANT!! Please Read! 2022 Recertification for Model Builders and Solution Architects
Community Friends. Just a heads up. To get recertified as a model builder or solution architect for 2022 you must take this 10 question quiz on new Anaplan Features by 12/31/2021. Don't worry. It's open book and you can use Anapedia (highly recommended) https://learning.anaplan.com/course/view.php?id=1536 Good luck!…
-
Problem aggregating values from timscale day to month
Hi all, I have problems aggregating values from a module dimensioned with day, to a module dimensioned with month. I am doing rent calculations in a module by DAY time scale. When I try to aggregate this to a monthly calc module it does not work. No values are pulled over. It is the last part of the formula below that does…
-
Multiple lists
Scenario: I created a module with 2 lists. List 1 as Pages List 2 as Rows Line items as Column I want to show only few items in List 2 if specific item is selected in List 1. Ex: List 1: 1,2,3, - List 2, 1a,1b,2a,2b,3a,3b if List 1 selected as 2 List 2 only shows 2a and 2b Tried making List 1 as the parent of List 2, There…
-
Import Data Module and List at the same time
Hi everyone, I have this concern of my current model, since the user will be the one to add/upload the data. I need a friendly dashboard for them to upload the file to a Data Module. But what will happen if there are new data even amongst the lists inside of that uploaded file? So I made this small test, where I create 2…
-
Display Module size in Bytes in the Module table
When analysing model size, the cell count field in the module tab is very useful. However it does not tell the full story as different data types use different amounts of memory. For example a number will use ~8x as much as an integer. The current setup works well for smaller models, but can be particularly challenging…
-
DEM03 Demand Forecast Module
Hello.Can somebody please me with this error. In DEM03 Demand module i am unable to get a data for Year 21,till year 20 all looks good to me,but from week1 FY 21 Baseline,default Forecast,Intial Demand Forecast all values are 0.I i have attached the blueprint too so i can get a better picture where i am doing something…
-
Ability to show and freeze Top level element on Grid (top/bottom and left/right)
As a model builder I want to have the similar feature to the Freeze cells (columns and rows) in Excel especially I want to be able to freeze top level element of the list used in a published module so no matter how I scroll the table it stays on the top or bottom of it and be able to select how top level elements of the…
-
Level 1 Import settings for Modules and Lists?
Is there someplace that shows what you need to have in each section for importing to lists and modules so I can attempt it several times and then find where I am wrong by checking what is right? I feel I am wasting an inordinate amount of my learning time trying to figure out by brute force, checking for people who have…
-
Time Scheduling with Optimizer
A system that allows optimized scheduling of dates / times over a period would be very useful (for example a finite capacity scheduler in production scheduling, rather than a scheduling of a team for maintenance interventions, etc ...) to broaden the functional coverage a supply chain model.
-
SYS14 Create Account>Product, Line Item "Data?" can't refer SYS12 and SYS13
I've create on Data Hub the module SYS14 Create Account>Product and looks like: But I am blocked by Data?(Boolean) filter to determine if ANY data for product SKU under the product * If you are using the Level 2 Data Hub model: reference the SYS12 SKU Details and SYS13 Account SKU filter. * If you downloaded a new Data Hub…
-
Level 1 Model Building Exam -- Activity 5
I thought I was pulling the data correctly but I guess I was not. Can anyone tell me if there is a problem with my formulas? Or maybe I should make some adjustments to my SYS08 Employee Details Module? Any Help would be much appreciated. Thank You!
-
Level 1 model building exam question 4
Hi guys, I'm trying to change the format of item list: Role, from text to list and the below message came up. Do you know how can I fix it?
-
Date Stamping the last time a Process was ran
Hello, I am aware that Anaplan does not have a Date Stamp ability and I have solutioned that; however, I am not sure how to apply a date stamp to the last time I ran a Process from the dashboard (e.g. If I run an Import today it should be stamped as 09/30/2022, or the last time it ran successfully). To do this, I was…