-
How to, plus an evaluation of ways, to do version comparison
Author: Kevin Beltz is a Certified Master Anaplanner and Principal Platform Adoption Specialist at Anaplan. Budget vs. Actuals. Last Year vs. This Year. What-if Scenario A vs. What-if Scenario B. As an Anaplan model builder, solution architect, or end-user, you know that comparing versions is a foundation of insightful…
-
Use cases for Anaplan XL
Author: Audrey Neet is a Certified Master Anaplanner and Director at Tru Consulting. Anaplan XL (AXL) is one of the many products Anaplan offers. It extends how users can interact with Anaplan data beyond the UX, providing additional flexibility for targeted analysis and reporting. With AXL, users can design reports and…
-
Anaplan introduces Snowflake Writeback in Pipelines
Author: Kira Wagner is a Product Owner at Anaplan. Snowflake Writeback is now available as a new addition to our integration capabilities. As the first of several planned writeback connectors, this feature is part of the Pipelines functionality in Anaplan Data Orchestrator. It allows you to move transformed and validated…
-
How I Built It: Supply Chain Transport Optimizer in Anaplan
Author: Author: Soumya Bhattacharya is a Certified Master Anaplanner and Advisory Manager at Accenture. In this ‘How I Built It', I’ll show how Anaplan’s Optimizer can be used to demonstrate effective transportation and supply planning across a network of suppliers and distribution centers. By leveraging Anaplan’s modeling…
-
How I Built It: Sensitivity analysis
Author: Casey Pham is a Certified Master Anaplanner and Director of FP&A Systems at Yext. In this ‘How I Built It’ video I'll show how I built a model and process to run a sensitivity analysis. Tens or hundreds of scenarios without overloading the model with too many scenario list items and manually updating driver inputs…
-
On-Demand Calculation in Polaris
Author: Dave Smith is a Senior Product Manager at Anaplan. We are thrilled to announce the rollout of On-Demand Calculation in Polaris, a feature that significantly enhances performance and efficiency for our users. On-Demand Calculation is designed to compute values only when they are needed, leading to a more optimized…
-
Convert a string to a number in ADO
The venta_neta_euro column in the Transformation View represents a company’s sales at a specific level of detail. Currently, this column is stored as a string, and I need to convert it into a numeric value while keeping the "," as the decimal separator. I tried using CAST to convert it to FLOAT, but it throws an error…
-
Question certificat
bonjour, le certificat de notre ANAPLAN arrive à expiration le 12/06/2026. Est ce vous (ANAPLAN ) qui nous fournissez un nouveau certificat ? Merci Jean-François VENISSE M +33 6 34 16 34 22 jean-francois.venisse@abeille-assurances.fr 80 Avenue de l’Europe, 92270 Bois-Colombes
-
Assistance with 7.2.3 Employee Details Upload
Hi I was having trouble with the mapping and played around the system to attempt to figure it out but now I'm totally lost. When I tried uploading I get this mapping page, can someone provide me with directions on how to course correct?
-
Anaplan implementation: A game of snakes, ladders, and smart moves
Author: Pradip Kakade is a Certified Master Anaplanner and Sr. Principal Consultant of Enterprise Solutions at Genpact. Ask anyone who has been part of a Major Anaplan E2E implementation, and they will tell you: the journey is never a straight line. You build momentum, you feel confident, and then — snap. A hierarchy…
-
Is it possible to color line item header for single line item ?
Hi Is it possible to color any line item in NUX we can color the cells but can we color the header of any line item in NUX. So i wanted to color only the WP0 part not all the line items in the view i have used cf for cell but is it possible for line item
-
Lesson 13.6.4 doesnt show the year information in the UX but it shows in the module. Why?
Lesson 13.6.4 doesn’t show the year information in the UX, but it does show it in the module. Why?
-
[Part 2] Enhancing Anaplan Audit Log Data Extraction with a Streamlined Python Solution
The Anaplan Audit History project, consisting of several Python modules and a configuration file, works synergistically to streamline the process of fetching, formatting, and loading Anaplan audit log data into a preconfigured Anaplan Model. The project leverages the Anaplan REST API, the Python Pandas library for…
-
Set the delimiter for CSV Exports
The European format for CSV file is a semi colon delimiter and a comma decimal point. The current behaviour is some European users seem to get an export in this format even though it is not supported in anaplan. The windows/browser formatting seems to take over while other users get the more usual comma delimited file.…
-
UX Native selector Supress Zero
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Polaris specific Use case: In classic we stage lists to only have the nodes with numbers being created (e.g. Customer_account) to…
-
Powerbi Issues
Hello - I've had perfectly working powerbi extract from Anaplan until this Monday. We havent introduced any changes in the model. The query fails in the navigation step right after source. I get the error "The column: Column1 not found in the table". Experimenting with a clean file i get the same error before i do any…
-
L2 1.7.4.6 Load Employee Details
In L2 Training when i am trying to complete 1.7.4.6 Load Employeee Details, in the actions tab, i am unable to Edit the file. It say file not avaible. I am unable to complete the activity, any help?
-
Anaplan XL - Setting a Report Property: Which Sheet Is Displayed Upon Opening?
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Setting a Report Property to Determine Which Sheet Is Displayed Upon Opening When a file is saved, the report currently opens to the…
-
Workflow historization for auditability
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Currently it is possible to delete a completed workflow. Unfortunately this does not meet internal requirements for auditability. Who…
-
Action to reset Index
Hello, It would be beneficial if we could add an Anaplan action to reset the index of production data, so we can use it in our processes right after cleaning the lists. At present, we use the API for this, but it's done outside our main processes. Regards, Roba Sajadian Improvement Manager
-
"Select All Search Results" option for filtering the list line item in Grid Card
Hello, As a representative of people working with Anaplan on a daily basis, I would like to add an option to select all search options for List Line item in the grid card. Our users often search for items based on a specific phase in the product description or product name etc. These items are added to the lists line item…
-
How to approach a user story?
Author: Devrath Ahuja is a Certified Master Anaplanner with over six years of experience in implementing and delivering global Anaplan solutions. As someone starting out on their Anaplan journey, sometimes user stories and the build can feel overwhelming. Have you ever looked at a user story and wondered, “Where should I…
-
3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
I inserted the formula, but there was no change. Could you please send me a screenshot of your DAT01? Maybe the issue is there.
-
Level 3. QUO06 Tenure Calculation
Hello, Can you please review my formulas here: i am not sure why I see 5+ years here for everyone: Thanks,
-
Anaplan Level 3 Assign accounts to territory
Hi, when I am assigning the account to the territory I am always facing error as below and account never get assigned to the territory , what could be the reason ? When I use same method for unassign it works .
-
How I Built It: Period-driven variance reporting
Author: Nizar Cherkaoui is a Certified Master Anaplanner and EPM Manager and Solution Architect at VISEO. In this How I Built It video, I demonstrate how to design period-driven variance reporting in Anaplan when comparison logic is unknown upfront and flexibility is required. Instead of embedding period choices directly…
-
YTD Should Exclude Current Month and Include Actuals Only
Currently, Anaplan’s native YTD (Year-to-Date) calculation includes the Current Period, even when that period contains forecast values. Issue From a financial planning and FP&A perspective, YTD is expected to represent Actuals only. However, Anaplan calculates YTD including the Current Month, which can contain forecast…
-
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
-
Show List Name in Blueprint Format Column (or as an additional column at the end)
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: When working in Blueprint view or exporting module blueprints, list-formatted line items do not clearly display the list name. In…
-
Activity: Prepare Data Exports
Hello, i had a trouble to understanding to fill the formula on "Code" line item, if the purpose was to get the code on G3 Location, why don't just make the line item format List and refrence G3? well i try that, and i got another question, why you cannot refrence straight to G3 grid Code? and what the downstream mean in…
-
User story 3.3 To derive Monthly Commission Forecast
Hi, My values of monthly commission forecast is not matching the Check your build values. Please help to identify where I am wrong. As I have attached screenshots of the blueprint and module grid view. Thanks, Sre Varshaa S
-
I need to flow data from a model DAT01a in PBF Dev to PBF Consol
I need to flow data from a model DAT01a in PBF Dev to PBF Consol, we use connectors to do this OUT3A and OUT3B Any instructions or tips on how to build or test the data can be flowed through to PBF Consol?
-
1.8.5.1 Import Data into G1 Region List
Hi Everyone, I am unable to import G1 Region List code from Data hub to Supply chain. Could anyone help with this please? The GI region meant to pick up from SYS05 Region Details 2 code but it didnt. I tried to import it through general list. I dont know what went wrong
-
Polaris Training in Classic Workspace.
Hi, I currently don't have access to the Anaplan Polaris workspace. Is it acceptable to proceed with the training in the classic workspace, or will this create issues later and prevent me from obtaining Polaris certification? Let me know if you have any insight on this.
-
Question for 4.8.2 Employee Mapping
I am having issues with mapping. The upload is successful but in the code, some of the employees have names instead of the country code. Can someone assist and let me know what I am doing wrong? I went back to previous lessons to make sure I am doing the right mapping as well.
-
PlanIQ algorithm properties
Review the table below for information on each algorithm and its specific properties. Question? Leave a comment!