-
Mark list items as subsets with import process.
How can we create an import action for production lists where we can import data and mark it as a subset while importing so that only selected list items get added as production data, and we dont have to mark each item seperately, so that we're able to use these list subsets as dimensions instead of the whole list in…
-
Bulk Copy Failure
The Bulk copy at my org has failed for some reason, The bulk copy was run from the versions tab, and a specific list was used (which is production data ticked). What sort of trouble shooting can one do for this issue? I cant run the bulk copy from the actions tab as it wont show the list (being production data ticked). And…
-
Mismatch on common dimensions
Hello, Would anyone be able to advise why (in very simple terms) when we add CC7 (a mapping list) to the applies to of the value row, we get the error "Mismatch on common dimensions". The LIS used by this module picks up line items from FS1-Regional which in its-self has CC7 as an applies to dimension. Kind Regards,
-
Anaplan workspace
Can someone kindly provide me with assistance. I have completed the talent builder application and was approved access to the workspace. However, i was emailed a link to set up, but the link expired. I have emailed the support team (over 3 days ago) but I havent received a response. Can someone please advice me on what to…
-
Reverse Lookup for a List to List Mapping (more than one mapping)
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
-
Generate Unique Codes for List Imports with Long Text Values
Hi ALL, I'm using Product Category, Product Line, and Budget Type to generate a unique Code for a list. The display string is generated as: Product Category & "_" & Budget Type & "_" & Product Line. The Code is currently generated using: LEFT(Display String, 60) The issue is that Product Category and Product Line contains…
-
How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
-
Native function for Date & TimeStamp
Hi, is there in Anaplan the possibility to retrieve current time (date and time)? I know that now this is possibile only via integrations, but I will need to know if there is a native function.
-
Recommended Design for Determining Whether a Source Combination Exists in a Target List
Hello Anaplanners, I'm looking for advice on the best modeling approach for a DCA use case. Scenario I have an input module called "CC-Account Activation". It is dimensioned by: Cost Center (CC) Account Users can select an Activate? boolean to indicate that a Cost Center / Account combination should be activated. I have a…
-
Today's date
Hi everyone, I'm looking for a way to retrieve the current date (today's date) directly within an Anaplan model, without importing it from another model or module. We're facing an issue because our application is used by teams across multiple regions and time zones. For example, users in one region may have already moved…
-
Group Workflow Task
Hello Anaplan experts, I have created a workflow template with several group tasks. I have assigned these task to several users. Question: am I understanding correct that a group task is considered complete only when all users have completed it? I have tested and found out that if one user has completed a group task but…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi, I am stuck in trying to get the output of the below: After following the instructions my output is as below. From Jan 25 onwards my fields are empty whilst the desired output above is filled: This if the file i am uploading with both Actual and Budget, however when i upload it does not seem to be uploading the Budget.…
-
Scenario Issue
For some reason, when adding a new scenario, our enrollment numbers double instead of projecting normally. This begin occuring after the roll over process. SS with two scenarios in model. shows the same on base case SS with only one scenario in model Formulas not really sure where the duplication is happening.
-
Modules - Beta Version
I have a question regarding the new Beta module creation experience. In the current UX, when creating a new module, we have the option to create a new Functional Area directly from the module creation screen. However, in the Beta version of module creation, I no longer see the option to create a new Functional Area. I do…
-
Combined grids with the same module
I would like a combined grid with Customer-Products, Sales history up top the current week and and Forecast data for the future weeks. The Sales History and the Forecast are in the same module, dimensioned by Customer-Product and weeks. I can filter the columns in grid2 and grid3 to show past and future weeks as required,…
-
10.2.6 Activity: Add Formulas to Employee Expenses Module
Hi All, I am getting the result below: When the result should be: This is my EMP01 Module AND the blueprint below: Can you please assist in how to get the desired result ? Thank you
-
9.2.5 Activity - Adding the 5%
Hi All, I have gone through the forum and the replies given to answer this question have not been helpful. Can someone please advise on how to do this as the FY24 cell is greyed out in my view it is not blue. Thank you
-
9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module
This is the error message i get: Format of mapping used for lookup doesn't match any dimension of the source I am new to anaplan so i am learning whilst also trying fix errors. This the formula i enter 'REV04 Price Growth Rates'.Unit Cost %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product…
-
What are limitations on UX 'Drill down', up to what level of hierarchy drill down works?
Can we find somewhere documentation about UX drill down feature? UX is sometime showing underlying data upto 5 levels in hierarchy but doesn't work 6 or 7. Appreciate any pointers on limitations on this feature. Business wants to know up to what levels in reports they can analyze underlying data.
-
How to replace YEARVALUE() in Polaris?
I' am migrating data from Classic to Polaris. I have a metric at the intersection of Market, Item, and Division that is calculated as Current Amount / Annual Amount. I obtain the annual amount using YEARVALUE(Current Amount). In Polaris, I cannot use this formula as a summary, so when data rolls up to higher hierarchy…