-
Allocations Impact Calc in Anaplan
Hi Experts, I have a scenario where we split our departmental expenses in a ratio ( a:b:c:d) and that ratio changes by sometimes quarter over quarter or year over year. What I would like to do is to be able to plug in the Quarters/Half year/Year I want to compare as inputs or selections, my department in question as an…
-
Uses of default versions or custom versions
What are the different disadvantages in using custom versions over Default ones.
-
Fiscal Year change
How to prevent data loss during the change of fiscal year. Suggest any ways.
-
List delete and Load
Imagine List A is parent and children are List 1 and list 2. List 1 and List 2 have same parent List A We need to delete and load So, where to start from is it from Parent or child
-
Regarding the versions
when we want the Actual version data of particular line Item to replicate into forecast version without using any formula or switchover.
-
Many to Many Relation - How to associate
Hello! I'm working on a demand plan model for a school book retailer. Since different schools may use different books, I must associate each store with the schools nearby in order to purchase the appropriate supply. Given that one store sells books from multiple schools and that the same school may be sold in multiple…
-
Lookup function - The formula is invalid:
I solved :)
-
removing lists not required
hi If as list is not referenced by its settings can the list safely be deleted? ie not referenced in anything below
-
invalid date or timescale identifier:
-
How can I Reference a Line Item from a module with time dimension in a module without time dimension
Origin Module: Sales p/Year Destination module: Present year stock calculation (I am only calculating this for this year, it does not have the time dimension) = Last year sales* Percentage x I believe this can be simple but I am not managing to complete this task, can you please help me?
-
How do I take MAX value of weeks and use it as my monthly value?
To illustrate Module A in Model #1 has a weekly time dimension My goal is to take the highest weekly MTA number of a given month and bring it to a new Model that's dimensioned by months and use the MAX weekly value from Model #1 as my new monthly value in Model #2 MTA's time summary in model #1 is set to Max When I brought…
-
Non-admin users self-restricting their write access in module
Hello, I'm trying to build a way for users to pick their access to their own line of products so they don't see others to avoid clutter and more importantly so they don't erase data that belongs to other people. So far I got my filters so everyone can pick their product line (A module named "Access" showing only the…
-
Expecting a logic
Hi Anaplanners, The setup is quite self explanatory . Rate% in the source module is a fixed set of percentages. It could be anything, the numbers shown above is just for the demonstration. Rate-Overlay in the Target Module is user inputted field. User is supposed to input the overlay numbers here. The yellow shaded field…
-
How to combine 2 item line in General List's properties?
Hello everyone, I'm new in Anaplan and I got problem now. Could you help me for this case? So current now I have data such as below : General List : Supplier Current now in my screen, I use to filter Product only using "Supplier" -> show Supplier A But I want to change it become "Code_Supplier" -> show as 001_Supplier A I…
-
Data not pulling from DAT module into Cal Module
Hi All! Beginner Model Builder here. I have created a TBH DAT module and trying to pull data into the CAL TBH Details Module - and some line items simply don't transfer over, while others do. I'm struggling to understand the reason why - can anyone help? Here for example I'm trying to pull Backfill vs. Net New line item…
-
How can we create action to load Existing items line item to Applicable Products line item.
This is the screenshot of the module containing both boolean line items.
-
Use Formula summary on a line item using Users list
Hi, I want to create a user filter to display on a board. Let's suppose this filter applies to a "Department" list, which belongs to a hierarchy. My goal is: when no filter is selected, display: All departments if the card is a grid / column chart (where departments are the column) → ok Total organization (ie top level of…
-
Anaplan export action list via POSTMAN
Hi All, I have this issue on not being able to get the list of Anaplan export actions or any other artifacts via POSTMAN. These are the steps I am taking - a. Authenticate — https://auth.anaplan.com/token/authenticate (I using basic auth and I am able to authenticate, and I am able to get the tokenValue. b. Model list -…
-
removing modules not required
Are there any circumstances (apart from classic dashboards which we don't use) where modules cannot be deleted eg when exploring the 'referenced by' blueprint viewing setting which is empty? My understanding if the 'referenced by' blueprint viewing setting is empty then the module could be deleted safely. However there are…
-
Level 2 Model Builder Training - access to Sprint 1
Having issue joining Sprint 1. I have confirmed 100% completed on the introduction. How do I proceed?