-
Sum if on a quarter level line item
Hey i need a little bit of help, i want to sum month values to a quarter level value but the dimension isn't really time related its more like converted The right solution would be 7000 in 'New Quarters Value' on Apr 24. May 24 and Jun 24 actually a simple sum if The upper Month dimension comes from a list(property) which…
-
OEG Best Practice: Statistical forecasting
Overview The following is a guide for the Statistical Forecasting Calculation Engine Models (monthly and weekly). It includes enablement videos, practice data import exercise, model documentation, and specific steps when using the model for implementations. 1. Enablement videos and practice exercise…
-
SUM based on Line Item Value
I have a line item that has a list value. In another module, I would like to sum based on that list value -- without adding that list as a dimension in either module. Is this possible? I know this syntax isn't right, but it would be something along the lines of Source.Amount[SUM: IF Source.Line Item = List.Value]
-
Publishing subsidiary views in FluenceXL
Has anyone had any success publishing a subsidiary view line item in Fluence grids? I have a line item in a module that is a subsidiary view used for mapping GLs. I need an end-user to update the mappings. Fluence will not allow me to publish and edit the subsidiary view mappings since the dimensions differ from the…
-
Subset functionality for the versions where we can selective versions by Boolean
Its great to use subsets on the Lists but can we have same functionality in Anaplan versions? Because not all used cases require all the versions as dimension and this also increase the size
-
Percentage format flow when using Line item Subsets
having Line item subsets helps greatly but when we want percentage formatted Line item as the source and want that in Target Module with LIS as dimension the formatting is going away and it only shows as numbers(with no percentages) which shouldn't be the case
-
Ability to input text commentary with text formatting options in Management Reporting - New UX
While working on a project, a useful implementation emerged. Currently in Anaplan, via Management Reporting, it is possible to create documentation that cannot be customised by the user. In fact, the end user using the system can only look at the data and comments previously entered by the Page Builder. We tried creating a…
-
Lesson 6.6.4
My module looks identical to the example, except for one additional "YTD" column. Can someone advise how to get rid of that additional column?
-
Users are automatically getting deleted in bulk from Prod Workspace.
Users in the Anaplan Prod WS are automatically getting deleted and we are continuously receiving reports of users losing access. When I checked the history, it is showing that these users are deleted by <System User> so we are not able to figure out how these users were deleted.
-
How do I exclude zeros from a MIN aggregation?
I am building an output module to show some statistics around account pipeline by industry. I want to be able to show the smallest pipeline. Since some accounts have zero pipeline, the standard MIN function returns zero, but I want it to return the MIN excluding zeros. How can I do this? Here's an example of what I'm…
-
Can anyone share the link for Excel Add-in 4.4 exe file please?
I want to install Excel Add-in 4.4 exe file in my laptop. But I am not able to find out the link. Can anyone share the link for Excel Add-in 4.4 exe file please? Sharing the screen shot of website showing the link for Excel Add-in 4.4 exe file which taken few months back
-
want to know various reasons of UnMapping Issue
I have import csv file. which i mapped to Code to import the Data in to a module. After some when I ran the action its failing . When i checked the import mapping was not there. Want to know various scenarios for this issue
-
Time Spent on L3 Sections
I am planning to start L3 over the next week. Can someone provide a breakout of how long it took them on average to complete the sections below? Any feedback is greatly appreciated! Level 3 Model Building: Introduction Process Flow & UX Design (Time estimate?) Schema Design (Time estimate?) Sprint 1 (Time estimate?) Sprint…
-
Solution Architect Application : Can we still modify the modules ?
Hello Anaplan Community, I have just completed both the technical and knowledge exams for Level 3, and now I need to upload the model history and blueprint. My question is: Will we still be able to make modifications to our model after this, in order to prepare for the Anaplan Solution Architect application? Thank you,…
-
Problem with dimensions
Hello I have a question that I am struggling to solve: I have these two SYS module, Store City here is a property of a numbered list with store code I have second calc module, historical volumes loaded with this set of data And the third calc module, organized with formula. So far so good, the issue is that I cant come up…
-
Ability to change color of the BLUE Anaplan banner in order to quickly differentiate between models
A helpful enhancement in future roll outs would be the ability to change the blue Anaplan banner to that of a color chosen by the Administrator. This will allow for quick user differentiation between Training and Production models they have access to.
-
Pro tip: Process & Import IDs
When setting up data integrations the process or import actions are often referred to by name, however, this practice isn't robust and can cause process failures if names are changed in the model. During development and enhancements, a model builder may choose to edit the name of a process or import to the model. This…
-
Importing in Deployed model (Change data Source file)
I have an action import in deployed model to load the changes in the list and before, I able to manage data import sources to have a new source data file and it run successfully. But now I having problem in overriding the existing source data. when I try to manage import it says this "Deployed mode is enabled and you…
-
7.2.1 Activity: Import Data into Product Details Module Question
Hi there, I am having trouble importing data and I think my mapping may be off. When I get to the Product Details Line Items, there are no selections available. Can anyone advise?
-
July 2024 platform releases
Check out the latest Anaplan feature updates and enhancements in our July 2024 release notes. The information below offers supplemental information to that post. Planning and modeling On-Demand Calculation in Polaris Polaris will now only calculate aggregate-level intersection when needed, resulting in reduced model size…
-
NUX Or Classic Dashboards in Level 3 Certification ?
Hello, For the Level 3 certification, are we required to create dashboards using Classic Dashboards, or can we use the NUX instead? Thank you for your help, Noura
-
Current v Prior Variance
Hi Community. We have a situation where the Current v Prior Forecast Year to Date number is meaningless, and we would like to fix this if possible. It so goes like this, example Current calculates YTD to Week 34 Prior calculates Year to Date to Week 32 So if we look at the var to Prior forecast the answer is meaningless…
-
PlanIQ algorithm properties
Review the table below for information on each algorithm and its specific properties. Question? Leave a comment!
-
Level 2 Sprint 1 - L1.5.6.2 Import Data into Historic Volumes Module
Hello, I'm stuck on mapping Volume. It says manual mapping is unavailable but I can't see if items are matched correctly through 'Match on names or codes'. Other dimensions are mapped without problem so I don't know what to do with Volumes. Below are the mappings. Please help. Thank you! 😊 Candy
-
Is it possible to run external Python script from UX page?
Hi, The question is about the following situation: A user makes a change to the grid and I want to perform calculations for another line item. I have the calculation formula written in a Python script and I would like the end user to be able to run it from their UX.
-
Ability to call external scripts
Hello, Is there a possibility to run external scripts from Anaplan UX Pages? I'd like to run my Python Scripts with calculation formula from UX page using for example Button is it possible?
-
Reset Index number without affecting Data
Hey community members! I'm facing an issue with resetting the index numbers for List A in my project, and I could use some guidance on how to solve it. Here's the situation: I have a hierarchy consisting of three lists: A, B, and C. Currently, List A has reached its maximum index number. To give you an idea of the item…
-
Advice on Optimizing Combined Export List in Anaplan
Dear Anaplanners, I hope this message finds you well. I am currently working on a project that involves two separate exports: one containing Project and Project Code, and the other containing Bench Code. Refer excel snip with samples. The receiving system can accept both Project Code and NPI Code, but in Anaplan, we have…
-
My View on Classic Dashboard Sometimes Changes Options
Has anyone else experienced where My View has changed for a user? This dashboard is hardcoded to only show Actuals, but for some reason it shows Forecast for the user. As you can see the option is grayed out and the selector is not active. When I had the user changed to Master View and back to her My View, it's back to the…
-
Level 2 Sprint 2 DEM03 Growth Rate % line Item
For this line item, it is needed to align the dimensionality of the Source Module to Target Module, so that the Target Module can reference the Growth Rate % of the Source Module. See below for mapping reference: The issue I am having is that I am unable to properly map the formula. Resulting in various error messages. I…