-
Updating hierarchy lists from user selection
Hi, lets say I have this hierarchy: A1, A2, A3, A4, A5, A6, some users need to change A4 from a module, this change need to update the list A4 and obviously this will impact A5-A6 lists. So I was thinking in creating a action that imports from this module into the list A4 but the point is that only the items changed by the…
-
11.3.4: Headcount and Expenses not matching
Hi! Can someone please help me, I am not sure where I went wrong. For Level 1, 11.3.4 my Headcount is off by 1 and my expenses are all off because of this. Thank you in advance for your help!
-
Building Tableau Export for modules
Hi Team, I have module "ABC" where it has some 4 dimensions and 5 line items where each line item has a subsidiary view. I want to make a Tableau export with the above-mentioned module. Kindly help me with the procedure. Regards, Venkatesh
-
Sales bonus based on hire month
Hi, I have a requirement to have sales bonus based on the hire date - For example, if an employee is hired after sept of 2022, the employee is eligible to get sales bonus only after Feb 23 onwards. If the employee is hired after sept 23, then s/he is eligible only after Feb 24, etc.. If the employee is hired in or before…
-
Time functions Polaris
Item(time) function not working in Polaris my time scale is month. Format is year. need to populate year Thanks
-
level1 lesson 6.6.3
why my start date differs from the example activity solution???
-
lesson 6.6.4 level1
how to add dimensions: Time (year)? i am getting a different result than shown in the activity. as per activity Mine
-
Formula help
I have 4 modules as shown in the screenshot. When I make an Override only for Brazil it is being carried into all of LATAM in Module 4. In module 4, the revenue is pulling for all the countries when in-fact it should pull only for Brazil. How do I fix it?
-
Community perspective: Central User Access Management
What is Central User Access Management? "Central User Access Management" is an Anaplan model through which we can maintain user access management for all the models within an enterprise. This is not readily available in Anaplan AppHub, but it is easy to create and maintain. This article will explain how to do it. Why we…
-
list formatted line item
can someone explain what are list formatted line items at a basic level. Thanks!!
-
Display SKUs based on selected Type(parent)
Hi, I have a module name : NPI Enrolment -- this is to encode New SKUs which currently is in a separate list called New SKU(List) I also have another module called Reference Sales -- the goal is to get the sales from existing SKUs since New SKU have no sales yet. In my Reference Sales Module, I cannot display the SKUs…
-
Fallback Context Policy
Hi, Today, when I pulled Comparison Report in our Model, I got additional lines in the "Modules Changed" section, which is like "Fallback Context Policy: Old Value" which is - and "Fallback Context Policy: New Value" which is SINGLE. What is this meant by? I am not getting this. Could anyone please help me understand this?…
-
Selected Versions as a Dimension
The model I have created has 4 version. I have a module with versions as a dimension. Is is possible to have only 2 versions as dimension. In the blueprint mode I see we can either select 'All' or 'Not Applicable' for versions as a dimension. I need this because I want to use the Edit From, Edit To functionality of the…
-
Workarounds To Sum Data While Using NONE as Summary Method Within Source Module
As the Anaplan model size capacity has recently grown from roughly 18 billion cells to 100 billion cells with the introduction of HyperModel, it is still important to structure models efficiently, while creating as little 'wasted space' as possible. The Planual states that the Summary Method for most line items should be…
-
Ability to update formulas of List Properties just like line items
To use the List property in formula, one need to type out the whole list name including property name, that is a cumbersome process. Allowing Reference of List Properties, will save MB time and efforts in wrong typing of name.
-
Time Ranges vs Model Calendar
Hello, I had a technical question around Time Ranges. Let's say my Model Calendar is set to FY21 Jan-Dec, I have 2 past years and 2 future years. I have some planning and assumptions modules that are only relevant for me for the Planning period. So I develop time ranges to save sparsity and reduce cell count in my model.…
-
Need help add dimension to model.
Hi team, I am new to Anaplan. In lesson 6, how to add Dimensions: G1 region list in the general list, I am stuck. Thanks,
-
Searching for a certain role
In my data I have teammate roles, their names, the month that they were in that role, and the facility that they serve. In one module I have all this information listed out. I included a picture with the data I have. I didn't include the teammate names because that is sensitive data, but there is a column left of facility…
-
Sum calculation not visible when highlighting cells in expanded view
Currently in an Anaplan dashboard, if you highlight cells, you can view the summation of the values (see image below). However, when you expand the table to fullscreen, the summation does not show (see image below). We kindly request a product enhancement to allow for summation calculations in an expanded table view.…
-
How can I get the average of months for prior year?
I would like to get the averages for a line item using prior year month values. I can use the formula below but I don't like the idea of hardcoding. Is there another way I can do this without hardcoding? The current formula I have is: LAG(<source LI>,12,0)+LAG(<source LI>,24,0)+ LAG(<source LI>,36,0) / 3
-
7.2.2 Activity Errors
Hi Team, I am having issues getting the P2 Product family to accurately fill after uploading the CSV for activity 7.2.2. I have some photos below, I am assuming it's due to the P2 Products having All Products - Choc, sourcs, taffy, fudge? Any thoughts? Thanks!
-
Ability to repeat actions inside a process
I think it would be beneficial to have the ability to repeat an action inside a process. Currently, you can only add an action once inside a process.
-
DYK - WEEK 15 (Workflow)
Did You Know? That * Workflow allows admins to track the status of work/inputs on list item level and it also allows admins to communicate with users via email. Admins can send E-Mail to Individual Users or to entire User base (provided all these users have write access to at-least one list item) * Anaplan Workflow cannot…
-
Hierarchy Filtering Logic
Hi, I have a composite list hierarchy as below: Department L1 Product L2 Project L3 In a properties module, using this hierarchy. I got a Boolean line item named “Project?”. I can set up a formula to populate “Project?” as true at Project L3 Level. Let say I have a line item named “Product?”. Is there any way that I can…
-
SYS07 Sales Rep Details (Length of Service List Line item)
Hi, having trouble to find out why some of the result are blank Thanks, jehular
-
Filter by page selector
Hi, I want to Filter List by page selector. I have this two tables. Region List is a parent of Country. I want to achieve this below image. When I select Europe in Region table, Country table is filtered Europe Region. Is there any way to do this? I wish I can get List Item which I choose now.
-
Need Ability to Disallow NUX Toolbar Filtering, or Hide Toolbar Entirely in NUX
Similar to how we have ability to disallow native pivoting of a NUX grid by end-users, we need the same ability for native filtering via the toolbar. Prime example is that many of the would-be strong synchronized scrolling use-cases are negated by the fact that as soon as an end-user applies a native toolbar filter on one…
-
Write Access Driver to Parent Item
Hi, I want to use breakback function and Write Access Driver. We have Country List which has Region List as Parent. And Users input to "Adjust Lineitem" and it set as breakback. In this table, I want to users can write "Adjust" by Region List, and cannnot write by Country List. I want to set a Boolean Lineitem to Write…
-
Breakdown by proportional division
Hi, I want to use breakdown function. Breakdown has equal division function as default. (Image is Adjust(normal)) But I want to breakdown by History rate. case) Japan : 1000 * (200/800) = 250 Are there any way to achieve this by using breakdown function?
-
NUX: Compound Sort
As a user, I would like the ability to sort multiple columns in a grid. I.E. Sort by Last Name, then by Salary, then by Hire Date. Right now i am only able to sort by one column at a time