-
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…
-
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!
-
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
-
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
-
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
-
level1 lesson 6.6.3
why my start date differs from the example activity solution???
-
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…
-
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.…
-
list formatted line item
can someone explain what are list formatted line items at a basic level. Thanks!!
-
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…
-
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?…
-
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…
-
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…
-
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…
-
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!
-
Set up custom time scale
Hi My current model is using a fiscal calendar e.g. FY23: 1 Jul 2022 – 30 Jun 2023. However, I have a specific use case, where I need to build a module that uses a calendar year e.g. FY23: 1 Jan 2022 – 31 Dec 2022. Is there a way to resolve this use case? Based on current research, I would need to create a fake time…
-
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