-
REP02 Size Margin Report Module in Lesson 8 Activity 8.8.3
Hello everyone, I am going through the L1 model builder course, and I am stuck at the activity 8.8.3 "Add Size Margin Report Module". I think I am doing the right things, but in certain combinations, I don't see values in my module. I am attaching all of the screenshots in this docx file. In fact, after creating this…
-
Talent Builder Graduate Mini Resume - Sarthak Kajle
Name: Sarthak Kajle Location: Navi Mumbai, Maharashtra, India Certification: Anaplan Certified Model Builder (Level 1 & Level 2) Educational Background: MMS (Finance) BAF (Accounting & Finance) Profile Summary: Business Analyst with 4 years of experience in financial reporting and analytics using SQL, Tableau, and Excel.…
-
Talent Builder Graduate Mini Resume - Anoop Chhabra
Name: Anoop Chhabra Location: Bangalore, KN, India Certification: Anaplan Certified Professional Model Builder Educational Background: Anaplan Academy, IIT-D (B.Tech), IIM-B(MBA) Profile Summary: I have a vast experience across various domains & technologies for clients from different industries - Aero, Agro Chemicals,…
-
Display Item Deletion Count in UX
When deleting items from a list via the UX, there is no indication of how many items are being removed. The model backend provides this count during deletion, but the same visibility is absent in the UX experience. It would be helpful to surface this count to users when performing deletions through the front end.
-
Talent Builder Graduate Mini Resume - Monica Drake
Name: Mónica Drake Location: Los Angeles, CA Certification: Certified Anaplan Model Builder (Level 1 &2) Educational Background: Anaplan Academy, George Washington University (Digital Marketing), Universidad San Marcos (Public Accounting) Profile Summary: As a Certified Anaplan Model Builder and Business Operator, I…
-
"Saved Views" on Actions & other Model Objects like Time, Versions, Users, Source Models, etc
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: in Actions - the only way to get the information is to manually export or to have an export action. It would be great if I could make…
-
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?
-
Talent Builder Graduate Mini Resume - Sandeep Reddy
Hello Everyone, I’m excited to be transitioning into the Anaplan and EPM ecosystem after 11+ years in business consulting and strategic research across automotive and industrial sectors. I have completed the Anaplan Certified Professional Model Builder certification with hands-on exposure to Connected Planning, FP&A…
-
🚀 Stop Writing Nested IFs in Anaplan - Use LIS Instead
If you’ve built complex Anaplan models, you’ve probably written formulas like this: IF A THEN IF B THEN IF C THEN Value1 ELSE Value2 ELSE Value3 ELSE Value4 It works. But it’s slow. It’s hard to debug. And six months later… even you won’t understand it. Let’s talk about why nested IFs hurt performance and how Line Item…
-
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…
-
Blueprint View - "Is Summary" and "Parent" - Impact of Clearing These Values
Hello and thanks in advance for any assistance! I am hoping to better understand what the "Is Summary" and "Parent" in the Blueprint View impact in the model? My end goal is that I would like to set all of the "Is Summary" to FALSE and clear out the "Parent" in the Blueprint view. I do not fully understand what the impact…
-
Do scheduled CloudWorks actions run in parallel or sequentially?
If we schedule two CloudWorks actions to start at the same time, using the same source model but different saved views, and updates two different target models, will they run in parallel or sequentially (with one finishing before the other starts)?
-
Aligned by Design - A proportional cascade framework for multi-level forecast reconciliation
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: In enterprise planning and forecasting, we aim to produce statistically sound forecasts at multiple organisational levels (e.g.…
-
Talent Builder Graduate Mini Resume - Caleb Bourgeois
Name: Caleb Bourgeois Location: Greenville, South Carolina, United States Certification: Anaplan Professional Model Builder Anaplan Level 1 Model Building Anaplan Level 2 Model Building Anaplan Talent Builder Graduate Educational Background: 15+ years of professional experience in client-facing design, communications,…
-
Talent Builder Graduate Mini Resume - Dhanesh N. Kalkar
Name: Dhanesh N. Kalkar Location: Mumbai Certification: Anaplan Model Builder Google Project Management Anaplan Way Educational Background: DME, BE (Mechanical Engineering) Profile Summary: I’m a Technical Consultant with over 11 years of experience, increasingly focused on leveraging automation and connected planning to…
-
Talent Builder Graduate Mini Resume - Keyley Mable
Name: Keyley Mable Location: New Orleans, LA, United States Certification: Anaplan Certified Model Builder Educational Background: Bachelor of Science in Kinesiology with a minor in Chemistry Profile Summary: Results-driven consultant with a passion for leveraging technology to solve complex business challenges. Currently…
-
3.4.3 Activity: Create Country Summary Module
Hi, I have a doubt in level 2 sprint 3.4.3 Activity: Create Country Summary Module I did the following :- Step 1 → Created a new column "Country Made in" in SYS08 SKU details Step 2 → Wrote a formula Parent(Supplied By) to bring parent of the location i.e. country in "Country Made in" column Step 3 → I have written the…
-
SUM and LOOKUP | Model Optimization Team series
Hi! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
-
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…
-
Best Finding for Truly Understanding Optimizer (Conceptually & Technically)
🚀 Best Finding for Truly Understanding Optimizer (Conceptually & Technically) One of the most effective ways I’ve found to deeply understand Anaplan optimizer both conceptually and technically is by working hands‑on with Excel Solver. Why? Because Solver forces clarity. It makes you explicitly define: 🔹 Decision variables…
-
Default today's date on UX with ADO
Hi everyone, I am trying to make a UX Page with today's date as default. That means, everyday when I enter in my UX page, I will see today's date (so the date will change everyday) and the figures related to the date, will change accordingly. Any ideas or tips&tricks? I need to men tion that I need to use ADO and not…
-
Anaplan Export (Tabular Multiple Column): Saved View Line Items
When exporting from Anaplan using "Tabular Multiple Column", will the export include only the line items saved in the saved view, or will it also export line items that are excluded from the saved view?
-
Model Bulder Mini Resume - Thiago Liberman Trajano
Mini Resume Name: Thiago Liberman Trajano Location: São Paulo, SP, Brazil Certification: Anaplan Certified Model Builder (Level 1 & Level 2) SCRUM Master Oracle Cloud - Data Science Educational Background: Degree in Economics from PUC-SP Master Degree in Economic Development UNIFESP Professional Master Degree in Data…
-
Data Hub: Will multiple imports and loads at the same time slow it down or lock it?
If two spoke models pull data from the same Data Hub at the same time, will it slow down the Data Hub or cause any locking? Also, if the Data Hub is being loaded/updated with a different set of data while it’s sending data to two spoke models, will that slow down the Data Hub or cause any locking/issues?
-
Create export template for Anaplan users to import using months
Author: Tyler Beck is a Certified Master Anaplanner at TBLB LLC, and is currently a Team Lead at CVS Health. Use case An end user needs to export a template from Anaplan using Months as the time period in columns, and qualitative data in rows. When the template is exported as a CSV file the years in the dates turn to days…
-
Result from ISNOTBLANK() is not aligned to LENGTH()
Hi Anaplanners, I have encountered this super weird situation where I am using ISNOTBLANK() formula to identify if there's any characters in my Parent Reporting Sub-Segment (PRSS) column, but some rows (see ss below) is showing ISNOTBLANK() = TRUE even when there's no inputs. When I tried to troubleshoot this with LENGTH()…
-
Lookups to apply to LISS Parent Line items
Hi Anaplan Community, I'm encountering an issue with my Anaplan model where a lookup function isn't picking up values from line item subset with line items that have "Is summary" turned on. If I keep the "Is summary" checked in the source module, the only way I can retrieve the values in this line is by using the "SELECT"…
-
Fiscal to Gregorian calendar conversion in Polaris
Author: David Edwards is a Certified Master Anaplanner and Associate Partner at Columbus Consulting. For retail and consumer goods companies, a common issue occurs when different departments (typically supply chain and finance) utilize different calendar structures. Supply Chain teams often rely on a fiscal calendar (such…
-
Complete Training for Model Builders from Anaplan Academy
New, aspiring, and experienced Model Builders can now come to Anaplan Academy for all the training they need to improve their Anaplan skills. Here’s an overview of the three levels available on demand in the Learning Center or with an instructor either in-person or virtually. Level 1 Model Builder Training is meant for…
-
L3 User Story 2.4
Hi Community, In L3 User Story 2.4 requires the comments to be seen by others. Who should see the comments? That Country Sales Manager's ? and do we have to create a link or add an line item for comments associating with all accounts and then publish it do UX so end user can add comments along side of the accounts…