Modeling

Rolling Allocation Problem
Hello Gurus, We have an allocation problem. We have Shortages(Demand) and Supply by month. We have to allocate the oldest supply to the demand ie FIFO. Also, there is an expiry period for the supply, beyond which it cannot be allocated. The same is illustrated in this example, you may note there is a 1-many, many-1 and…
Retrieve Model ID and Workspace ID via API then load as CSV?
Hello All, I was wondering if it is possible to retrieve Workspace ID and Model IDs of any given Model which then can be pulled into a CSV file? Then imported into my current model? What I am looking for is something like this: 1) Retreive Current Model Details via API, extract into CSV. *Looking for ways to grab either:…
Summary Filter
Hi, Any tips as to hide HY/FY view UNLESS you have all 6/12 months - is this a simple formula in the time modules and then used in a filter? Would that be against best practice for having >1 filter for a column/row? Kiraikawaii
3/20 Platform Update - Any Ideas What Changed?
Hi team! I was hoping to see the image in a grid support and the row height adjustment for word wrap in a grid. Does anyone know what actually got implemented yesterday, and did these two make it into the upgrade?
Level 1 Model Building - Estimated Exam Time
Hi - I'm ready to take the Level 1 Model building exam. From the instructions it seems I should plan on completing in one session. I'm planning my week, how much time do you recommend setting aside to take the exam?
Select first week of the time scale by user
Hi, Current I have designed like this to select first week of the time scale. But I am wondering is there a way in ANAPLAN That If I select one check box for that Line ITEM, it will disable all other check boxes for that same Line ITEM and If I uncheck it , it will enable all other check boxes? Here I have maintained a…
2.3 DAT03 Historic Volumes
Hi, I have historic figures for volume in DAT03 for FY19 that have been offset to give me baseline forecast for FY20. How do I achieve the same for baseline forecast in FY21 as currently my baseline demand ends at Dec 2020. I also cannot seem to enter the ROUND formula correctly in DEM03 to get the Initial Demand Forecast?…
Mapping the products.csv file in level 1 training
Hi, I created a hierarchy of product family and products. I need help with mapping the products.csv file. Please find the screenshots attached.
Reconciliate when having subsidiary views for fx rate
Hi, I have an actuals module that has all transactional data from the actuals in local currency. In there I created a line item, Amount FX, that has a subsidiary view since it has the FX Rate dimension added to it so it can do the FX rate conversion on the line item Amount. The numbers in the import are validated so they…
FIND formula not working
Hello, We have an line item composed of all the Sales Reps associated with an account (some only have 1, some have multiple). This line item is text formatted. This line items is called "Sales Reps" We then have a second text-formatted line item, which is a text field, called "name," and the functionality we are looking…
how can I automate or schedule a process with in Anaplan
Hi, I am looking for a functionality about how can I automate or schedule a process with in Anaplan, which transfers data from one model to another model with out clicking manually each time on that process in dashboard?.. I appreciate your help on it. Thanks! Suman
Personal Anaplan Workspace
Hi All, Is there any way in which single users can obtain an Anaplan workspace for the building out small personal models? Thanks, Chris
Level 3 Live Instructor Led Training Option
Dear All, We we have such training for Level 3 ? Thank you, Lily
DEMO 03 Baseline Forecast showing zero's for FY21
DEMO03 Baseline Forecast module showing zero's for FY21 I have used four more formula's along with the shown in this image. Formula 1 : IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' then OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) else IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' then OFFSET(Default…
Formula scope - actual version
Hi I have a module where the formula scope is currently showing "actual version", where if time is less than switchover or isactualversion(), then it picks up actuals. I've tried to drill down, but I can't see which module actuals is coming from? Anapedia is quite vague and unhelpful. Can someone please explain? Thanks
Update Start Time without ALM and Current Month / Week by Automatic Batch
Today, we need to update Start Time in DEV then do an ALM but it can be complicated if we have developments on going. We would like to be able to do it directly in our PROD Model. We would like also to be able to do it automatically by batch/API, same need to update Current Month / Week and all Times Settings etc.
Forecasting with my own data. Versions.
Hi! I'went through L1, and right now I'm trying to do forecasting for Total Profit, Revenue, Cost and Margin in the Module. (with my data) Why in my modules there is no forecast info? I do have a module with Version Details and I do have forecasting there... I do have info from 2010 to mid of 2017, and I would like to make…
Formula questions
Hi, I'm attempting to write a formula to pull in the percentage amounts of a line item in a different model in accordance to a certain vintage year. I'm trying to use either the LOOKUP or SELECT function but getting a error. Please advise. 'R01 Inputs'.Funding Scaler[LOOKUP:Vintage] Thank you
Breakback on List items
Hi All, I have a list product list P4 and a filter is applied on it i.e at P4 level only few items should be shown based on selection. Break back is enabled on all levels. In P4 5 items are there only 2 items belongs to category 1 and 3 items to category 2. Our requirement is that If user select Category 1 and enter data…
How best to create a variance module from a revenue module with a version dimension
Hi I need some help on this. I have created a revenue module with a version dimension for actual and forecast. The variance is a simple calculation of difference between the two. The issue I have is since the actual and forecast revenues are sitting in dimensions rather than line items, how does once calculate the…
Be able to adjust column size in the Blue Print
It would be very usefull to be able to adjust column size for all columns in the Blue Print, mostly for Format, Reference by etc. Today, we need to copy/paste the information in word or excel
How to get only one value from a module that contains Time
I want to get only one value from another module without having a list. The ideal is to display the value of the first month of a module with Time in another module that has no list. I am not good at English and it may be difficult to understand. Thank you.
Question on aggregations
I have a module with 4 dimensions - Version, Countries, Projects and Employees. Single line item is worked hours. Hours at employee, project and individual country level correct but not when aggregated at All Countries - the numbers don't look right, why? The aggregations seem fine at individual country level but not when…
NUX user access management : manage by categories, consolidate the list of access etc.
Today, in old UX, we can manage user access by default for the new dashboards to come by functional area. Thanks to this functionality, we can show / hide multiple dashboards easily. We would like to have the same option in New UX thanks to the "Categories" in the landing page for Apps. We would like also to have a global…
Improovment on "ALM" for App thanks to Multiple Sources Models / Preview Function
It's very useful to have multiple sources models for one App in order to have our DEV and PROD model together. However, we nee to improove some functionalities : - Be able to "flag" easily the DEV Model thanks to an icon or color to inform/alert users if they are on DEV or PROD Model - User not Page Builder should not see…
Improove NUX Drill Down : widen nav bar in page and indent formulas
Be able to widen the right navbar in a Page like in classic Dashboards or Worksheek in order to see all information of the calculation without scroolling on the page. We would like also to have indented formulas in Page and Worksheet.
Sort Import actions by process assigned too
Import actions keep building up in the entire project. The import actions are often a mess and difficult to find/search in the huge list. Is it possible to sort the Actions by process they are assigned to ? For example:- In sprint 1 , we created approx. 150 actions and assigned them to some 10 processes. In Sprint 2, we…
First Virtual Group Event for Indian Modelers
Hello Anaplanners in India, Glad to share that we are going to have our first Group event on 7th April 2021 10:00AM IST. Register for the event here Group Event on 7th April 2021 10:00AM IST
Inventory Ordering Module Formulas
Hello everyone Why training course think that it is wrong formula? Confirmed Purchase Order Receipt (INV01 Inventory Ordering) IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0
Copy Branch Workaround - From Jan User Group
Here is the explanation of how to do the Copy Branch & Assign workaround as demonstrated at the January User Group

Modeling

Discussion List