Modeling

How to make LI into Percentage
Hi, I need to display my Collection's Amount LI as a Percentage for a Dashboard. How would I do this? Thank you
Increase the size limit of notes
A description of the enhancement required: The notes on line items is 250 characters which isn’t enough. A story for why the enhancement is required (specifically, how would it aid the business process): When you write a note on a formula, you have to explain WHAT is does, WHY you did it, HOW it’s used etc etc, 250 isn’t…
Date function not working
Hi, I'm trying to convert Open date line item- text formatted in to Date using Date function but getting blank in Date Final line item, could you please help me where I'm doing wrong
level1 lesson 8.5.3
i am unable to map it properly. kindly help as per activity:
level 1 lesson 7.2.3
why employee name and country is not showing as per activity:
Change a module's Dimension without Saving
Hi. I'm New to Anaplan. I want to export data from a module but the current Pivot is not what I desire. If I change pivot in Grid View and after exporting, close the module without saving, the module's structure would be changed?
Display Months with Fiscal Year Label
Hi all, Have a client with a Fiscal Calendar that starts in Oct. They've asked that any of our modules that utilize monthly time to have the label for it include the Fiscal Year (rather than the Calendar Year). For example, 'Nov 22' should display as 'Nov FY23' instead. Is there any way to apply an alias like this without…
anaplan sprint 2 1.3.10.1 - country import help
Import was successful However, something is off and can anybody help me what I did wrong? My G2 Country List has the code and parent assigned correctly Here is the check your work from anaplan course
Open Source model in Formula bar
Drilling down gets exhausting. When you are in the module tracing a formula, when you click the chevrons to bring the formula window to the bottom of the screen, functionality to be able to right click a formula and a window opens to give an option to "open source model" just like in drill down would be awesome.
L1 Lesson 6.8.1
I am getting only 1 Region whereas in the activity it is showing all the Regions.
L1 lesson 6.8.1
how to set dimensions?
Lookup two different dimension
Hi, I have attached a sample Modules that I have in my model: I want to retrieve the Quantity data from Module 1 to Module 2. but they have different dimensions. As you can see below, the dimension for Module 1 is Unique Code List, and Month (time) but in Module 3, the Dimensions are Active Skus , and Accounts. I tried…
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…

Modeling

Discussion List