-
Use value referenced from a diff module
Hi All, noob here, just started my Anaplan hands-on journey today. Hope you can help me 🙂 I'm looking for the right formula to get value from a module to a different module based from an existing module data. Below I have two modules. Loans and Lookup Rates In Loans module, I have two line items called Term and Rates. I'd…
-
Add Show Imports/Show Targets to Modules
Please allow model builders to view, from the current module, a list of all of the imports to the current module and a list of all of the targets (i.e. imports that use the current module as an import data source). The current process of resolving import issues from a module is tedious - from the current module a model…
-
Remove a selective access by import
@Tomishand I recently needed to have the ability to remove selective access for certain users from a selection module and a model-to-users import. The documentation on Anapedia is not very clear on the subject so I thought I’d detail the steps here. We import the code of the items to add in the Read / Write though…
-
Development Practice
Do we have any Workspace to practice and develop models in Anaplan. I want to practice and Learn.
-
About Workflow
Hi, I want to use "Workflow" two times like this. Step1 : Demand Approve. Step2 : Supply Approve. This means, First Employee make a demand plan, and get approval from Manager. Next Employee make a supply plan, and get approval from Manager. The problem is when step 1&2 run together. Workflow has one flow, so I think I…
-
level 2 vilt - 7.3.1 Create Demand Forecast UX Grid Saved View
I can't seem to create a pivot view to resemble Grid UX Please see attached - view required and my view please advise ravinder
-
INV01 Line Item Formulas
Hi, Would like to know if my Line Items are correct. Please advice The Line Items are on the attached pic. Thank you
-
Bridging Versions With Waterfall Charts
General Requirement For a set of measures, end users want to be able to choose any two versions and see the calculated variances between them. They also want to see a visualization in the form of a waterfall chart that explains the difference between the selected versions. Problem Statement Let’s say we have a summary…
-
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2 While importing the location.csv into the SYS07 Location Details module, the region part is not uploaded properly. why? because: It is the reason that region flat has 3 line items: AMER, EMEA, APAC. However the csv DATA file attributes the…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
i am trying to run process 9 but i got this error can somebody please! help me
-
Which functions support "Formula" in the summary method.
Hello, Is there a list somewhere that shows which functions support "Formula" in the summary method?
-
How to create a time filter module
This article provides the steps needed to create a basic time filter module. This module can be used as a point of reference for time filters across all modules and dashboards within a given model. The benefits of a centralized Time Filter module include: * One centralized governance of time filters * Optimization of…
-
Add line item count for list subsets
It would be really helpful to see the count of list members that are included in a line item subset. The only way I can do this is to make a "Master" list with just the subset and a line item called "Count" and see what the total is, but this takes up unnecessary space. But it would be nice to simply go to the list, click…
-
Showing selected version in a line item
Hi all, is it possible to show the selected version as a line item in that module? For e.g., I have 3 versions in version settings and have a module with these versions as a dimension: Actual Version 1 Version 2 Can I create a line item that automatically shows which version has been selected? So the line item should…
-
Erlang A
From a callcenter planning perspective we currently have Erlang B and Erlang C, which allow customers to compute the SLA given an amount of calls and their staffing level. The industry is starting to look more at the amount of calls answered as a percentage of total calls (TCA) as a way to determine staffing. In order to…
-
How to convert Weeks to Month?
Hi All, I have a list with custom month format and the list code is 'mmm-yy Code' example: 'Apr-21 VLIB0065E' (below image) However, the source file i have received is in Year-Week example '2021-01' (2021 = Year, 01- first week of 2021 which is Jan) How do i convert weeks to month?
-
Migrate Line Item Subset changes as an earlier step when using Revision Tags
I recently encountered an issue where I had performed the following steps in my development environment: * Turned off automatically add new items in a line item subset. * Added a new line item to the module where the line item subset is driven from. * Set the new line item to have the data type of No Data. When migrating…
-
Lock overwrite of snapshot
Hello, I am currently working on a scenario planning model, where I have two custom versions lists. My first list is a "modeling scenario" list, which is user editable. And once the users decide to lock their assumptions, they create a new "snapshot scenario" and run a process to copy over the data from the modeling…
-
13.6.1
Hello! My apologies in advance, but I seem to have lost my notes on how to "hide" a line item. Specifically, "Unit Price Growth % and Unit Cost Growth %" should be hidden. Thanks for your help!
-
Pull the data from child list to parent list
Hello Community, I have the next list named BOM Lvl 1 List, with a Total Price Column, But, I need that if Semi-finish are TRUE, go to the list named BOM Lvl 2 List, and pull the price, adding up the price of the children: Thanks!
-
Helping Customers Implement New Functionality and Features
In the 16 months from March 2020 to July 2021, business, government, and social organizations in the United States have faced unprecedented challenges to their very survival, as well as vast uncertainty about when there would be a return to normal economic conditions, or even what “the new normal” might look like. But now…
-
Count number of parent for Unstructured List
Hi Team, I am trying hard to calculate the number of parents for individual list items for unstructured list items. Kindly let me know in case of an optimized formula IF NAME(PARENT(ITEM(Region_Group))) = "All Regions" THEN 1 ELSE IF NAME(PARENT(PARENT(ITEM(Region_Group)))) = "All Regions" THEN 2 ELSE IF…
-
Level 2 Sprint 2 Testing Role
Activity 2.4.11 Testing Role Created Product Family Manager Role and then assigned myself this role. I did not make any change to Workspace Administrator. After testing, I changed my Role back to 'Full Access'. But now, I cannot access the Modules I created eg. DEM03 P3 SKU - no access, Accounts - no access. What went…
-
Workflow process approval
Hi, question please. I am doing a workflow process approval that once the preparer/inputter submitted to the approver the input cell will automatically locked. Is it possible that the input cells will not be locked to the approver side once the preparer submitted it, which means that approver can edit the numbers in the…
-
INV01 Suggested Order Amount for the Month
I am going backward to find an error in my model and was hoping someone might be able to give me direction. In my INV01 Module the Suggested Order Amount is coming out as 8,195 but in the training it shows 8,149. I have traced backward to DEM03 where my Final Forecast shows 8,194. Went back even further to try to figure it…
-
Ability to define line item 'applies to' when adding that line item to a module
As a model builder, I would like the ability to define the 'applies to' of a line item when creating and adding it to a module. This enhancement could work by enriching the current box for adding line items and allowing users to set the applies to at this point The benefit of this would be the ability to add line items…
-
Level 3; Sprint 1, Section 6.3
Hello, I am trying to verify the model as part of 6.3. But the numbers are mismatching a little. Initial Account Sales Target from my build: Screenshot from the training material section 6.3 File received from the training material and used for calculating the Initial Account Sales Target by Country and by Product Family.…
-
Disable 'Is Summary' by Default
Please can 'Is Summary' be disabled by default and require model builders to enable the setting. With the recent update to the blueprint view, this setting has become more hidden.
-
Easier Model to Model Data Transfer
Are you transferring data between your models or do you want to transfer data between your models? If so, do take a look at our Cloudworks functionality. This article introduces the concept of the new Cloudworks features and functionality and including details of how to set up. Check it out. Remember: You can't plan…
-
Variance - calculation
Hello, I have created a module with multiple line items and values for FCST and Budget. I need to calculate the Variance which has a different formula for each line item. What is the best way to do this?