-
How to Ensure Full Data (line items) Clearing in Anaplan Imports When Incoming Data Is Partial?
Hi Community, I'm facing a challenge with data clearing during imports in Anaplan, especially when the incoming data only represents a subset of the target module. As many of you know, by default, Anaplan imports only replace the cells represented by the incoming data. This means that any existing data not included in the…
-
Returning a list member's code based off a unique property?
Hi all! I have a module with a line item for "SKU" (text format), that lines up with a "SKU" property (also text format) within a specific list. In that initial module, I want to return the corresponding code for the list member with that matching SKU property. Example: List: Item Number List Member Code: 123 List…
-
Process Run time Duration has Doubled - Trying to Identify the root cause
Our company recently underwent a merger and we took over a company, this means our model now has become bigger overall - New SKUs, New Customers , new Production lines etc. The size of the model: before go-live with merged entity: ~50GB After go-live with merged entity: 79 GB Agree and understand that the model size…
-
Editing different levels of the hierarchy - has anyone built something similar?
Hello Anaplan Community, A client wanted to be able to show different levels of the hierarchy in one table, but also to be able to modify all line items belonging to different levels ( like in Excel) I thought about this for a long time, and the only way I can see it being possible is through a flat list where I bring all…
-
3.5.5 Activity: Create Distribution Center Summary UX Page
When I done 3.5.5 Activity, I have 2 questions,Please help me thanks. 1.I want to know what's the way to get it. My Result: Expect： 2. now,there is a space line on the header, I want to hide it,but I don't know how to solve it. My Result: Expect：
-
Migrating Data from Testing to Prod
Suppose I have both production and testing environments. I need to move some data from testing to production. Should I create an action for this? I believe creating an action requires using a standard model. If I go that route, will it affect the links between development and production, or development and testing?
-
Cumulate Formula breaks for new list member
Hey All, Really weird issue, and I have no idea what the cause is. I added a 'Q2 v2' custom version list member & bulk copied the 'Q2 v1' data into 'Q2 v2'. While reviewing the data before granting end users access, we found a cumulate statement isn't working for the new version. All other aspects of the model seem to be…
-
Copy Over Version to Version
Hi Anaplanners, I’m working with a model that utilizes Native Versions across all modules. We have multiple scenarios set up, including Actuals, 3+9 Forecast, and 4+8 Forecast versions. The current task involves copying data from the 3+9 Forecast version into the 4+8 Forecast version, but only for specific modules, not…
-
How to compare and find single value from another cell containing multiple values separated by coma?
Hello Anaplanners, I have a scenario where I need to compare and find one value from a set of values present in another single cell. Let me explain with demo modules Source Module - Veggies and Vendors Target Module - Veggies and Vendors Target Here in the Target module, while using the given formula I am able to validate…
-
Future year to grab actuals data
Can someone please help me with a formula that grabs data from a prior period (actual) for future forecast months and years? For example, I want 2025, 2026 and 2027 to be the same data as 2024. In my example, the switch over is currently on Feb 2025. Jan 2025 is actual but in Jan 2026 and Jan 2027, I want to use what is in…
-
Anaplan optimizer - cumulate function
Hi guys, We are currently working on an optimizer, and one of our constraints is a cumulative function (monthly quantity accumulation to consider). However, the optimizer doesn't handle the use of functions in its constraints well. Has anyone encountered this issue before? I can provide more details if needed. FYI it works…
-
How to convert a date into 2digit format text DD/MM/YYYY
Hi, I'm trying to convert a date into a text line item but Month and Day sometimes have only 1 digit when I need two. Do you know how I can achieve that ?
-
How do I setup a Time Filter that identifies if the current month falls under the current quarter?
Hi, how do I setup a Time Filter that identifies if the current month falls under the current quarter? To be specific, I want to aggregate the values of line items for specific months that falls under different time periods such as: 3+9: Aggregates the values of the months April to Dec 6+6: Aggregates the values of the…
-
Export view to hub
Hi, I cannot find an answer to the described issue below. We need to export view to the Anaplan Hub (but we have option only locally) Can it be done?
-
Sparsity of data
How does the Relative dependency of dimensions affect the sparsity of data? Please help me understand with examples.
-
Add Version Formula
Can anyone share a use case or an example where the 'Add Version Formula' would be needed? I'm a bit confused about how to implement it, so any example would be helpful.
-
Kindly help me to understand how I can achieve this?
I have two modules. In the first module, when I select "America," its child fields should become editable. If I change the value of any child field from zero to a non-zero value, all other child fields under "America" should become non-editable, except for the one I modified. If I revert that value back to zero, all child…
-
Dependency on both Parent and Parent of Parent
Hey guys, Can someone offer some ideas on how I can setup my manager drop down to be both dependent on Sales Team and Sales Sub-Team on the scenario below. This filter module is dimensioned by Users. Scenario 1: When Sales Team and Sub Team are blank, Manager is blank Scenario 2: When Sales Team is selected and Sales…
-
Any way to find out which user joined the Anaplan workspace and at what data and time?
I have a requirement to sort based on when users joined the Anaplan workspace.
-
Is there a shortcut to go to the module referenced in a formula?
Some of my time is spent working through models to see how everything is connected and im just wondering if there were any shortcuts to access modules referenced in formula more quickly? Currently i'm looking at the formula and then manually locating the module from my modules list to then open it. If no shortcut exists I…