-
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…
-
DEM04 Demand Export
Can someone please advise what the formula should be? I checked almost all the related discussions and tried all the formulas they suggested. I just cannot get the same result the course posted like this. if I try sum by supplied by or just the final forecast, the result is like this: If I try by location, all 0s. Is my…
-
Import Data Sources / Imports
When in the actions area, there are a couple of different tabs and I've performed some changes previously in terms of updating source models, etc when we have archived old ones, however I would appreciate guidance when looking between Import data sources and Import tabs - I've added elements to Import Data Sources, how do…
-
Boolean to time period
Hi I have a boolean line item checking months from jan-dec 2023 and I have another module which is time period formatted(months).I want a formula that applies to the first module through 2nd module that when a user select months from module 2 then the boolean is checked automatically in module 1.
-
How to populate a line item using formula with correct time scale in weeks.
Future year sales⬇️ Last year Sales ⬆️ I have two modules SYS9 Last year sales in which I have uploaded values by importing data and other module SYS10 FY22, FY23 & FY24 sales in which uplift value or % which is applied on previous sales value to give the future year sales value. In SYS10 module I have a line item Previous…
-
Level 2 Data Hub Historic Volume Importing Data Error
I need some help with these columns mapping can anyone guide me is this correct or not cause it's giving me An error ?? screenshots attached.
-
Avoiding Circular Reference
I have a list of Manufacturing Plants. The output material of one plant becomes the input for the next plant. The cost at which a material is transferred from one plant to the other is the weighted average of opening stock cost, production cost and cost of materials transferred from other plants. Since the cost of one…
-
Options for Override
Hi I have a module of manually entered data that needs to be reviewed and adjusted by an end user. The values often need to be overridden and there is a high possibility of the overridden value being zero. Also the overridden data will often be copied and re-used within the module across different dimensions What options…
-
help
In REP03 Profit and Loss Report module some of line items showing correct results but some are incorrect like headcount and car cost please help to figure the issue .
-
Certified Anaplan Model Builder Course
Hello please provide me the Link for Certified Anaplan Model Builder Corse
-
Using Bulk Copy for Custom Versions list(Production List)
Hi Community Members, We are using the custom versions list in our model and looking to utilize the Bulk Copy functionality. Since a human will not have workspace admin in production, we were looking to create a Bulk Copy Action but it only works on the non-production list. Does anyone else have an alternative solution?