-
Consolidating recursive modules
Hi I have 2 Lists and 3 modules as shown below. I want to build module 4 (details below) in the most efficient manner. Seeking ideas. Thanks in advance List: Employee ssL0Employee ssL1Employee ssL2Employee ssL3Employee Employee 1 Y Employee 2 Y Employee 3 Y Employee 4 Y Employee 5 Y Employee 6 Y Employee 7 Y Employee 8 Y…
-
Line Priority Allocation
Hi, I am having issues using the optimizer for production allocation. The model is for capacity planning. Problem statement Need to allocate the SKU demand to compatible factory lines based on the following logic. Each SKU has a production priority and a factory line priority. If the production priority for a SKU is 1…
-
2.3.8.2 Import into DEM01 Module
Hi I have an issue with the growth rates. any ideas please?
-
How to enable Override? button for end users and allow them to enter the Override Forecast Value?
I am not able to enable the Override? button for selection and neither I am able to enable the manually enter the Override forecast value for the end user, hence please help me get both of them enabled for the end user.
-
How to convert text name in upper case to lower case
I have a list with employee names all in upper case. E.g. DANIEL SMITH How can I convert these names in Anaplan to Daniel Smith (upper case on the first letter then lower case for the remaining)
-
Importing is not working
Hi, We are trying to import from one source to Anaplan but we are not able to import anything. We are able to export the data. please find the output below that we are getting when we are trying to import. { "meta": { "schema": "https://api.anaplan.com/2/0/models/B97129A7835A44D484A5008266AB711E/objects/file" }, "status":…
-
How to solve this error "Name cannot be mapped for a numbered list"
I am trying to load a csv file containing above properties in to a numbered list. and it throws me an error saying name cannot be named, but in the above case i didnt map the Name, I just mapped the properties. Can anyone please help me where am I going wrong?
-
Level 2 Sprint 2 2.4.8 Activity: Create Detailed Demand Review UX Page
I understand that little instructions in the said section is intentional, but I am hoping someone help me out break it to me, maybe rephrase to include a little more detailed, if possible. Thank you,
-
I want some help in using DCA - Dynamic Cell access
Hi, Below we have 3 line items in a same module, I want to apply DCA in such a way, If I select Country, Sub-region and Region should disable If I select Sub-region, and Country and Region should disable If I select Region and Sub-region and Country should disable. Can you help me in writing the formule for Read and Wirite…
-
Problem in building a dynamic Version to Version Variance Calculation
Hi All, I have a request by a customer to have version to version variance analysis done where, when a version is selected from a drop down for comparison the version name selected appears on the column header. And not version 1 or version 2 NB: Am not using a native version. The version used for the drop down is a custom…
-
Show "Used in Page" reference in Modules Settings
As a model builder, it would be extremely helpful to have a "Used in Page" reference in the Module Settings to show where a module is used in a page, similar to the Used in Dashboard feature. This would allow for much more efficient auditing and help tremendously with model cleanup. This is especially important since we an…
-
Performing Matrix Calculations in Anaplan
Hey, there I'm new to Anaplan and I'm exploring how to smoothly execute a matrix product within it. I have two modules: one resembling a (1,5) matrix and the other a (5,5) matrix. My goal is to perform a matrix product of the form (1,5) * (5,5) * (5,1) to derive a single number. Can this be done directly in Anaplan? If…
-
Ability to export the list of pages
As a workspace administrator I want the ability to export the list of pages, as it can be listed from the model, using an Export button, same as what's available elsewhere within Anaplan. This is needed to monitor the complexity. Anaplan are to support not only ease of adding build but also to manage the complexity of…
-
Harnessing LLMs for enhanced Anaplan planning
Author: Joe van Bolderen is a Certified Master Anaplanner and founder of Van Bolderen Consulting Group. Introduction AI is changing the business landscape. The integration of external AI systems, particularly Generative Pre-trained Transformer (GPT) models, into Anaplan's ecosystem marks a significant shift for the…
-
How to sum on a line item not a list
I would like to sum a line item based upon another line item that is not a list. So for example, I have the following: In this case, bananas is able to be listed twice because it is under different parents/countries. So I want to see the total for all bananas by summing based on the unique ref (which is not a list)
-
Ability to set Model default settings for Number line items
It would be useful to be able to specify a default format for number line items within a model. For example, within my model, I may want all numbers to be formatted to 2dp, comma thousand separated and with brackets to indicate negatives. Currently, I have to remember to apply this setting to every Number line item within…
-
Display source model in page bar even if user only has access to a single model
As an end user i need to be able to see the source model for any page displayed on the page bar, even when a page is only linked to a single model or when i only have access to one of the linked models. This is in order to know which model will contain the source data published on the page. It is also needed in order to…
-
Consistent Conditional Formatting Between Model Views and NUX Design
A view pre-built in the model with Conditional Formatting which is then published will not have the same look/feel compared to a card built manually in the NUX. As far as I am aware you are unable to edit the conditional formatting in a pre-built view in the NUX. I'd like the ability to have the same controls over a views'…
-
Ability to Search Deleted Pages
We now have the ability to restore deleted pages within an App which is a very useful feature. It would be very useful to have a search ability within the list of deleted apps for those cases where the number of deleted pages in the last 60 days is quite large and finding the page you wish to restore becomes difficult.
-
Level 2 Sprint 3 Exam
I have tried to take this exam. There are two formula questions where I provide answers that work based on the information provided. However, the system will not accept these formulas as valid answers. (Questions 3 and 9) How do I either have these formulas accepted as value or understand why they are rejected.
-
Folder Structure for Apps with Security
Currently we create an app for each area so it acts like a folder given here is only one level of Category within an App. We add a number in front so that the Apps go in the order we want. It also means that people can navigate via the menu which makes sense. Screen Shot We have only got Revenue in and running out of…
-
Multiple Roles to a single User
Hi, of what I know, it's not yet possible in Anaplan to set multiple Roles to a single User within a model. This would be a very useful enhancement, since it's very often asked from customers. User A —> Role 1 User B —> Role 2 User C —> Role 1 and Role 2 In this moment the workaround is to create a different Role for User…
-
1.7.3.1 Import into P3 SKU list
Hi, I am lost for this part. Where do I find the Build SKU?
-
New UX - Share My pages with other users
Being a Business User, I would like to be able to share My Pages with colleagues. Currently, I can only share App page via a link. However, if I prepare some modifications on My Page copy, I want to be able to share it.
-
Add items using action button in new UC for the selected hierarchy
Hello Team, I am facing an issue where i am working on list with hierarchy Plant>> Building>> Process>> Scenarios. I have imported the table in UX and using context selector i am on the view specific for process (lets say A). This table have Process A and 3 scenarios below it. Using Add button, i want to add 4th Scenario…
-
Conditional navigation - April 30 Platform Release
Hi, I am struggling to understand in the Aprili 30 Platform release how Annika built her page with the contents to the side where she clicked on a contents item and the picture changed. I undertand how the conditional navigation works but not the initial setup with the table of contents. Could anyone help out how she did…
-
How can I make a YTD average?
Hello, I am looking to get a YTD calc but I cannot use the YEARTODATE function because I need an average, not a SUM. And previous years should calculate according to their months (i.e. I would see a full 12 month avg for 2023, 5 month average for 2024). My initial thought is to use TIMESUM but am having trouble setting it…
-
Running week of sales anaplan
Hi Team, I am trying to get Running week of sales in Anaplan. Below is the scenario. I have 1500 quantity in current week .. i have a forecast of 500, 500, 1000 for next 3 weeks. want to see value of 2.5wks in running week of sales i.e.based on forecasted numbers . Can any one help on it
-
Level 2 Currency Conversion REP04 Local Currency
I have created model for currency conversion, all went well but at last after I add the formulas its not showing any data. Not sure where I am going wrong.
-
Experimenting with automated documenting
Author: Taichi Amaya, Certified Master Anaplanner, and Financial Planning and Analysis Specialist at Pasona Group, Inc. When I first started model building, I looked at the model map and was impressed by how easy it was to understand the logic of the model. Even now that we are dealing with larger models, we can look at…