-
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?
-
How to review model build
Hi Anaplaners! In our organization we review models built by junior and middle analysts. Checking every formula and finding inaccuracies takes a lot of time and energy. Could you share the way you deal with this? Thanks, Kostya
-
Boolean Filter
This module consists of E2 Employee# list and 2 line items, one is to filter out the employee whose department needed to be changed. When I applied the filter and enable it all the unchecked line Items vanished. what I need is, when all is unchecked the list should appear and when one list member is checked it should…
-
Formula for calculating Time Coverage
Hi everyone! I'm having trouble in resolving these request in Anaplan. Basically I've got 2 line items in a module with Time Scale Weeks: Expected Sales Quantity = Qty of Product that is expected to sell in every week Final Stock Quantity = Qty of Product in Stock in every week The request is to calculate for each week of…
-
Changing parent in numbered list
In this numbered list if we select Parent from the drop-down list the department(parent) of the selected employee will change and will be reflected in all the module that has referenced this List. How can I make an action to publish it on the dashboard where the user can change departments for the employee, should I create…
-
Error when Exporting Text formatted Number: Missing Leading zero
I have a text formatted line item called Company Code = "0505" When I export the module, I noticed that the Company Code becomes 505 instead of 0505. Why was the leading zero removed when I exported it? To solve it I created another line item thats number formatted and called it New Company code = VALUE(Company Code) The…
-
Dynamic read access
Hello, wondering if anyone has a solution to this problem? I have a business with 3 sites: A, B and C. This is captured in a 'Site' list in Anaplan, which contains 'Site A', 'Site B' and 'Site C'. I've set up 3 user accounts for each of the 3 site managers, such that site manager A can only see Site A in the 'Site' list,…
-
How to create saved view with specific dimensions
I want to create saved view but mudule having 4 dimensions and for saved view I only want 3 dimensions so how do I create a saved view of that module. Please suggest a solution for it.
-
Formula - not pulling anticipated results
Currently attempting to pull data from a calculation model that created into a separate module that we use to export data - essentially referencing using an export code and a currency conversion selector - which using the latter, should only pull one of the values , either "Constant" or "Latest" through, however it seems…
-
User wants to change the employee's department.
Hi, There are lists (Department and Employee where the Department is the parent of Employee). I want to make a UX page where the user can select the employee and change his department, therefore details of the employee such as salary will reflect in the new department. Please let me know how I can achieve this. Thanks in…
-
Scenario planning across multiple models
We have 3 to 4 different models that feed from/to each other where we need to perform connected scenario planning across all models. For those who have had to develop this functionality. I wanted to check how you've implemented it, pros and cons of what you did and if you could do it again if there was anything you would…