-
Dimensions & Lookup
Anaplanners, Been struggling on this particular piece: We have a module where we have a Country Dimension and Serial Number list, as each country has a fixed number of 10 agents and some attributes (line items). Refer Snip: Agent Name & Agent Role are list formatted Line Items. "Country" and "No." are lists. Requirement:…
-
Level 1 Model Building Exam - Activity 6
resolved
-
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
-
Selective Access
Hello all, I'm encountering an issue where selective access filters don't seem to be applied to a list (numbered) when it's being used as a column (select list) in my Anaplan model. The selective access filter is configured correctly on the parent object, but it doesn't seem to be filtering the values in the column list…
-
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…
-
API Authentication error bc of need to reset password
Hello, The IT team of a client has built a integration with the data base to Anaplan using the API. They have a problem of Authentication when Anaplan ask to reset the password, giving a 401 unauthorized, so they have to go to the Anaplan page and reset the password and make the changes on the integration. Is there any…
-
Display Year Sum Value and All Year Period while in filter mode
Hi all. good day. may i know if it is possible to display only the sum year value and all year period value while in filter mode.
-
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…
-
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…
-
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…
-
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?
-
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
-
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…
-
Anaplan Agile App - New UX
Hello, Are there any downloadable NUX pages/reports available to accompany the Anaplan Agile App to ease use, or is this all managed within the model itself? Any help would be much appreciated. Many thanks, Becky
-
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 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…
-
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 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…
-
Formula Question
Hi, I'm trying to create a formula that will pull values in accordance to each weekday. Below is the Formula I'm currently using. I have screen shots of the Modules I'm pulling from as well. If you need more information on the topic please let me know. 'D01 Funding Ratios'.Average of Fund * '01S03 Weekday count by…
-
Can a List be Copied similar like Modules?
Dear Community, I have a basic question, many will feel it might be silly but still need to ask whether we can create a copy of the lists available in the General list sections like modules? If NO then why & if YES then how can we do it? Hoping to get answered by anyone of you soon!!! Regards,
-
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.
-
Cell history not being captured correctly
Hi All, I have come across a weird scenario where cell history of a Boolean formatted line item is not getting captured properly. For e.g. : In the attached snippet of a cell history of a module below are updates 1 - Data got updated after a bulk import to TRUE (History ID - 3994882) 2 - In the next update (ID -3996409 )…
-
Summing a percentage of a list amount from one module to another
Here is my situation: I have a module that contains a $ amount for a list of accounts , I am then mapping those $ amounts to another module that contains line items that I have in a List. In my screenshot you can see in Line item Mapto contains values of the list as well as Line Item Mapto2 contains values of the same…
-
Get the Sum of Column
Hi everyone. how can i get the sum of Lease Liability column in Module 1 and insert to Monthly column in Module 2 Module 1: Module 2:
-
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
-
Raised to the power of
Hi all. i want to achieve the formula with raised to the power of. I have this formula in excel which is =(S12/(1+($E$14/12))^(P12-1)) now how can i convert into anaplan formula? this is what i've got so far: Amount / (1 + 'REP00 SL Display Lease Details'.Implicit Rate / 12) ^ ('REP02 SL Lease Liability'.Period -1)
-
Regarding anaplan workspace access
I have purchased a Anaplan work space but still its approval is pending can anyone follow up this issue please ..
-
Importing incorrect data into "Actual" version
I've built an import and mapping logic to bring my actual data into my Anaplan model and everything is correct on the line item "Actual Expenses" as shown below. However, when I run an import action to move this data from the "Actual Expenses" line item (where it is calculated) to the Actual version of the "Plan Expenses"…
-
Anaplan New Workflow decision task
Hello all I have a question regarding the New Anaplan workflow . In the online course provided by Anaplan it says when a Decision Task is created and assigned for example to a user , when workflow starts that approver will see 3 option : Approve - Reject and Send back . i decided to create a Decision task but when it is…