Modeling

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
Removing '0' from 3rd place
I want to create a new filed and a logic where the input will be project name which is a combination of letter and and digits. The new input field should replace '0' in the 3rd place of the project. E.g- PROJECT NAME: PR120 then new calculation field should remove '0' in the 3rd place what can be the syntax to remove or…
Time: PREVIOUS vs ITEM(TIME) - 1
Hi all, What's your opinion, should I ever use PREVIOUS(ITEM(TIME)) function when ITEM(TIME) - 1 does the same thing? Best Practice says it's not recomended to use PREVIOUS() due to low performance. In the example above it is probably straightforward "yes" to ITEM(TIME) - 1 approach. But what about when there is some…
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.
SUM or IF? Performance and Readability
I'm interested to see which is the better performer and also, subjectively, which function is more 'readable': SUM or IF, in the following scenario... Consider that you are building a model for an international retailer. This retailer is setting up stores in different countries. When setting up a store in the first month,…
Dynamic Numbered List
Hi, I have Months as a numbered list. The number of items in this list is calculated based on user input. Each time the user changes the input, the list should be deleted and items should be created based on the new value. Is it possible to dynamically create the number of items in a numbered list? Thanks
Ability to use ROLES as a dimension and a dropdown for DCA setup
While setting up the Dynamic Cell Access based on user roles we would have to resort to a workaround where we would create a list of roles and based on that we would setup the DCA. However, if the ROLES (native system defined) could be allowed as a dimension, just like how the users are allowed to be used a list, it would…

Modeling

Discussion List