Introduction
Business Central 2025 Wave 1 introduces an exciting new feature: the ability to add fields from related tables while in Analysis Mode. This update is a game changer for users who rely on deep data insights and custom analytics – no more switching back and forth or asking your developer for every new column!
In this post, I’ll walk you step-by-step through how to use this feature and show you where you can add screenshots to make your blog even more visual and engaging.
Table of Contents
- What is Analysis Mode?
- What’s New: Adding Related Table Fields
- Step-by-Step Guide
- Open Analysis Mode
- Add Fields from Related Tables
- Customize Your View
- Tips & Use Cases
- Final Thoughts
1. What is Analysis Mode?
Analysis Mode lets you analyze and interact with your data directly in Business Central, without exporting to Excel. You can filter, pivot, and drill into data right from your browser.
2. What’s New: Adding Related Table Fields
With Wave 1 2025, you can now include fields from tables related to your primary data source – directly from the Analysis Mode interface. This means richer reports, more insights, and less dependency on developers.
3. Step-by-Step Guide
Step 1: Open Analysis Mode
Navigate to any list page (e.g., Sales Orders, Purchase Invoices) and switch to Analysis Mode.
Step 2: Add Fields from Related Tables
- Click on Choose columns or the + Add field button.
- In the new dialog, you’ll see a section for related tables. Expand the related table you’re interested in.
- Select the fields you want to add and confirm.
Step 3: Customize Your View
- Arrange your columns as needed.
- Apply filters or pivots for more granular analysis.
- Save your view for future use.
4. Tips & Use Cases
- Finance Teams: Quickly add customer or vendor master data to transactional reports.
- Sales Analysis: Bring in product category or salesperson info without leaving your list.
- No Developer Needed: Empower users to extend their own analytics!
5. Final Thoughts
The new capability to add fields from related tables in Analysis Mode is a huge leap forward for self-service analytics in Business Central. One of the hidden Champion features just got better
Discover more from Lubenheimer
Subscribe to get the latest posts sent to your email.