-
numbered list
Hi , I have a Confusion on Numbered List can end users import items to the list by uploading a data file '. is this the use of a numbered list ? thanks
-
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
-
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
-
After a boolean is selected, I need the last month of every quarter that follows to be selected
Hi, Currently, when I select a boolean in my R21 (that is dimensioned by quarters, ss2) I get the last month of the quarter selected in my C76 module(ss). How can I make it so that once I select the boolean, the last month of every quarter that follows that quarter becomes selected as well. For example: I select Q1 2023.…
-
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
-
if one dimension is checked select all dimensions
Hi I have a boolean that is checked at one dimension (turns, in this case it is turn 6) How can I make it so that if the boolean is checked at turn 6 the boolean at all turns will be checked? Thank you
-
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…
-
need to get lineitem into module with different dimensions
Hi All, In need of some dire help right now. Background: I work for a lending company. We dimension the data by turn (you can think of this as length of the loan) How can I pull the "override amount" line item in ss1 into the "override from UX" line item in ss2? it can go into any of the list members in dimensioned in the…
-
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…
-
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…
-
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