-
Converting Text to Date and Date to Text
Author: Julie Ziemer is a Certified Master Anaplanner, Anaplan Community Boss, and Solution Leader/Business Analyst at Akili. While Anaplan has specific functions to convert between data types, converting Text to Date and Date to Text are two commonly searched topics on Community and they require the use of several…
-
How to avoid showing disabled parent from Drop Down list Selection
User is not willing to see parents in drop down list selection. By creating a flat list of my level 4 and by creating mapping between L4 and flat list we can fulfill the ask but I am looking at multiple options on how to achieve this. Feel free to share the approaches if any.
-
How does the Model Open Analysis Report change without any changes to model?
We've come into performance issues on our model and requested a Model Open Analysis (MOA) report from Anaplan support. This was very helpful in identifying modules and, in particular, line items that were using up a lot of processing power. The metric they used was Total Calculation Time, measured in milliseconds. After we…
-
Level 2 - Sprint 1 - 1.5.2
Review DAT01 Beginning Inventory Module * Module Name: DAT01 Beginning Inventory * Dimensions: SKU Flat list, s Location Flat: Distribution Center? list * Category: Master Data Line Item Format Purpose Beginning InventoryNumberBeginning inventory count (opening stock) for each product SKU by Distribution…
-
Five principles of solution architecture
Author: Arun Thakar is a Certified Master Anaplanner and Vice President in the banking industry. Whether you are just starting out as a solution architect, or you’ve worked on several models you may benefit from a refresher on some of solution architecture’s key principles. It’s important to remember that these are not…
-
Level 2 Model Building Conclusion - DEM04 Demand Export Demand values
Hi, Could someone please help me with the following? Solution DEM04 should be this: My DEM04 Demand Export: My values are way higher, Demand line item is not for each product SKU. How can I fix this? My DEM04 blueprintview: Baseline Forecast: Thanks in advance!
-
Show all data if no user filter selected
Hello, I have a user filter selection. It only shows data after filtering. How to see all the data even without filter? Thanks.
-
Count the total number based on filter KPI
Hi, I have a Count line item of employees that has a formula of 1 in my employees module. I have a Total Count line item on another module to show the Total Count based on Filter that has a formula of: my Filter formula is: How do I show the total count of employee based on the filter? Thanks
-
Did You Know: Multi-dimensionality overview
Author: Allison Slaught is a Certified Master Anaplanner, Anaplan Community Boss, and Senior Principal Solution Architect at Anaplan. Hello Anaplan Community! The objective of this ‘Did You Know’ tutorial is to provide a brief recap of multi-dimensionality in Anaplan and provide a framework for identifying how formulas…
-
Anaplan Partners for FP&A
Hey there, Has anyone implemented Financial Planning & Analysis in Anaplan for an organization without an Anaplan partner or a light one? If so, how was your experience? Thanks! Andrew
-
How I Built It: Dynamic source data selection
Author: Erik Svensson is a Certified Master Anaplanner and a Principal Solution Architect at Anaplan. Hello Anaplan Community! Thank you for checking out my ‘How I Built It’ tutorial. In this video, I showcase how you can set up end user selections to vary data sources across one or more hierarchies. This is a dynamic way…
-
NEW UX: Link to pages in other apps within the same workspace
In Classic Anaplan, we have one big model within a workspace. We're considering building it again in the new UX and expect to break the big model into more functional apps. The trouble is some of these apps are not entirely siloed, i.e. users will need to move between pages within multiple apps. It would be really helpful…
-
Top 25 Anaplan features released in 2024
Author: Misbah Ansari is a Certified Master Anaplanner, Anaplan Community Boss, and CEO/Founder at Miz Logix. Anaplan has released hundreds of features in 2024 to enrich its platform with more flexible planning, dynamic reporting, and scalable offerings. These features have been released throughout the year across all the…
-
Exam 3 - A 2019 Actuals
Hi, I successfully loaded the provided 2019 Actuals file and updated the Sales Planning model and I am still getting incorrect answers for the first 2 exam questions which are based on this file. I hit every check point in the Level 3 lesson sprints and successfully loaded the file, so I'm not sure why my numbers are off…
-
Month Number respective month.
I want a line item where I can select the month by drop-down. For this respective month I need the number value of the month. How can I achieve this.? Like October is 10. I am thinking to create a month flat list and use it, but how can I get the number? And i would very appreciate you if you share screenshot.
-
Activity 4.6.4
When importing the excel file I keep getting an error message saying “import complete but with failures” and the failure is an invalid code. It says US is not the correct code. Anyone know how to help?
-
Sankey (Flow + Magnitude) Charts
Hi Anaplan, We've had a few requests now for Sankey charts to show flow direction of data as well as the magnitude of this flow. Especially pertinent in allocation processes where you it would be great to be able to visualise the movement of data from one location to another i.e. Allocation of L3.C to G5.A & G5.B; or Sales…
-
Interpolation
How can we do interpolation in Anaplan? I need to interpolate scores from the following criterias: a. Min number with equivalent score b. Max number with equivalent score Thank you!
-
Level 2 Sprint 1 - 1.5.7.2 Add Formula to SYS13 Line Item
Hi, Can I please get some help with the formula for this? Thanks
-
Data Import from Model A to Model B
Anaplanners, Had a query, i have data in Model A, in Revenue Module which is dimensioned by Country List, Time & KPIs as line item. I need to import this data into Model B, in same Revenue Planning Module, which is again dimensioned by Country, List, Time & KPIs as line item. However here we have an additional plan type…
-
Removing unnecessary Top Levels
Removing unnecessary Top Levels (or better yet, not adding them in the first place!) Author: Allison Slaught, Certified Master Anaplanner and Principle Solution Architect at Anaplan. To improve efficiency in your models, it’s important we only calculate where necessary. One way we can do that is to only use Top Levels…
-
Adjusting Statistical Forecasts: Utilizing different Methods for varying time horizons
Hello Anaplan Community, currently we have a very simple statistical forecast tool in Anaplan. We can select between 15 forecast methods for a forecast category. We generate the statistical forecast using a single method for the next 5 years. We aim to introduce a logic that enables selecting two distinct forecasting…
-
Error : Evaluating the forecast in Hold Periods ～ Statistic forecast
I'm trying to evaluate the statistical forecast by using Apply Hold Periods. But when I set them, the almost of product's best-fit forecast is set to New Item Forecast. How can I correctly evaluate the forecast?
-
3.3.5.3 check your work
Need some help please, as per example, Safety stock target line item is blank In my module have got summary values here, any pointers please?
-
Performance Comparison - YEARVALUE(x) vs x[LOOKUP: FY]
Hi all, Was hoping to get some insight into the performance implications of obtaining the year value of a line using either YEARVALUE(x) or x[LOOKUP: FY]. Both will retrieve the same result assuming summaries/timescales are setup correctly, but they are definitely not calculated the same (based on anecdotal tests). From…
-
How I Built It: Time and Version filters
Author: Stacey Gibbens is a Certified Master Anaplanner and Solution Architect, Financial Planning & Analysis at Globe Life. Greetings, Anaplanners! Today I’m excited to share my ‘How I Built It’ tutorial on minimizing import/export toaster time by utilizing time and version filters on source data saved views. In my video,…
-
Model Building - Avoiding Circular Reference
Working on a use case to reproduce following psuedo code in Anaplan Start Recommendation_given=0 for tranche 1 to 6 if tranche =1 then tranch_contribuiton = 0 else if tranch recommendation <= recommendation_given or tranch_recomendation = 0 then tranch_contribuiton = 0 else tranch_contribution = tranch recommendation -…
-
Dynamic Line Item Label
One recent scenario was where the Line Item Labels are shown as CY, CY-1,CY-2,CY-3 and users wants this name to be dynamic like 2024,2023,2022,2021, I want this label to change in all modules each year as the current period changes. There were many occasions where there were requirements to change Line Item Label, which…
-
Show Total in Module even after applying filters
Hi All, In one of my moduel having a column "Rebate Payment Amount" which has values, and also we set the show TOTAL on Above for giving total aggregated values as single value, it works only if we didn't apply any filters on the remaining columns in the module. How to show the 'Total' i.e. sum of all rows for the column…
-
Drill to Transaction Functionality in the New UX
Drill to Transaction Functionality is considered critical for some partners/clients as it's functionality that has no alternate solution. I have heard specifically from FP&A implementations regarding allocations, as well as ICM use cases, but would love anyone giving kudos to leave comments with additional examples of it's…