-
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…
-
Calculate no. of days in each month
Hello Anaplanners, There is a requirement to calculate no. of days in each month based on start date. Suppose if start date is 5/15/25, then may should have 15 days, and going forward will have 30/31 days depending upon month and before start date it should be zero. My target module is at weekly level and I am pulling…
-
Conditional Formatting in Org Charts
Hi, Can anyone help in understanding what does the 'line item' selection does in Conditional formatting for Org Charts? Right now, this seems to be doing nothing. We have a requirement where we want to change the color of the node based on a line item value. I have been wondering if there was any way to do this? Any help…
-
Check combination in same list
How can I identify if the same record exists in my list? Below is example of same Region Country Month List Item 1 APAC India 25-Jan List Item 2 APAC India 25-Jan List Item 3 EU Germany 25-Feb Here I am expecting to highlight list item 2 because it's region, country and month are same and wanted to notify user. Can someone…
-
How to DYNAMICALLY Copy Data from One LIST ITEM to Another?
Hi Anaplan Community, I’m working on a use case where we have to work with templates (List: L_Template#), data pertaining to the template stored in a module (IM01 Input Data). We have given the end-user privilege to create N number of templates, now the ask is if we could Copy data in IM01 Input data of Template 1 to…
-
Clarification on Updating Model Calendar for New Financial Year
Hi Team, Could you please let me know the impact on model data when updating the time setting (model calendar) at the start of a new financial year? Additionally, I would appreciate it if you could share the precautions I should take before updating the "Current Fiscal Period" field to reflect the new financial year.…
-
Date into Time Period Month
I have a situation where i have a line item formatted as a date(lets name it dateLine), and another line item formatted as time period month(monthLine). Currently monthLine=Period(dateLine) which gives me result like :- jan 21, feb 21, etc. However because of Period function limitation of model calendar, for values going…
-
Use case of assign only
Can you share an example of where we would need Assign only action
-
Load FY-Level Data into specific month via Data Import Between Modules
Hi Community, I have a scenario where I need to push data from one module to another within Anaplan. Here's the setup: The source module contains data at the FY level (i.e., yearly summary), example FY25 The target module has the same dimensionality but is at a monthly granularity. I need to load the FY25 value into…
-
Delete from List Selection Action
We are trying to set up a Delete from List Selection Action. We have set up a Control module with a Boolean line item to determine what list items to delete. When we try to set up the Action, the control module is not displaying for selection purposes. The Selected using only refers to the one module: DAT01…” Both this…
-
How do I add Create action in NUX ?
Hello, I see one create action in "Actions" but cannot add that in NUX, how do I achieve this ? The same create action is in Classic dashboard though. Thanks in advance