Modeling

Help with a date range
Hi everyone, I'm trying to create a date range filter for dashboards. I have data that is at Day level. When I add a Start Day and End day, the UX grid should only show those days. Has anyone done something like this at Day level? Appreciate any help.
How to Disable a Parent Filter When a Child Filter is Selected, and Vice Versa?
Hello Anaplanners, I'm working on a filter setup where Category is the parent of Task in a hierarchy. I need help implementing the following logic: The Category Filters should be disabled when any of the Task Filters are selected. The Task Filters should be available when none of the Category Filters are selected. If a…
Multiple Model Dashboard
Hello! I am trying to create a Dashboard which has 3 different data source MODELS. I am creating the grid view as per different models, e.g. 1,2,3. Though each has its own MODEL data as per filter, when filter is set to first model 1,3 shows the same model data while 2 shows blank(as it should). How to make 3 work the same…
Breakback with rounded integer numbers
Hi, Is it possible to set a Breakback function with auto-rounding? We're working on a project where exploiting breakback is useful. Product units should be integer, never fractional, but we can't find how to auto round numbers derived from breakback function without setting a process. Is there a way to let user insert a…
3.4.3 Activity: Create Country Summary Module
Hi All, I am stuck in this exercise almost 2 hour, not able to proceed further. Can anyone please help? I have added line item "Country Made in" SYS08 SKU details module. Now i know that the formula in Safety stock flag count would be 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country…
Create Shipping Export Module and Create a Saved View
Hi Team, I have been struggling for a long time here in the INV05 Shipping Export module below is the blueprint mode: Below is the layout for my INV01 Inventory Ordering module The formula for Shipping Costs is as below: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 units'[LOOKUP: 'SYS08…
OEG Best Practice: Data Hubs: Purpose and peak performance
You may have heard about a model called a Data Hub, but perhaps you aren’t confident that you understand the fundamentals, primary functions, or considerations when architecting one. There are three main advantages to incorporating a Data Hub: Single source of truth : Stores all transactional data from the source system.…
How to get the first non-blank value from a line item to another module
How to get a value to another module for the given selectors, the first one which is not blank? I always have one value in historical sales name and I want to transfer it to another module. And then how to transfer the value that is next to the line item Value Min
Is it possible to display different line items in one module for different levels of a hierarchical
Hello, I created a module that has a hierarchical list structured as below: I added line items to the module such as: -Revenue -Lattitude -Profit -Count Active -Count Closed -Count Open But it is not important what line items I have, what is important for me is how to make it so that after selecting, for example, an item…
DCA and Create (form) on UX
Hello, I have trouble with the creation of a new item in my module using Create form on the UX. I have the error " Failed to create item ". The line item that is in my module is ruled by a DCA, allowing it to be editable only when the "Modify?" boolean is checked by the end user. Do you have any idea on how can I manage to…
Allow User to Enter Comments at Parent Level?
We have a text-formatted line-item where we want users to enter comments at both the child and parent levels. The current solution works fine for the bottom level, but Anaplan won't allow comments at the parent level (Marketing - Corporate Memberships). Is there a simple fix to this issue?
Modules or Actions Used in NUX Pages
Currently we are able to see where a module or process is used on a Dashboard. We need to have a similar ability for the NUX which warns or stops you deleting an object if it is referenced on a Page or App.
Email notifications : Sending Email Actions without using mailbox
Request from Amgen Europe : Anaplan is currently not able to send email notifications based on a pre-set condition. e.g. whenever a price is submitted below a certain threshold. The idea would to have an action that sends email based on a threshold but without having to use your own mailbox
Mule4 with Anaplan Execute Export streaming Integration (Unparseable date issue)
Hello Team, We are using Execute export streaming Anaplan operation connector in Mule 4. But we are getting the following exception from the Anaplan connector while performing the export option! org.mule.modules.mulesoftanaplanv3.internal.client.AnaplanV2Client: Exception while parsing currentTime java.text.ParseException:…
How to roll back a production model to recover lost data
Author: Jessie Zhao is a Solution Architect and Certified Master Anaplanner at Anaplan. Working with a model in ALM has a lot of benefits. These include building new features in a development model anytime without affecting production users, securely managing production lists by identifying structural data that needs to…
Level 3 - Ask the Stakeholders - Establishing Sales Targets
Level 3 - Ask the Stakeholders Establishing Sales Targets Process Questions This forum is for asking the stakeholders of the Unicorn Candy Company questions about the Establishing Sales Targets Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please allow up to 3…
Share your modeling tips and tricks — Best Practices Community Challenge
As we step into September, we’re thrilled to introduce a new and exciting addition to our Anaplan Community Challenges: the “Best Practices” challenge! Throughout the year, we’ll be inviting Community members to share best practices and tips around a specific topic. It’s a fantastic opportunity to showcase your expertise…
Calculate with the fewest cell | Model Optimization Team series
Hello! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
How to Automatically Generate an outlook Email with Specific Format from Anaplan Page
Hi Anaplan Community, I’m trying to automatically generate and send an email from an Anaplan page formatted as follows: TO: (Predefined recipient email) Subject: Text [dd-mm-yy] Attachments: (Optional or specific data if applicable) Body: Hello, Please see below the details: Line items: Timeline: "Start week - End week"…
Model Archives : Automation & Tenant administration
Hello ! It would be great to have automatic quick-wins regarding Model Archive Management ! ALM & Archives : When we need to move a large number of developments (or time management switch) into production, we always try to do a "Copy & Archive" first. However, this task is manual and potentially error-prone. It would be…
Summary Method per List
In DISCO we create CAL modules that are purely for caulations and turn Summary Method to NONE. There are though many times where to be most efficient you may want to only have the Summary method apply to one list. e.g. you want it to SUM on product only because you can then use it in an Output module which doesn't need the…
Ability to sort models in model management
A description of the enhancement requested Sort models by size and name in "model management A story for why they want the enhancement (specifically how would it help their business process) To easier sort models
How can i set up this filter ?
I want to allow users to input a text field with items separated by commas (e.g., X1,X2,X3,X4,X5 ) and, after clicking a boolean (e.g., "Select"), have the page filtered to show data only for the specified items. How can I set up this filter?
How can I convert a text containing multiple items separated by commas into a list?
I have a text string like "X1,X2,X3,X4,X5" and I want to convert it into a list containing X1, X2, X3, X4, and X5. I tried using FINDITEM, but it only works for one item, and with FIND, I can only get the position of the first comma. How can I achieve this? Thanks
How to filter time in NUX based on page selector parent.
Hi, I'm struggling to filter a table in NUX based on the page selector. Anaplan wants me to hard code an item to filter on. I want it to use the selected item in the page selector. I have a bunch of projects with their parent category Start and end month is set for each project. This aggregates with min for start and max…
How to display selected line items depending on the selected level in the hierarchical list.
I have a three level list Country->Region->City. How can I display selected line items for a given level in the list. Let's say I have 10 line items in the module and for Country level I want to display 6 selected, for Region level 4 other selected etc.
what is DataHub and Spoke Model?
Module
Hello, Can we change the rows and columns in a module after the module is created.. For Example product code is defined as column in the module, after the initial creation of the modul i want to change it as rows is it possible Also once a module is created , where can we see the rows and columns defined for that module…
Zero Suppression
Hi, Is there an option to suppress zeroes in a module so all the cells that have 0 or blank as values can be hidden? Thanks Megha
Add note / comment out in the formula editor
Ability to add notes / comment out formula parts in the formula editor similar to '- -' in SQL or ' in Microsoft Visual Basic

Modeling

Discussion List