-
Set one column of source data as "Not Applicable" for this import
Dear Anaplan Community I am looking for a way to "ignore" one column of data from the source file as irrelevant when uploading its data into module. Source file contains columns as below. Column D is actually the code of Column C inside Anaplan model. And Column D is there because client wants visibility into expense type…
-
How to use OAuth authentication in Anaplan Informatica Connector?
Hi All, I am trying to test OAuth Authentication in IICS Anaplan Connector. Is there any documentation specific to the Anaplan Connector having steps for setting up the authentication available? I noticed we have documentations with steps for Anaplan Connect and API , but was not able to find any that involves Anaplan IICS…
-
3.3.5.3 Check Your Work | All products
Hi everyone, I have completed all the activities up to this point, but when I check my work against the correct results, the "Safety Stock Exception Count" is incorrect for "All Products". Can anyone help me? Thank you!
-
Import action between models not pulling through data
Hi All, I am currently having an issue with one of my import actions. I am pushing data from a saved view in one model, into a staging module in another model. I've checked the filters, mapping, and more and they all seem to be correct. However, when I run the action I am met with this prompt It shows that the import is…
-
Replace a nested If that has many if's
So i have a nested if statement that checks the status of a shipment. "cancelled" or "storage" first using boolean, the progresses through a series of dates to see which have been added, finally defaulting to "At Origin" if it has not left yet. Multiple IF's are not ideal, but I can't see how I get round this one. Even if…
-
Regarding anaplan workspace
Hi everyone, I recently applied for the Anaplan Talent Builder Program by May 13 and received an update. My application is being processed and may take up to 5 business days for approval. I’ve completed the prerequisites and am eager to start with the Anaplan workspace to work on the Level 1 and 2 certifications. Has…
-
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…
-
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'…