-
Capacity Model
Hi I am fairly new to anaplan and this is most likely the most basic question but I have created a model that indicates the number of "working days" within a calender period - my aim is to get the number of Days in a particular month that we have available to work. I have created the below model to get number of working…
-
Sorting Composite Hierarchies in Anaplan – Including Parent Items
I'm working with a composite hierarchy list in Anaplan for P&L reporting. The structure includes parent items like "Total Revenue" and "Total Purchases", each with their respective child items (e.g., "Revenue from Sales", "Revenue from Miscellaneous", etc.). I've implemented a Sort Order property to sort the list, but it…
-
How to bring Historical forecasts and actuals from the old SKU to new SKU
Hi Team , I am looking for the ideas to bring historical forecasts and actuals from the old SKU to new SKU . The Idea is we have NPI product which is actually a successor of the Old SKU with difference in some aspects such as packaging size. I want bring all the Historical data associated with old SKU to new SKU by some…
-
Polaris workaround for FIRSTNONBLANK
Polaris doesn't support FIRSTNONBLANK as a function parameter. I have a solution workaround for this already but not too happy with it. So wanted to know what solution workaround people have done to get around this limitation
-
How do I create a "Dynamic Bulk Copy" Action?
I'm looking to create a bulk copy action that allows me to select the source and target list items at runtime / when the action is run. I have some vague recollection I saw this available at one point with my own eyes, but everywhere I look on Community I find old posts that refer to the feature not existing. However, I do…
-
2 lists
I have a list with 5000 items. But If I want to add this list as a dimension in a module, the module is too big. Now, I don't need all 5000 items so I created a second list that has the 50 items I need. Then I can make a module CAL06 with all the dimensions I need. It's not too big anymore. So far so good In this module…
-
Is it possible to release single breakback cell in UX?
Hi, I have a question. When working in the module, there are three breakback-related options available, but in UX I can only perform 'Release all'. Is there any way to enable 'Release' for a single cell in UX as well?
-
How do I get the lowest value of all the years?
Hello, I need help in getting the lowest value of all the years. see screenshot below : I need to get the value -1,249,884 since that is the lowest Thanks
-
how to SUM by native users, sku & time dimension all together?
I want to do a SUM from the source module which has native users, SKU list and time dimension to a target module line item by all users by SKUs. Target module only has a subset of the SKU list and nothing else. Need some inputs on how to build the mapping for the SUM. Is it also possible with the Anaplan native users list…
-
how to count how many times an action has run?
I want to create a line item which will increment by 1 every time an action is run manually. This action is an import which doesn't involve any file upload to anaplan. The module where I want this line item has users list & SKU list dimension. No time. So basically, I want to track how many users have selected an SKU and…
-
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
-
How many bytes is a list item?
On community I am finding conflicting information. Is it 500 or is it 4? Any guess where these numbers came from?
-
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
-
UX Filter
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
-
How do i convert from a ragged hierarchy to a composite hierarchy?
I have my dataset attached below https://us.v-cdn.net/6037036/uploads/SAQ9CR8PDLSM/ragged-cost-dataset.xlsx
-
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
-
Create a Mekko chart in Anaplan
Hello Anaplan Community, I’m interested in creating a Mekko chart within Anaplan, but I’m unsure if it’s possible. I’ve read several articles but haven’t found any examples or guidance. Has anyone here created something similar? Thank you!
-
Fiscal Year 2025 and 2026
I am trying to configure Week 52 for the year 2025 to span from December 20th to December 31st and Week 01 for the year 2026 to cover January 1st to January 9th. Despite my best efforts, I haven't been able to find any articles or resources that provide guidance on setting up a customized fiscal calendar in this manner. I…
-
Time filter settings
i have a time settings module dimensioned by time and version. I need to check for months and years in one line item. Is there a formula i can use that will only allow me to tick for months and year and exclude Quarter?
-
Native version Limitations
I have created a time settings filter with native version as a dimension. I am suppose to tick true for all the actual months. In Actual version the actual months will be until Aug 20 (because my current period in model calender is Aug 20). A switchover is applied for budget and forecast which is at Feb 20 and Sep 20.…