-
Excel Add-in for Anaplan
Hello, We have been planning to incorporate excel add-in for a finance use case, and would like to take experiences of others using excel add-in. More specifically, we would like to hear and learn how excel add-in is beneficial for your team (does excel add-in facilitated collaboration or improvements in managing Anaplan…
-
Request "Freeze" enhancement
Request improvement to save the "Freeze" setting set by the user. This is because the current specification resets each page transition. We set it up every time and I think it is very troublesome.
-
Ability to change Font in UX
I have been asked by several customers about the ability to change font in UX. It is even more topical with the report page in UX. When you have invested in your brand and use a certain font you want to use that font in Anaplan as well if Anaplan is going the be where the report is created.I would say Bold, Italic and…
-
Is there a way where I can update a line item if the value is blank else do nothing ?
-
Dynamic List
I have two list: Target Center and Table Type: When a user selects target center I would like only the centers that are in the table type that is selected. For example if table type "FTE" is selected then Target Center list should be only "Board of Directors, Office of the President, and Legal" and if table type "SqFt" is…
-
Selective Access into a Line Item
Is there any way of bringing in a user's list of selective access items into a line item? E.g. if a user has selective access to products P1, P2, P3 in a products list, can I bring this in as a Boolean in a module dimensioned by users and products?
-
From Native Versions to Fake Version List?
Hi All, As it is not possible to SUM down native versions is there a simple mechanism to take data out of versions and restate it within a fake version list? I know this is achievable via a series of nested IF THEN ELSE queries but this approach is not sustainable as it needs to be updated every time a new native version…
-
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?