-
Ranking of Formula Performance
Is there any 1 place that does all the rankings of formulas in terms of performance? The formulas I am trying to rank are…. Moving sum, YTD sum, cummulate, and timesum. In ranking fastest to slowest, I would guess…. YTD Sum, Moving Sum, timesum, cummulate.
-
When I make a copy of model, what does not get saved?
What are the pieces of information that does not get copied to new model when copying a model by using the "Manage Models" screen and how does it compare with copying the model by revision tag When model is copied by revision tag, production data is not copied. When model is copied by "Manage Models", I think history and…
-
What to do when Sync is incompatible?
When an ALM sync is incompatible, is reverting prod to last revision an acceptable way to fix the compatibility issue?
-
How to check if the text in the line item exists in a list?
Hi Guys! I'm trying to build a formula where I basically need to check if two conditions are true. One of these conditions is to check if a certain text from a line item exists in a separate list that I created. Bringing it to a language that I know more (I'm new to anaplan) I would like something similar to IF LineItem IN…
-
Level 1 Model Building Exam - Activity 6
resolved
-
1.6.3.1 Create DAT04 Distribution Center Parameters Module
I don't find SKU flat list. What did I missed please
-
Create DEM03 Demand Forecast Module: Growth Rate % line item zero values
Hi Anyone who can help me with the formula for "Growth Rate %" line item? I put this formula ('DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]) but I have zero values
-
Anaplan List Summaries
Hi, Our model currently has the heirarchy sites > region > are, which is fed through our modules. One of our modules (visible through our UX's) give us price by site, where we can filter by region, but this narrows down the data of sites to the region selected. We want to be able to select 'Region = NORTH', and the number…
-
How to create in a module a quarter option?
Hello, I have a forecast module, with monthly TimeScale and I want to create, in this module, an option for a quarterly view. So basicly, if the client wants to see the data quarterly, he should be able. I also have a MOD02 Quarter Time Settings and also a filter module for the quarter part. At this moment, my data is…
-
Running Actions in a Loop (Conditionally)
I have a use case to simplify let take an example. Assume we have product that can be bundled. Product A is single SKU. Product B is bundle of Product A plus some extra cost (eg packing cost). Product C is bundle of Product B plus some extra cost. User has option to either modify the price of Product A or Modify the extra…
-
Default selection in a dropdown
Hi, We currently have a line item (called driver), which is formatted as one of our lists. When a user goes into a UX, they currently have 15 options to choose from, however we want a specific one to come up as default. Is there a way of doing this? Thanks, Josh
-
Between Anaplan Time Range and Model Calendar, which is the optimal approach for model optimization?
-
I cannot start Level2 spint2 learning
I completed the test with a 90% response rate. But I can't take the next step. What action do I need?
-
SUM for two line items (in the same module) that have a common list format
Hi, I'm trying to SUM two line items in a model - currently we have the below which works: THEN '[SUM: 'PL 1. P&L '] …. As we want to SUM two line items in the module, we have tried the below (and other SUM formats) but failed with the comment the line items have the same list format. If somebody could advise it would be…
-
How to lock a specific version?
I am looking for a way to lock a specific version so that numbers do not move for that specific version. I have used a version list in my modules instead of Anaplan's native version functionality. For example, I have three items in my versions list used in all modules- actual, budget and forecast and want to lock down the…
-
How much time does it take to restore a model to previous version
I have a model which is of 500 gb in size and I have restored it to a previous version. How much time will it take? It is already 30 minutes since its running.
-
How to pull together values from multiple modules
Looking to pull together values from multiple modules, which have started, as shown in the right hand screenshot. The difficulty I have is trying to pull the values across from a module such as INP08, shown on left hand side of screenshot below. Ideally I want to be able to pick up individual lines from this module into…
-
How can I unolock the locked Budget Version?
OK. So we wrote a budget, had it approved and locked down as the Budget Version in Anaplan. A few months later we decided to move some of our assets around, with an impact on the budget. We would like to change our Budget Version to reflect these changes. We can't unlock the Budget Version! How do we do this? Chris.
-
Apply Value only to certain list members where line item matches others in list.
Is there a way to apply a value to a certain list member and only the ones after, where a particular line item (where the adjustment was applied) is equal to? In my example, List members are shown in order. On Cell G13, 1500 was applied to Sales ID 11. H12-H16 reflects the additional 1500. Because Line 22-26 is also…
-
Importing older classic dashboards into Anaplan apps
Question When one imports a dashboard, is the original dashboard in classic lost, or is it still available after the import? My preference is to have both and then, after tweaking, I can manually delete the older dashboard. Thank you