-
Level 2 - 1.6.3.2 Import Data into DAT04 Distribution Center Parameters Module
L2 - Sprint 1 - 1.6.3.2 Import Data into DAT04 Distribution Center Parameters Module * Download data file: Weekly Safety Stock.csv. * Import data file into the DAT04 Distribution Center Parameters module. I am trying to do the mapping Distribution tab map is not coming properly Please help to resolve the issue . Regards,…
-
Ability to rename a line item without breaking the import mapping
Description of the enhancement: If a line item which is used as the source of an import is renamed, its mapping is removed and the action must be re-mapped. To re-create: * Setup an import from "LineItemA" in ModuleOne to LineItemB in ModuleTwo. The line items will need manually mapping since they have different names. *…
-
Save a custom palette of colors for use in UX pages
Most companies have brand-specific colors they use for fonts, icons, logos etc. When implementing building pages in Anaplan I attempt to use their colors where possible (and reasonable). UX page builders can currently pick from a set of colors for body text fonts, or even specify the hex value for a specific one (which is…
-
Can a module dimension be used to enable Sum, Data entry, and Total (without using Line Items)
Hey guys, I'd like to create a module with multiple line items (in my case, a cash flow statement - snip below), where the module has a dimension that allows: 1) Formula to populate the mapped answer into the 1st member of dimension 2) Data entry in the second member of the dimension (e.g. to manually re-allocate part of…
-
How to resolve the import error - New property combination found but name or code already exists?
Hi all, I'm trying to use an import action where I have a unique key in the source (Source is a module in another Anaplan model) This unique key is a concatenation of 6 parameters. I'm getting an error - New property combination found but name or code already exists I've checked the source & there are no duplicates. I've…
-
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…
-
FINDITEM with Line Item Subsets
Hi Is it possible to use FINDITEM with line item subsets? Thanks Kristen
-
Aggregation of text and images in Hierarchy Charts
When Hierarchy Charts were introduced to the Anaplan UX, their popularity grew very quickly. The power of the intuitive visual representation of business hierarchies, and the simplicity of setup, combined to fuel substantial adoption by hundreds of our customers. At its’ simplest, the structure of a hierarchy can be…
-
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…
-
Line Item Name change
Hi All, I have created a mechanism by which Line Item name can be changed using a Process/Import. It works perfectly fine in Standard mode. But, in deployed mode it shows an error " Deployed mode is enabled and you cannot change the structural data of this model. Change to standard mode if a structural change is required."…
-
How to dedupe txn assignments on owners that appears in multiple assignment columns?
Hi all, I have a module, which is dimensioned by Txn, and within this module, I have a few columns where I can assign owners. Txn Assignment Module: Parent Account Name Oppy ID TXN Name SOL Terr SOL Terr 2 SOL Terr 3 BMO 111 1 Loner's Territory BMO 111 2 Loner's Territory BMO 112 3 Loner's Territory I want to create a…
-
Saving any data against parent members in a flat hierarchy or derive their levels.
Hi, As part of our use case, we need to publish org charts. After careful consideration, a flat hierarchy works best (not as per best practices, I understand), but when it comes to publishing KPIs on Pages, it seems almost impossible to calculate something at parent level. e.g. Here is the list. It's a flat Hierarchy How…
-
Set text encoding format for anaplan connect script upload
Hi, I would like to specify in an Anaplan Connect script that UTF-8 text encoding should be used for the file I am uploading. Does anyone know the command for this, or another way to make this happen? Thanks!
-
Fp&A case study access
Hi, I am not able to access 299 FP&A case study. Please provide the access for the same. Thanks Nitin
-
Count Unique Items Function
Hi, I have 2 lists, 1 is products and 2 is numbering - see screenshot. I have a module where it is dimensioned by product and the numbering and I want to count the number of unique values. Based on my screenshot, it should be 15. I saw there was a formula - isfirstoccurrence, but I'm not completely sure how to use this.…
-
Lookup error : invalid lookup list X is unused
Hi guys, I am facing an error for the first time and I was wondering if anyone had an idea on how to get throught it For some context I have : LI1 reference dimensionned by "Dimension A" format number LI2 target dimensionned by "Dimension B" format number LI3 dimensionned by "Dimension A" format "dimension B" (a basic…
-
Unlocking the power of Polaris: A guide to efficient model building
This article is part of a series on Polaris best practices. Click here for more Community content or visit Anapedia for detailed technical guidance. Polaris is Anaplan's next-generation calculation engine, designed for highly dimensioned calculation at scale. It represents a paradigm shift in the ability to model business…
-
Reverse BOM recommendation based on Attributes
Hi, Consider this scenario for a Diamond Industry supply chain Demand for Diamond from customer comes with various attributes [cut, carat, clarity, etc etc] Prospect has made over the years diamonds with various attributes. This historical data is available [both BOM and Recipe]. There is a unique Stage 1 BOM and Stage 1…
-
Ability to create ragged hierarchies with numbered lists
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: The ability to create a ragged hierarchy with parents of the list member being present in the same list help with certain…
-
Selection of multiple option from list on UX pages
Hello Anaplaner, Please find the attached Excel sheet along with the use case description below. We have a use case where the end user requires a selection option on the UX page from a list (Product & Company). As you may be aware, there is currently no option available on the UX page to select multiple list members from a…
-
INV02 - Safety Stock Flag Count line item formula - Level2
I need some pointers to tell me what went wrong. 1) i created SYS08 SKU Details a column Country made in-----PARENT(Supplied By) 2) In INV02 i used the formula---- 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS08 SKU Details'.Country Made In] but i came out the error below. I have P3 aggregated to P1 in…
-
Enable Sorting by Columns or Rows in UX Worksheets and Boards
Description: Currently, Anaplan UX allows limited sorting capabilities, primarily focused on rows in grid views. However, users often need to sort data by columns or rows, depending on the layout and analysis requirements. This limitation affects usability in both Board and Worksheet pages, especially when working with…
-
Enable Right-Click Functionality on Any Cell Within a Row to Add/Delete List Members in Worksheets
Description: Currently, the ability to add or delete list members in Anaplan UX worksheets is limited to specific interactions, often requiring users to click on the row header or use action buttons. This can be unintuitive, especially when working with hierarchical lists or when users are focused on cell-level data entry.…
-
Ability to Default Close the Additional Insight Panel in Worksheet
Description: Currently, the Additional Insight panel in Anaplan worksheets is set to open if there are cards in the additional insight pane. Proposed Enhancement: Introduce a setting or toggle that allows page builders to default the Additional Insight panel as closed for a worksheet. This could be implemented as: A toggle…
-
Enable Native Reporting from Model History Logs
Description: Currently, model history in Anaplan is only accessible via manual export and review, which limits its usability for ongoing audit, compliance, and operational reporting. Users must download the history file and process it externally to gain insights into model changes, user activity, and data updates.…
-
Enable Case-Insensitive Filtering in UX Pages
Description: Currently, filters applied in Anaplan UX pages are case-sensitive, which can lead to inconsistent behavior and confusion for end users. For example, filtering for "North" will not match "north" or "NORTH", even if they refer to the same logical value. Proposed Enhancement: Introduce an option to make…
-
Enable Moving or Copying MyPages Between Models
Description: Currently, MyPages are tied to a specific model, and there is no native functionality to move or copy them to another model. This limitation creates friction for users who: Build personal pages in a development or sandbox model and want to migrate them to production. Need to replicate similar MyPages across…
-
Ability to perform "Insert Multiple Items" function on Board Pages
Today, you can add more than one list member on a worksheet via a "right-click" > Insert multiple items. However, you cannot do this same action on a board without creating an Import action that temporarily locks up the model. This impacts model builders and architects when designing UX pages and all end users needing to…
-
Multiple Lookups into DATA... module?
I have 3 hierarchies, Customer (C1-C9), Developer (D1-D3) and Product (P1-P6). I also have a combined list C10 which is C9_D3_P6. I have a DATA Rebates module with a LOAD list dimension and properties for C6, D2, P3. I have a reporting module with C10. I've also got a PROP C10 module with line items for each of the items…
-
History Pull Inconsistent Record
I pulled the history log for a specific time period and filtered it by module, line item, and list items. I'm trying to understand how to interpret this history: Row 1: Previous value was 0.5 → changed to 1 Row 2: Previous value was 1 → changed to 3 Row 3: Previous value was 0.5 → changed to 3 Row 4: Previous value was 3 →…