-
Level1 MB Activity -2
Question:- Level-1 Model Activity -2 I am trying to import and map the SKU volume csv file (Attached) in the Data02 Module, but getting the parameters like parent and code which are not present in the module as well as the CSV file. Below is the screenshot of the module line item (blueprint). Below is the mapping screen to…
-
Level 2 - Sprint 3 - Activity 3.5.5 - SKU by Distribution Centre
Feeling lost how to go about creating module for this card All SKUs for a Distribtuion Center- any inputs please?
-
User List Formatting Performance Issue
Hello, We currently have a model built out with functionality to create "adjustments"; these adjustments have a line item that is dimensionalized by the Users list. The idea is to track who has made which adjustments, and figured that the users list is the best way to do this. We currently have 2 versions of the model -…
-
Creating a history log
Hi everyone, I was wondering if you can create some sort of tracking / history in a line item? Below are a picture of dates: the date actual (source system) will contain the most recent dates when uploading into anaplan where as the date actual historical will contain the dates from the previous time it was uploaded. Is…
-
Date Input is outside the model time range
Hi, I have a date formulas calculation to test whether the line item is falling within certain year, however cannot figure out what to do for the lines that fall outside of the model time period set up. For example, I have a contract that starts from 2020 to 2025 and the model is set up as 2 past year and 2 future year (so…
-
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…
-
Irr with dates with large transactions lists
Hi anaplan community, We have a challenge using irr dates with large transactions lists. Challenge : - transactions are loaded from a large flat file list of transactions - irr dates functions calculates number of days di as the difference between the first transaction and the transaction date. - when the transactions are…
-
Retreival of Archived Model
Dear Community, I have archived Data Hub Model (Level 2 Sprint 1) , Now I am in Level 2 Sprint 2 (Supply Chain) using Data hub model to pull the historic data, when I importing (Action 9) , I get error saying that source model is Archived by other user . If anyone knows how to retrieve the archive model , that would be…
-
Reverse Cumulate Alternative?
Hi - hoping to see if anyone has a solution to this: In the following example, I'm trying to calculate (going backwards) when the sum (less current period) would be greater than the test doh line item. In Jan 20, it would look back 3 periods to be greater than or equal to 92. (Oct/Nov/Dec) In Mar 20, it would look back 4…
-
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…
-
Level 2 Sprint 3 Confirm PO
Season's greetings all. I am completely at a loss. My final confirm PO equation, after several iteration, is as follows; IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks)ELSE 0 Is there a logic context error here somewhere that I am overlooking? Any help would be greatly appreciated.…
-
get item numbered list depending on a range of dates
Hi, I need your help. I have 3 lists: Product, rate, invoice and two modules: I want to put in invoices.valid rate the max number# of rate list where all following conditions are satisfied: * Rates.status = true * Invoice.Prod name = rates.prod name * Rates.start date < Invoice.Invoice date < rates.end date Can you help…
-
[Guide] Multi Level filter selection on composite hierarchy
If you are using a multi level composite hierarchy as your main reporting list (as you should vs ragged), you have encountered the need to filter it and display many levels of it in many different dashboards. Recently re-discovered a solution that I find quite handy and decided to share it here. Here's the result. As you…
-
L3 Sprint 2 : '5.5.1 Data Hub Model' File not downloadable
Hello, I am section 5.5 in L3 Sprint 2, where we are asked to - "In the Data Hub model, create an Employee Details system module. Then, download the Employee Details data file and import into the Data Hub module. " The file link doesn't give me a downloadable file. Can that please be shared here? Thanks! Richa
-
Last 12 months SUM and Actual Version
Hi, I am trying to workout a formula for Forecast Version Line Item. The requirement will be as given below. Source Module: Source Line Item - Sum of "Sales" of last 12 months in Actual Version Target Module: Target Line Item- "Sales" for 1 period in Forecast Version. Eg. Assuming I am forecasting Sales in Feb 2021; So the…
-
How to change date format DD MMM YYYY
Hi, I have a date formatted line item (example: 4/1/2020) - this is in mm/dd/yyyy format However, i want to show as 1 April 2020 or 1 Apr 2020. How do I do that?
-
Filter/Sort
Hi, Question please. I am trying to use a system filter in my report module so that I can see first the start date of the project after the All Periods (sum). The filter is working, however, when I put the All periods on the left side column the filter will not work. I need to show in my dashboard the columns, first the…
-
Holiday Time Filter
Hi, Trying to create a Line Item in my SYS Time Setting Module that filters out all of the Business Holidays that we are not operating. This is a Daily Model and not sure how to approach writing the Formula for this. I need to Eliminate the following Holidays (New Years Day, MLK Day, Memorial Day, Labor Day, Thanksgiving,…
-
Modelling Best Practices
As a parting gift, check out these 3 latest videos showing how to model: * Time in a flexible way * Different sign conventions * Alternative Hierarchies https://community.anaplan.com/t5/Best-Practices/Modeling-Best-Practices-Video-Series-1-Flexible-Time-Mapping/tac-p/93477…
-
Parent names for a numbered list in ragged hierarchy
Hi Community, We have Ragged Hierarchy where list members are more than 60 characters each having different codes but have similar names. If we go for numbered list we cant add display name property for parents and if we go for normal list then duplicates are there and list members are also having more than 60 characters.…