-
is there a way to show/hide line item based on a selection by the user
i tried using line item subset but did not know how to procced next
-
Enable Completion Task DCA on Workflow
Hi, I'm building Workflows and am using Decision Tasks as they are most efficient for my Business needs. I don't seem to be able to identify anywhere to set 'Enable Completion Task' DCA's on my actions in these specific types of task. Is there something that I'm missing? Sean
-
Level 3 - 5.5 Model Build Specifications
While Building Import process from the Data hub, I an getting confused should I import Sales Reps Flat# or G3S Sales Rep# in first Action of Build Sales Rep ? 5.5.2 Sales Planning Model - Import Processes Next, create import processes in the Sales Planning model to: Build Sales Reps Build Sales Rep Details Build Sales Role
-
what are the challenges while building a model in FPNA
-
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…
-
3.3.5.2 Inventory Ordering Module Formulas
I'm really confused as to why my figures won't populate when I toggle from blueprint view . Here are my formulas. Someone please help.
-
Why are there items appearing in the source mapping of an action that are not present in the LIS
Why are there items appearing in the source mapping of an already existing import action that are not present in the Line Item Subset? I have updated the LIS and still in source mapping I can see items which are not present in the LIS.
-
I'm really confused as to why my figures won't populate.
Here are the formulas I am using but when I toggle from blueprint view there's nothing there. Please help!
-
What are the best practices which we implement in Data hub
-
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
-
Workflow - Enable Completion Check
Hi, I'm building a simple workflow, and looking to incorporate the Enable Completion Check to control whether the workflow can be completed or not. My line item for Enable Completion Check I have set to false, specifically to check whether it is working or not, but I am still able to run the workflow. Is there something…
-
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…
-
How to find the 12 digit Users code?
Hi fellow Anaplanners, Does anyone have insights on how to find this 12 digit code for Users? Apparently I need this code to bulk import users (Due to Selective Access for Sales Team) into my model. Thanks, Jim
-
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"…
-
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?
-
sum not working
I'm stuck while building a module in Anaplan. In one module, I have numbers associated with the months of the year 2024, and the module has Anaplan's time scale dimension. In this module, I have a line item formatted as a list that contains four members. Each number is assigned to one of these four list members. In another…
-
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
-
番号付きリストの合計？
モジュール =（"工場リスト"がディメンションにあり） このモジュールに対し、番号付きリストの数量データ（列に、"工場"がある）から、それぞれの工場の合計をもってきたいです。(SUMIFのイメージ 下記のようにしてもうまくいきません。教えていただけますか。 "番号付きリストの数量.SUM[工場リスト]"
-
補助ビューで合計が表示されない
番号付きリストをディメンションとしたモジュールからあるラインアイテムの合計を持ってきたいが、数量が表示されない。 現状：SummaryはSumに設定
-
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…
-
Average Duration for process to be run or Line items to reflect the changes
Hello Community members. Hope you are doing all well. Currently I am optimizing a model for a client that was having troubles with the duration of processes being run or the duration which it takes for line item to reflect manual change by users in a line item . Model has been optimized now. I know that for sure different…
-
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.
-
Security around list updates
Hi, Just a question around how to best set security around who can update lists in our Anaplan model. Initial plan is to have list showing on application, with certain individuals able to update - is this done through page settings and restrict roles? Any advice would be greatly appreciated.
-
lookup code
Think I must be having a mental block today but could someone advise what formula need to use in order to return the "Code" column shown in the left-hand side to the line item on the module shown on the right-hand side. Many thanks
-
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…
-
Having boolean true for certain hierarchy levels only
I have a hierarchy consisting three levels (product/product family/total products. Similar to the one in the trainings) and I tried to do some conditional formatting on it (need to use it as other tables on dashboard have list/line item subsets in it so needed to create a consistent outlook) I thought using an if formula…
-
How to round up to 5 or 0
Dear Anaplan Community, I need help to round numbers up to the nearest number ending in 5 or 0 2233 — to 2235 2888 - to 2890 Any intakes?
-
Optimizer Error
Hi Everyone, I need your help in One of my optimizer use case. I am building optimizer which generate dispatch Plan. They have more then 15000 SKU and approx. 1000 transportation Lane. I am struggling in running optimizer with these many dimension which increasing a cell count of line item. Optimizer failed with attached…
-
Multi-Dimensional Scatter Plot Alternatives?
Hi all, Bit of a complex one here. The application use case is calculating the Minimum Variance Efficient Portfolio for those familiar with Finance / Portfolio Management. The Anaplan question to be solved in simple terms, is how can I combine these two charts to display as two different "lines" within the same chart (in…
-
Set up current period
My final goal is to be able to update the "Current period" from the Dashboard. I created a SYS Current Period module (with a single line item: Format: Period Month) and added an action that I put into a process. When I run the process (or Action) I have an error : - Line Item Errors: • SYS Current.Current period Internal…