-
Level 2 Training - Sprint 3 - INV01 Inventory Ordering Module
Hello, I am not sure what is wrong here: * Beginning Inventory Formula: IF 'SYS01 Time Settings By Week'.'Not 1st Week of Timescale?' = TRUE THEN PREVIOUS (Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory[LOOKUP: 'SYS08 SKU Details'.Distribution Center]----Does this not look correct? Any help is…
-
Rolling data snapshots of Weekly and Monthly forecast for different Versions
We have a scenario where there is a need to do a weekly forecast for short term (next 13 weeks) and monthly forecast for remaining periods of the fiscal year. The forecast and actuals need to be captured in both weekly view and monthly view. Also the monthly view needs to be tied to a consolidation system (another tool…
-
How to link parsed list back to List codes
Hi, I've created a module that contains a list with data that has 3 components of a list concatenated (to limit the number of rows). The list data looks like this: CCCC_AAAAAA_DDD - with the C's being company code, A's being account code, and the D's being department code. I now want to have another module that references…
-
Statistical Forecasting algorithms into a user specific model
Hi - I am new to Anaplan and I have a quick question: Let's presume we are to develop a supply chain demand planning module for a client. Since we exactly know what all lists/line items are needed along with the hierarchy and the calculation formulae for different line items, I prefer to have that developed everything from…
-
All Periods amount not updating when time range updated for module
Hi I have created Module A previously with timeframe FY19 to FY22: The total of a line item for FY19 to FY22 is 36. The total of this line item for FY20 to FY22 is 29. As regards, the "All Periods" amount: Module A shows a total of 36 when I set the time frame for that particular module to "FY19 to FY22", as expected. But…
-
Summary Methods Based On Line Items - Product as an example or Weighted totals
Hi All, I feel that the summary methods in Anaplan could be improved further by including more flexible options to use other line items (same dimensionality) to influence summary method. For example on a model I have been building recently, many of the summaries require the product of 2 line items divided by the total of…
-
optimization
hi In production optimization formula given for C3: Constraints i have written as it is given in dashboard but still it shows erroe when run optimiser. i I have attached screenshot of the error and formula written for c3: constraints. Please guide
-
Optimize a parameter in statistic forecast
Hi. We are trying the Statistic forecast. In monthly model, we need to set parameters to run the statistic model. (Like Holt's α in Holt's Winters model) But this setup is manual input. Can we calculate the best parameter(0.0~1.0) by Optimize and minimize MAPE?
-
8.5.3 Activity: Different data problem
Hello all, I am working on Level 1 activity 8.5.3. I imported the file without any problem but my numbers are different from the screenshot given by the course module. Could you please help me with that? Merve
-
Circular Reference help
Hi, The following formula below is giving me a Circular Reference when it should not be. Please advise on how to avoid this error. The LI that this Formula is in is Acutal and Projected 30 + $ Curve. Pic Formula IF 'Actual 30+ Dollars from Tableau' = 0 AND 'Actual 30+ Dollars from Tableau'[LOOKUP: 's54 MonthonBook…
-
Change import default name while setting it up
It will be good to have ability to change an import name the same time when you first create the import. For example, having a special field on import setting window, like in screenshot.
-
Get Native version name to a lineitem
Hi, Is there a way i can get native version to a lineitem in text format ? Similar to using name(item(List)). Regards, Tom
-
Level 2 - Sprint 1 Activity 1.3.6.4 Create Import Distribution Center Details Saved View
Hi, * Module Name: SYS07 Location Details * Saved View Name: Import Distribution Center Details * Filter to show only Distribution Centers Select SHOW for the Default Shipping Method line item and save the view. How to Filter to show only Distribution Centers means? I just added filter to it but no values appeared.
-
Inventory/Cost From Prior Periods Question
Current business model: Have monthly beginning Inventory + beginning inventory $ value (+ production/-usage) calculating ending inventory lbs. & $. Ex: July beginning Inventory 100K lbs. & $100K value. (-usage of 50K lbs/$) leaves ending inventory for July and Beginning Inventory for August at $50K/ 50K lbs. Business…
-
How to delete a subset?
Hi, I accidentally created a subset under a wrong list. In activity 1.3.7.4 Create s G3 Location: Distribution Center? List Subset I was supposed to create subset under Try It Hierarchies but I accidentally created under Location Flat, now I'm not able to delete it since it is referenced in 'DAT01 Beginning Inventory'…
-
Summing the time dimension
Hi, I'm trying to do something which I think should be very simple but which I just can't seem to get working in Anaplan. I have two modules with exactly the same dimensions, except one has a time dimension (years) and the other does not. How can I have a line item from the second module (without the time dimension)…
-
Childs with same parent crossing in a same module
Hello all, Imagine we have a parent list Country (G1) and two child list attached to this list: Fisrt list => Regions (G2) and a second list Stores/Entities (G2 bis). We need this second list Digital Stores because for each country we may have 2 or 3 digital stores which may serve all regions of my country. For example, in…
-
Modelling from module "Line Items" view
The "Line Items" tab is a really handy view when reviewing a model and looking through multiple line items across different modules at the same time. You can currently access the formulas by double-clicking but I think the view would be so much better if you could access all the module modeling actions (i.e adding a new…
-
Referencing same line item of prev row
Hi, I am facing issue in trying to reference the same item of prev row. For example, This is the Excel formula for a line item ‘Calendar Month’ : IF Calendar month of prev row = 12 THEN 1 ELSE Calendar month of prev row + 1 Has anyone faced similar issue? The Else part of the formula gives circular reference.
-
Lineitem Format : Timeperiod show Quarter and Year
Hi, Is there a way I can show in my line item formatted as Time range to show both quarter and year ? The reason is to have a full year view of my data. Regards, Tom
-
Run model-to-model imports in Anaplan on a schedule that works best for you
You can use the native capabilities in CloudWorks to distribute data from the Data Hub to Spoke models, or between different models in the platform, any time you want with its model-to-model import functionality. No activation or add-on services are required to use this—everything you need to get started is in CloudWorks…
-
Need help on 7.2.3 Activity: Import Data into Employee Details Module
-
Keep Model In Memory (KMIM)- can we keep model cache alive , it will help with performance
n we keep the model cache in the buffer/memory (Keep running) alive, instead of clearing eveytime after logout? This will take a long time to load the model every time when size is huge ..otherwise we have to keep some dummy job running to Keep Model In Memory (KMIM)
-
Report design question
In the attached screen shot you will see one of our report by Project and by Time. This module is dimensioned by Time, Project List, Function list and Funding type. We have data for actual, forecast and etc. We need to see Project ID and Project Status information on this report. But if I add them as line item, they show…
-
Previous for a monthly result only.
Hi Team, Is there a way I can use Previous but won't affect my previous or succeeding month? Example: Jan 1 - 1 Jan 31 - using Previous I will get 1 Feb 1 - 0 (should not get my result in Jan 31) Feb 3 - 2 Feb 28 - using Previous I will get 2 The previous will only get monthly result and will reset next month? Thanks in…
-
Calculation to get Quarters for Previous Year Only, Current Year Only, and Forecast Year Only etc
Hello, I'm trying to configure the view below using the Time Settings and/or Time Lookups module. I've tried multiple things, but haven't been successful. Can anyone provide guidance on how this can be achieved? Thanks.
-
Level2
Level 2 Completion I have completed and passed all the exams of Level 1 and could some one let me know web link for Level2 exam and required information. Thanks Narasimha
-
Filtering on user - Data is incorrect
Hi , I have a module with list of employees who belongs to different countries .I have created a user filter on country selection . Now when user selects a country ,the list of employees shows the relevant employees. But problem is total ,say total salary is not as per selected country ,it will be of all employees from…
-
Dynamic Aggregation
Hi, I have a module below, a list (transaction date) on the rows and time period on the columns. Is there a way to do dynamic aggregation vertically based the list transaction date? For example, I want to have this cell (time period: Apr 18, list period: Aug 19) to show sum of transaction period Jan 19 - Jul 19 for time…
-
How to delete imported data?
i want to know how i can delete imported data