Modeling

2.3.11.2 Create Saved View
Does the below screen look correct? I placed SKU and Accounts as pages. However, the directions do not mention anything about those two dimensions. Should i be leaving those out of the saved view?
2.4.4.1 Update DEM03 Demand Forecast Module
Hi, for level 2 (2.4.4.1) I know the formula for the baseline forecast is the following. However, would someone be able to go through the intuition behind this with me? My original formula was much more simple and it made more sense, but it was way off. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03…
DEM01 Sprint 2
I'm trying to import data into the model but the data imported is wrong. Not sure what the reason is. PFA screenshots. Thanks, Dora.
FIRSTNONBLANK() as a Function
Add a "FIRSTNONBLANK()" function that will evaluate each of the arguments and return the first one that is not blank. This would allow for formulas like the following to be greatly simplified and potentially better performing: Example 1: IF ISNOTBLANK( line item A) THEN line item A ELSE IF ISNOTBLANK( line item B) THEN…
Time Function
How can I pull quarter values (Q1,Q2,Q3,Q4) from Expected Invoice Date ? The module has no time scale applicable. NOTE: Time Settings doesn't have quarter totals enabled .
Conditional Formatting on LISS
Hello, I created a module that has a lot of line items and corresponding values in 3 Versions (FCST, Budget, Variance). I need to mark the Variance column in red when the Variance has minus value for a subsequent line items. PS. Variance is part of LISS from source module Can you please suggest me what I should do in this…
Level 2: 1.5.6.1 Activity
Hi, I am having some issues uploading the data file for this particular activity in Level 2 (1.5.6.1). i have provided screenshots below. I am getting an "invalid line item identifier: Volume" message. The data file that I downloaded has decimals going out to 8 decimal places (screenshot below). I formatted the number so…
Level 2 Sprint 3 INV01 Beginning Inventory
Please refer my Screenshots. I am unable to deduce why except for week 1 , no other cells are getting populated when I use the formula "IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory". Could this be backtracked to…
Copy dates between List items
Hi, I have three line items: Actual , R1, R2. Actual has data from Jan to Dec. I want to copy Actual data into R1 from Jan to March and April to Dec empty for input data. I want to copy Actual data into R2 from Jan to Sep and Oct to Dec emtpty for input data. This action starts my budget. It would be great to start this…
!!! Stuck on 1.5.6.1 Create Historic Volumes Module !!!
Can someone please show me the exact mapping that needs to be done for this exercise? I have tried this several different times over the past several days and I am still stuck on this. 😑 Any help would be greatly appreciated.
Users List-Workspace Admin
Hey guys, Got a query, i have a module with Users and Business Line and boolean line item which enables each user to a business unit. I published the same on a page but users without workspace admin are unable to view the users list, is there a way to make it enabled for them ? Or a workaround for this issue ? Thanks
3.4.4 Activity: Create Stock Exceptions Review UX Page
Hi, I am currently on the Anaplan Level 2 Sprint 3 and doing the 3.4.4 Activity: Create Stock Exceptions Review UX Page. I have build the 1st 2 grids using the INV02 module, but not able to create 3rd view for SKUs. If i am trying to create the 3 grid view using INV01, i am not able to use context filters that would change…
Level 2 - Sprint 3 - Activity 3.4.4 Exceptions Review UX Page
Hi All, Need help with Exception Review UX Page build query - The third grid in the page is based on Module INV01 Inventory Ordering. Problem I see is, it does not sync with Region context selector in the UX (Country and Region dimension not in this module). I thought of applying a country filter perhaps, but how do I back…
Level 2, Sprint 3, Product Replenishment UX Page
Hi, On my UX page with the first 2 checkboxes selected (Jan 20, Feb 20) and FY20 in the page selector, i expected to see only those two time periods. However, i am seeing FY21 data. I'm thinking I've goofed something up in my SYS00 or SYS01 filters - could anyone offer some guidance on how i can troubleshoot this? Thanks…
Count Duplicates Based on Text Field
Hello! I'm running into a problem that I'm struggling to solve and was hoping that I could get some help here. I have a numbered list that represents employees. Sometimes, employees are converted from part-time to full-time and when this happens, they are assigned a new employee ID. I need to be able to identify cases…
Beta Anaplan Platform
Hi, Am i able to use the Beta version of the anaplan platform? or is it recommended that I use a version that is sponsored by the company i work for?
Getting Incorrect format in 8.2.1 activity
Hi @noelle_murphy & all, In my module i am getting below format :- Countries should be shown in heading (in bold letters) instead of choclate names. It should be look like below one :- How l can make correction to get below same one. Please advise so that i can move ahead in my training. Thanks in advance.
Shipping time weeks data not showing
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] I have used the abovementioned formula for SHipping time weeks but no data is showing please guide what am i doing wrong
Level 2 Sprint 3 - Safety Stock Flag Count
Season's greetings all. I don't know why I am wrestling with this formula as it seems straight forward but it does not appear to be working correctly. My line item formula is as follows; 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In] Is there a logic context error here…
Unable to view model
@noelle_murphy I am unbale to view my model that I had build. What's the issue I really don't know. Can someone help? I can only see the Contents tab (SYS001 Time settings by year, SYS00 Time settings) Where is the model?
Level 2 Sprint 1 1.5.6.2
While trying to import the data, I am getting an error related to Time format. While importing what time format should I use so this error does not reoccur? Please refer to my screenshots
Filter
How to apply filter on line items? There are 4 line items Baseline Forecast,Growth Rate %,Default Forecast,Initial Demand Forecast. I want just 2 line items Baseline Forecast, initial demand forecast. The chart should show the monthly Baseline Forecast and Initial Demand Forecast for two years. so I want to filter time on…
how to write if column (a list) contains x then 1 else 0
Hi there - am new to anaplan have only used excel extensively. I need to add a conditional colum (col 2)n based on another column (col1) which is a list type. That is if col1 contains "x1" or "x2" then 1 else 0. Thank you
Interesting Build request: other methods?
I had a scenario posed to me and took a stab at building it. I would love to get any feedback or alternate methods of tackling this. Scenario: * Your user will be entering two number inputs * These inputs will be in a module that has Months * The user wants to see the numbers that they would need, month by month, to move…
L2 Sprint 2 2.4.7 Grid UX saved view not matching
Hi All, The activity 2.4.7 instructs to make a saved view as this: But What I've got is like this: Is there a way that I missed that enables me to compare 2 line items for a certain period of time?
immport error
Import ErrorI will get the below error 9.1 Import Historic VolumesModel object "'DAT03 Historic Volumes'.Export" could not be located* 9.2 Import Opening Stock * 9.3 Import Shipping Metrics
Import Error
I will get the below error 9.1 Import Historic VolumesModel object "'DAT03 Historic Volumes'.Export" could not be located* 9.2 Import Opening Stock * 9.3 Import Shipping Metrics
Formula
Add a formula to the Growth % line item to convert the DEM01 Volume Growth Rates.Growth % (monthly) value to weeks. WEEKVALUE() is used, but didn't understood.
Anaplan model builder certificate
Hi All, I have completed my level 1 and level 2 model building exams including the conclusion. I printed the level 2 model building certificate. However I haven't yet received the anaplan model builder certificate. It's been 2 days since I completed the course. I also emailed academy@anaplan.com but haven't received any…
Model Versions Lookup
Hi, I have a source model in which the model versions(default versions) product list and time as a dimensions. There is an version selection module where the user can select the base and target version for dynamic variance calculation. The target module has Product and time dimension. I need the value of the External Base…

Modeling

Discussion List