-
Modelling Issue
Hi Team I have a module consisting of default Users dimension, two line items where user can select "Source Version" and "Target Version" from drop down list(custom versions) on dashboard. There is an action which copies data from selected source version to selected target version. After data is copied successfully the…
-
Updating Lists on Transaction Data Import
Colleagues, hi! I'm seeking your advice on the following case: on a weekly basis, there will be a transaction file with the unique "purpose of payment" texts for each transaction and potentially new suppliers that don't exist in Anaplan list yet. How can we achieve automatic update of supplier list upon import and having…
-
Priority distribution
Hi All - Was hoping I could get some ideas/help on this problem that I'm trying to solve. I am trying to automate the output of the "allocation" line item shown below. I have a set amount that I need to distribute into various list items based on the priority shown. The max amount allocated is shown in the first column.…
-
Level 1 Certification: Activity 4 and 5
Hi, I am been working diligently all day on a single problem and am coming up empty. The problem never occurred during the training and need some advice. Basically, when I import the "SYS08+Employee+Details" txt file into sys08 file unfortunately even though I map correcty the Role dimension, which I formatted as a list,…
-
Lookup considering the Month
Hello, I have a Price List named "Raw Materials Price", and I need to pull from "Component Cost Increase" module the % increase by Component, Plant and Period (Jan 2021), hoy can I consider the period in the lookup formula? Raw Material Price List: Formula: Component Cost Increase Module: Thanks, regards
-
Storing Forecasted date
Hi my model has 5 versions Rofc, Forecast. Budget, Simulator1, Simulator2.(list) Rofc contains data of actual month and future month (similar to native switchover). I am creating forecast between jun-sep every year using Rofc data of the current year and locking the forecast data of that year. Forecast can be created…
-
Replacement Chain
Dear Community, Hope you can help me with this requirement; 1- In fact, we have a list of products and we want to replace it for example: We have : A replaced by B then B replaced by C and C replaced by D what makes a chain of substitution A-B-C-D. What I want to display on each line is the first product of the chain in…
-
Multi Dimension Ranking
Hi, I have 2 modules, 1 has dimensions of TenantGroup, ReportPeriod and UserRole namely AgingperGroup. And the other module has TenantGroup and UserRole namely AgingGroupRanking. The latest module will take the data from the previous and lookup the CurrentPeriod parameter to get the exact data(of which data period) to be…
-
Mapping
Dear All, I have one use case in which I am confused to get the output. Below is the use case: I have almost 10 lists (A,B,C,D etc.) and each list have almost 4-5 list items (A1,A2,A3,etc.). Now the end user will have the access that he can select the list items from each list (single/multiple). Once user has selected few…
-
UX: Card Blocks/Groups
Initial Idea: (1) Would be nice to be able to group cards on a page into a single container and save it as a single template. This will allow me to save time on repetitive builds where I have to publish the same header with 10+ separate cards on all my pages (workflow status steps, filters, company photo, custom…
-
function
can someone elaborate when to use sum , lookup and select in easy to understand way. i have read it from anapedia but still struggling
-
Model Restore, History
Hi All! I had a small model, and by mistake I changed time (Current fiscal year) How can I restore it? Thank you.
-
Search Text in a String
Hello Community, I am looking for a function to find a character(s) within a string, similar to CONTAINS function. For example, I need to find the word Ananplan in the string "I love Anaplan". Is there a function for this? If yes it will be really helpful if you can share. Thank you, Yogesh
-
Increase the auto-logout time from Anaplan Workspace/Models
Hi Team, As Anaplan came up with the auto logout feature, it is good from the safety point of view. But its quite annoying most of the times. As a developer we get involved in multiple other tools and suddenly Anaplan logs out and defaults everything. It would be really helpful if you can please increase the auto logout…
-
Allow semi colon as a delimiter for emails as this is the default in outlook
As a user I should not have to configure Outlook to use commas as a delimiter for sending to multiple recipients as this option is not checked by default. The MAILTO function in Anaplan only accepts commas as separators for multiple email addresses. It would be useful if it also accepted semicolons.
-
Actuals
Hi, Please could you help me understand which setting i have incorrectly which is populating my actuals in advance in image 1? Image 2 is correct.
-
13 period year
How do you create a 13 period year where P13 is added into Q4?
-
How to I filter and display only one line based on a property (text) for a module
Hi, How do I filter this module to display only the first occurrence of PR No (4th column). PR No is text and its derived from using formula LEFT (PR List, 😎 . PR List (the 1st column) is a composite list with material as a parent Is there any way I can rank the lines with same PR Number (4th column) and filter to show…
-
Cumulative SUM for Top Ten Items
Hi There, I was wondering if you can point me in the right direction on finding how to do the below 😃 I am trying to build a report that can show me just the Vendor that make the 70% of the Total Expense. I have 3 dimensions (VEndor LIST, Cost Center and Product). As a Line items I have the "Expense" and "% of Expense".…
-
User Story 1.6 Module
Hello, I just built a module for User Story 1.6 and wanted to make sure I am on the right track before I proceed to User Story 1.7. The validation criteria for the story is, "I will know this is complete when I can see the Final Account Sales Targets aggregated for each country’s small, medium and large segments." Any…
-
sum values
Hi guys, please help. attached a pic. Is it possible to sum up "values" this way, to have the result in "values months" column? - january : values from january - february : values from january and february - March : values from january and february and March .... - December : values from the past 11 months + december. I…
-
Skills and Drills
I am putting together a list of Anaplan Skills/Drills as part of our Enablement program. Asking for your suggestions. What should make the list and at which modeler level (MB, SA, MA, etc)
-
Get the Month from a Switchover W/e Date
Hello all, How can I get the month where the switchover week-end falls under? I've tried several things, not getting the desired output, yet. Thanks!
-
Allocating the 53rd week to a different year
Hi All, Is it possible to allocate the 53rd week in a 445 arrangement to a different year? Example; from FY20 to FY19 and from FY25 to FY24
-
Level 2 Training - Sprint 3 - INV01 Inventory Ordering Module
Hello, I am not sure what is wrong here: * Beginning Inventory Formula: IF 'SYS01 Time Settings By Week'.'Not 1st Week of Timescale?' = TRUE THEN PREVIOUS (Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory[LOOKUP: 'SYS08 SKU Details'.Distribution Center]----Does this not look correct? Any help is…
-
Rolling data snapshots of Weekly and Monthly forecast for different Versions
We have a scenario where there is a need to do a weekly forecast for short term (next 13 weeks) and monthly forecast for remaining periods of the fiscal year. The forecast and actuals need to be captured in both weekly view and monthly view. Also the monthly view needs to be tied to a consolidation system (another tool…
-
How to link parsed list back to List codes
Hi, I've created a module that contains a list with data that has 3 components of a list concatenated (to limit the number of rows). The list data looks like this: CCCC_AAAAAA_DDD - with the C's being company code, A's being account code, and the D's being department code. I now want to have another module that references…
-
Statistical Forecasting algorithms into a user specific model
Hi - I am new to Anaplan and I have a quick question: Let's presume we are to develop a supply chain demand planning module for a client. Since we exactly know what all lists/line items are needed along with the hierarchy and the calculation formulae for different line items, I prefer to have that developed everything from…
-
All Periods amount not updating when time range updated for module
Hi I have created Module A previously with timeframe FY19 to FY22: The total of a line item for FY19 to FY22 is 36. The total of this line item for FY20 to FY22 is 29. As regards, the "All Periods" amount: Module A shows a total of 36 when I set the time frame for that particular module to "FY19 to FY22", as expected. But…
-
Summary Methods Based On Line Items - Product as an example or Weighted totals
Hi All, I feel that the summary methods in Anaplan could be improved further by including more flexible options to use other line items (same dimensionality) to influence summary method. For example on a model I have been building recently, many of the summaries require the product of 2 line items divided by the total of…