-
Rank Formula Work Around
Hi! I have a module dimensionalized by a list of unique identifiers that is the child of a Location list. I'm trying to rank survey dates (a date formatted line item) in descending order based off of how recent they are BUT there are multiple UID's with the same survey date. The problem is, with the "RANK" formula, the…
-
Clear Override value when the Override boolean is unchecked
Hello All, I would like to clear the override line item based on whether the boolean value enabled or disabled. Please see screenshot attached for current & expected behavior I have perused through the existing questions on this topic but couldnt really get the same problem statement. Apologies if I missed it somewhere, if…
-
A line item format as "No Data" can be used in an import action?
Hi Guys, I have an action to clear data in target module. The format of line item in source module is "No Data" and formula is blank. And the format of line item in target module is Boolean. I want to make the value of target line item as FALSE. Does it work when I run the import action? As my experience source and target…
-
L3 model building sprint1- 4.6 Model Build Specifications
Hi Everyone, I'm working on L3 training and feeling stuck. in section 4.6.5 we are asked to build the module that references PY FY19 sales. I was able to do it, but on the confirmation page from anaplan dimensions look different, but the numbers are correct in total and by product. I used A1 accounts, P2 Products lists. do…
-
Boolean to Boolean / Date to Date import
Friends, I am experiencing a very strange case where am importing a boolean lineitem (1 cell) to another boolean lineitem within the same module (1 cell), which has derives DCAs on other lineitems, but the boolean is not copied over (through import) in target line item; although the import process shows 1 updated. Source…
-
How to bring a territory down to account level?
Hi all, I am having trouble assign territory down to the account level. Here are my modules: Module 1: This is the territory definition module containing the attributes for my territories. In this case, I have create an territory "USA_Banking_SPC_Tier 1_Rule 1" to cover all "ABS Lender" products. Module 2: This is the…
-
Hello,
I have a module dimensioned by Accounts on the rows, Users on the columns, and 1 Boolean line item which allows users to select certain accounts that apply only for that user. I am trying to create an action that allows the user to clear all of their selection by simply clicking an action button, as opposed to have click…
-
Use Time dimension in a formula
I have a module with Day as the time dimension. I would like to refer to the module time dimension in a formula. For example, WEEKDAY(time dimension). So that on January 1, 2023, the line item would return 7 (for Sunday). Is this a thing?
-
Comparing values against the same dimension
Use case: Prod A was sold for 100$ as part of Plan A, 120$ as part of Plan B and 150$ as part of Plan C, I need to determine the increase/decrease in price for each plan. How can this be achieved in Anaplan?
-
Filter - Current User Selection Not available in NUX pages
Hello all, We are currently facing an issue with the filter on page selectors in NUX. Earlier we had this option but now it got disabled. We have version list as a selector in a NUX board page. As it is has lot of members in it, we have given the user the flexibility to reduce the no of drop down items by selecting Version…
-
NUX, Subsets, and Context Filters
Hello! I've got another unusual NUX issue I need some help with. I've tried to include relevant snips below, but as always happy to answer any questions and provide more info as needed! It has not been an issue until now, so we suspect recent Anaplan updates are the cause but have no way to verify beyond it being a new…
-
Ratio summary not working due to level missmatch
Hello, I have a module (655) that is using summary Ratio to work around the issue with child/parent relationships and getting information into one column. I am trying to replicate that solution into another module (141) but it has an error message regarding dimension mismatch. I am having a hard time understanding why is…
-
Module not showing all list items
Hello, I have a 4 tiered list hierarchy. On the lowest level I have thousands of items that do not have a parent and need to be deleted. I would like to create an action to delete these list items and add the action to an existing process to maintain good model hygiene. My challenge is that any module where the list is…
-
Optimizer - Forcing one product to remain at one plant despite optimisation
Hi, I have a Model and have successfully optimised our data 3 Plants 100 locations Costs from each plant to each location Total Demand volume by location (we have product but don't use it currently*) Constraints Volume cannot exceed plant Capacity and Location Demand must be met This all works as expected *What I want to…
-
module based on hierarchy
Hello, i want to make a module that is based on a 2 level hierarchical dimension "product". When I click the selector of a Level 1 product I would like to see all the L2 Products that belongs to that Level 1 Product. With that module I'd like to make a pie chart. Problem: I have made 2 lists: L1 Product and L2 Product. I…
-
Convert Month to Number or Text
If we use the the MONTH function to convert a month - for example "Jan 15" which is month formatted to Number, the outcome is "1" and not "01" My requirement is to turn "Jan 15" as 201501. So I wanted to convert Jan to 01 instead of 1 and after that I can concatenate to get the result. What would be the way to convert Jan…
-
Handling Forecast Outliers
Greetings Anaplan Community, We are currently using the Anaplan statistical forecasting model for our demand planning, and a question has come up around how we can better handle outliers that can drastically skew our forecasts when there are periods of zero demand. We have a process for manually backfilling demand in these…
-
Time synchronisation
Hi all, I am trying to create a sync between 2 modules: Module 1 : 4 dimensions in page selector, (One is versions among them) Time in columns and lineitems in rows(Time summary: none, brought forward enabled) Module 2: Time as a page selector Random line item (Time summary: none, brought forward enabled) I was trying to…
-
User Story 1.3
Is there any data file available for PY Sales Revenue data . I don't see any .csv file for this Can anyone suggest how to get this data or from where to get this data. I don't see this data in the downloaded data hub either Thanks
-
Lag Function without Time Demensions
Hi Anaplanners, I am trying to model a queue building up in Anaplan and I am wondering if there is any way I can use the Lag function to return the adjacent value without time dimensions. The principle is to add the queue from the previous segment and add to the current segment, however the model does not have any time…
-
How do we calculate ytd monthly totals that don't inflate the quarter and FY totals?
We want to see YTD monthly and YTD quarterly as well as the total FY. Currently when we use YTD the quarters and FY totals are overstated. For instance in September the quarter total shows Jul-Sept, but the quarter total is double counted. The time selection we have set in the model is quarter totals and YTD summary and…
-
Tableau and Anaplan Connection using Certificate Authentication
Hi, I want to check if it is possible to use certificate authentication method with Anaplan Connector for Tableau. I am aware about the procurement process , just trying to understand if this is possible with Tableau. If yes, can anyone share the steps? Regards, Aakash Sachdeva
-
When not to use Numbered Lists?
Given how flexible numbered lists are, is there a reason why I should not make all lists in a model 'numbered'?
-
Does reseting the index limit affects the list or list items in any way ?
I have came across a issue in which because of exceed in index limit the import is failing.So I looked into the Anapedia for this concern and got to know that I can reset the index of list if the following conditions are fulfilled :- If your list is empty and the Next item index is between 899,999,999 and 999,999,999, you…
-
Problem with dataload from another module
Hi, I am trying to load data into a spoke model from the datahub. However I keep getting this error and no one on my team understands what is happening. Can anyone offer any insights or guidance?
-
Saved View Questions
I'm getting this message for Lvl 1 class 12 training. When I have same view names for different modules, it says same name already exists. How can I be able to save views for same name in different modules?
-
Maximum Limit on Adding Hierarchy lists.
Hello, I need to understand what is the maximum limit on adding the hierarchies? I have tried adding upto 50 lists and the parent of List 50 was List 49. I am not sure if it has any limit or we can add without any limit. Can any one could help me?
-
Quarterly Account Sales Revenue Targets
Hello, I'm in the process of building the module for user story 1.11 and I am struggling to get the correct formula. I need to convert yearly data to quarterly data using the SYS99 Time Settings module (only line item dimension). My formula currently pulls the yearly total for each quarter which is incorrect. Any guidance…
-
Issues with Round function
I've noticed an issue with the Round function while going through my L2 again. None of the available parameters seem to make it possible to get an accurate whole number rounded up. In this example, I want the total (237.9) to be 238, not 240.
-
Switchover and FY year settings
Is there a workaround on: 1 Updating Switchover period from the NUX App 2 Is there a workaround on updating the Current Fiscal Year of the Time Settings from the NUX. Please your reply will be really helpful.