-
Graph time selection?
Hello, I have a table and a graph based on a table. The selection that I have in Years, Quarters and Month. The Table should move on every selection of Year, Quarter or Month but the Graph I just want to stay only on the year selection. So my graph should show all the month of the year regardless of the selection of the…
-
How I Built It: Data Hub basics
Author: Josh Baker, Certified Master Anaplanner and Senior Vice President at PJT Partners. Hi Anaplan Community! I’m excited to share my new ‘How I Built It’ video on Data Hub basics, including setup, automation, and model to model data/attribute loads. For some background: The demo utilizes comma separated files…
-
General Question on Locking the Actuals
Hi All, How do you manage the master data changes? As the changes in anaplan are retrospective. Lets say there is a change in the master data and it will impact the actual numbers reported. Is there any native way to lock the numbers? Please don't recommend the snapshotting process as it will not be sustainable for my…
-
How I Built It: Number format converter (thousands and millions)
Hello Anaplanner Community! I’m excited to participate in another ‘How I Built It’ video with a Number Format Converter (thousands and millions) tutorial. This video walks you through how to dynamically update UX grid number formats on all tables and charts. This enables users to have different number formats enabled for…
-
April 2024 Community Member Spotlight: Kirill Kuznetsov
This month we are thrilled to feature @KirillKuznetsov as our Community Member Spotlight! Kirill has been active in the Community since 2017, a Certified Master Anaplanner for the last four years, and is currently a Community Boss. You can find Kirill supporting members with answering questions (he has over 570 comments!),…
-
Snapshot Challenge with #list
My scenario today, Integration runs everyday and clear the below numbered list with data. Since the build has been done without the code i'm struggling to create the code with unique combination. My objective is : I want to copy the current data before the delete process will execute. and compare it against the data that…
-
Best Possible solution - Master data changes
Hi, I would like discover best possible solution. The integration happening from SAP to Anaplan (daily basis). The issue is that whenever there is a change in the master data , it is impacting the final #s of budget / actuals / forecast which is obvious. How do you overcome this scenario? Like budget needs to be locked…
-
Conditional Formatting Help
Hi All, Checking the possibility of conditional formatting for FY 24 -GAP as shown below. I don't want the BP or Fcst to be formatted. 2. Is it possible to extend the Color formatting to only certain line items label (like net revenue, GM and GM %) needs color formatting 3. Is it possible to have spacing between Forecast…
-
Anaplan Model Back Up Automation -[Copy and Archive] process
Considering that the Copy & Archive feature under Manage Models in Anaplan can copy and archive a model without impacting storage size limits. How can I implement an automated daily backup solution for Anaplan model data, given that there is currently no in-built scheduling feature for the Copy & Archive ? My clients…
-
Current Date Update
Is there any other way that we can update the current date with out using cloud works, Anaplan connect, or any middle ware ETL tools. Through the anaplan system i need to update it not manually and not by uploading the excel file
-
Anaplan coach’s playbook
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. Seldom has there been a time where a single model builder can solve all an enterprise’s business problems on their own. Anaplan engagements work better with more people than with just the efforts of an individual. That being said,…
-
How I Built It: Refreshing current date in an Anaplan model using Cloudworks
Author: Sai Bandaru is a Certified Master Anaplanner with six years of experience architecting Anaplan models. Hello Anaplanners! In today's fast-paced business environment, having accurate and up-to-date information is crucial for making informed decisions. In this ‘How I Built It’ tutorial, I'll explore a practical and…
-
March 2024 Community Member Spotlight: Wendy Wen
March is Women's History Month and we're recognizing some of our outstanding female Community members! Our Journey podcast episode featured Silvia Di Feliciantonio (@SilviaDF) , and now in our Member Spotlight we are excited to introduce Wendy Wen (@Wendy)! Wendy is a trailblazing Certified Master Anaplanner whose…
-
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
-
February 2024 Community Member Spotlight: Alessio Pagliano
Join us in celebrating @Alessio_Pagliano as our featured Community Member Spotlight for February! Alessio's inspiring journey in the Anaplan ecosystem spans seven years, marked by notable achievements such as becoming a Certified Master Anaplanner and a Community Boss. Explore Alessio's impressive Anaplan journey and…
-
A conversation with Austin van der Linden — Journey | Anaplan Community Podcast
Welcome to our second podcast episode of 2024! Tune in today to hear Dennis Lemoine (@DennisL), Director of Customer Engagement & Experience, chat with Austin van der Linden (@Austinv) — Certified Master Anaplanner, Certified Solution Architect, and Corporate FP&A Technical Lead at Dentsply Sirona. Austin has been with…
-
Certified Master Anaplanner Eligibility
Certified Master Anaplanners are Anaplan’s most experienced platform evangelists who share a common technical language and are involved in the structural development of their models. Anaplan's current customers, registered partners, and employees are all eligible to become a Certified Master Anaplanner, given they're…
-
A conversation with Misbah Ansari — Journey | Anaplan Community Podcast
We’re kicking off our 2024 podcast season with a well-known Community name! Join host Kas Gengadaren (@KasG), Anaplan’s APAC Ecosystem Manager, as she interviews one of top Community members — Misbah Ansari (@Misbah), Certified Master Anaplanner, Anaplan Community Boss, Planual co-admin, and CEO and Founder at Miz Logix.…
-
How I Built It: Beginners guide to integrating with Anaplan using Python
Author: Matt Budd, Certified Master Anaplanner and CIO at Nightingale College and Solution Architect at Dialed Solutions. Hello Anaplan Community! In the last year, I've done a lot of work around creating automation and integrations with Anaplan using Python. Several solutions I've built using Python include: Creating a…
-
How do I use a line item formatted by a month for mapping in a column dimensionalized by time
I have a value (in this instance it is the number 13 in January 24) that I need to populate in the line item below it in the month of February 25. The entire module is dimensionalized by time (month). The Feb 25 formula is an add months function that references an input from a different module based on the quarter of the…
-
New Academy badging for Certified Master Anaplanners and Solution Architects!
The Anaplan Academy is thrilled to share some exciting news with you! In response to your valuable feedback and to enhance the recognition of your achievements, the Academy is thrilled to announce the launch of our highly anticipated Anaplan Certification Badge, designed to showcase your expertise in Anaplan and provide…
-
How I Built It: Fantasy Football draft
Author: Zach Hird is a Certified Master Anaplanner and Senior Consultant at Peloton Consulting Group. Hello Anaplanners! Learn how I used Anaplan to aid my fantasy football draft experience in this fun and different ‘How I Built It’ tutorial. I use live fantasy football data to give myself a competitive advantage while…
-
How I Built It: Two-step approval process and audit trail
Greetings fellow Anaplanners! In this episode of ‘How I Built It’, I show you how I build a typical two-step approval process and corresponding audit trail in Anaplan. This functionality accomplishes the following requirements: Analyst users can submit a batch of process data or model results. The manager user then can…
-
A conversation with our Community Bosses — Journey | Anaplan Community Podcast
2023 is rapidly coming to an end, and to wrap up the year we invited a few of our Community Bosses to join Dennis Lemoine, Director of Customer Engagement & Experience, for our nineth episode of Journey, an Anaplan Community podcast. Please welcome: Andrew Tye (@andrewtye) , Anaplan Process Developer at Aviva. Location:…
-
How I Built It: Flagging new list items
Author: Chris Allen is a Certified Master Anaplanner and Manager at Allitix. Hello, and thank you for checking out my ‘How I Built It’ video tutorial on flagging new list items! The video will walk you through the process of flagging list items as "new." The key step in the process relies on an import to flag all current…
-
November 2023 Community Member Spotlight: Julie Ziemer
This month we are shining the spotlight on @jziemer, who has been part of the Anaplan Community for over six years! A Certified Master Anaplanner since 2016, and a recently appointed Community Boss, Julie has been an incredible Community leader. Read more to learn about Julie's Anaplan journey, deep Anaplan knowledge, and…
-
3.3.5.2A Beginning Inventory formula
Hello I need some help in this formula Beginning Inventory: This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week for all other weeks of the year. i have just created these in my…
-
November 2023 Community Q&A Challenge — join the discussion and collect a badge!
Building on the incredible success of our inaugural Community Q&A Challenge in September 2023, we're thrilled to announce our second Q&A Challenge! In the Anaplan Community, we've always believed that the key to success lies in members coming together to connect, share knowledge, and support one another. Your enthusiastic…
-
Can we capture a tenant-based date/time value?
With CloudWorks, we can schedule based on date/time with a selected time zone, but that is not involved in any user-facing functionality. As I am working through the new Workflow training, I realize that the platform is now providing interactions with end-users based on date/time values in a selected time zone. This has me…