-
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.
-
Wrong date when doing an import
Hi everyone, I am importing data into a module which gives me the employment date of a list of employees (among other info). The module doesn't use time as a dimension. The import goes perfectly well, it doesn't mention any error. But then some of the dates are wrong. So I tried to copy these directly from Excel (simple…
-
Bolean condition based on Season
Hello everyone, i've been recently struggling with a dev. I have a list in my model called Season (I work in the retail industry). This season list is composed of items that are like this : 23SS, 23FW,... that correspond to the seasonality of the product (for instance : 23SS stands for spring/summer 2023, 23FW stands for…
-
Quarterly Account Sales Revenue Targets
Hi @JaredDolich @Misbah , How are you? I completed the User Story 1.11. But I have a question. When I select All Account, the % of Account Sales Target aggregate automatically. Any help would be appreciated. I am looking forward to hearing from you soon. Best regards. Wei
-
Level 1 Model Building Exam - Activity 6
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from SYS08: I keep getting the wrong number whether I use EMP02 or EMP03 in the formula.…
-
Sprint 3 - 3.5.3 Activity: Create Distribution Center Summary Module
Hi, Can somebody please tell the formula for this line item in this activity? In the Supply Chain model, create a new module: * Module Name: INV03 Distribution Center Summary * Dimensions: P2 Products list, s G3 Location: Distribution Centers? list, Time (month) * Category: Inventory * Functional Area: Inventory * Summary…
-
Calculating line item based on diffferent values in the list
Hi Anaplanners, I have a module dimensioned with 2 lists, loc1 and sample. Sample has two line items Sample 1 and Sample 2. There is a line item called Transportation. I want to add another line item called Transportation Sample1 vs Transportation Sample2 which should be Transportation for Sample 1 - Transportation for…
-
How to Find Combination of List
I want to Find combination of List. I have relationship of Customer-Product and Product-Supplier. Then I want to find combination of Customer-Supplier. Now I don't want to make Lineitem which has "Customer*Product*Supplier" as Applies To because of memories. What kind of formula should I set?
-
Formula Help (Condition Statement)
Hi, I need help on creating a condition where if one LI is lesser than another LI, then my intra-month growth amount must be less than my write off amount. Not sure how I can make this condition happen in Anaplan. Please advise. Thank you
-
Add dimension name in NUX
Hi, Is it possible to add the dimension name at the top of the GRID in NUX? Regards, Tom
-
can someone help me understand the difference between structural information and production data
-
Anaplan formula to Lookup Balance Sheet description
Hi Anaplan Community Please see email attachment with all details for my question relating to. I have an “Account Major Properties” module with a line item of “B/S Line Item” where I want to populate the valid Balance Sheet line name, from the list “Balance Sheet Lines – NEW”, based on the Account Major (e.g. GL Account)…
-
Model Optimization : List Sort Order
Hello everyone, Is there any further documentation to read regarding optimizing the model. We saw this in the checklist. Does this mean we have to Sort the List? If yes, via what property of the list (Code, Display Name or Numbered List arrangement) Thank you very much.
-
Hierarchy Filters
Hi, I have a requirement where in if user selects a Boolean(Show Ending Balances) then it should show only ending balances (which is a top level for L1 description types of list) along with Ending Balance line item. Currently I have built the logic but when I apply the summary as formulas it throws an error. But previously…
-
How can I Filter out certain Time Periods in my Time Filter?
Hello, I'm trying to include the following time periods - Month, Quarter, and Year totals while excluding Half Year. Because of other use cases I cannot remove Half Year from the time scale. Has anyone encountered this before and how did you solution it? Thanks!
-
How to truncate or make this formula more efficient
Hi, This formula in our model is possible slowing down the load time of our model. The formula has the logic we need but I believe it can be written better for loading time in our model. Formula: IF 'S04 Version Mapping'.Budget THEN IF 'S01 Time Settings'.Funding Holidays? THEN IF 'S01 Time Settings'.Weekdays? THEN IF…
