What's New: Data Analysis (2025 release wave 1)

Overview

The video recaps analysis mode, introduced in 2023 release wave 2, and the remaining gap: cross-entity analysis has required developers to create queries. The new feature lets users add columns from related tables and pages directly in analysis mode, using existing table relationships. A demo uses the Sales order list with related tables such as Customer.

The video also shows opening an analysis mode view in Excel, including related columns, and a developer change: the AL get URL method has a parameter to open a page in analysis layout. Limitations are stated: Copilot assist does not work on related fields, calculated fields are ignored, and Excel export limits the number of rows.

Key points

• Users can add fields from related tables and pages in analysis mode on list pages, without a developer creating a query.
• Related tables are joined through existing table relationships using a left outer join.
• Copilot analysis assist is not supported on related fields, and calculated fields are not supported and are ignored.
• A short disclaimer appears the first time fields are added, covering removed calculated fields and Excel row limits.
• Analysis mode data, including related columns, can be opened in Excel from the data area context menu (works in all versions) or the analysis tab context menu (supported from 2024 release wave 2, backported in 25.3); the number of rows is limited.
• The AL get URL method has a new parameter to open a page in analysis mode layout, so code can link directly to analysis views.
• The speaker says the related-tables feature is planned after general availability of the release, likely in a minor update, estimated at 26.2 or earlier.

Features

AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

• page “Sales line” at 2:17
• table 18 “Customer” at 2:57
• table “Sales head” at 3:17
• page 9305 “Sales Order List” at 3:37

Not found in BC28-30: page “Sales line”, table “Sales head”.

Quotes

• 0:25 “in 2023 release Wave 2 we launched the ability to analyze data on list pages with this you could quickly extract insights from your”
• 1:01 “a challenge has been analyzing more complex cross entity data relationships which still has required developers creating queries”
• 1:41 “this is coming this release but it’s also coming in a minor so you will have to wait a bit more so it’s estimated”
• 8:00 “the only limitations that we have with this redit h fields are that copilot assist is not just supported on them”
• 9:12 “which is supported from 2024 release Wave 2 as a basically a back port in version 25.3”
• 10:53 “we’re now adding that the AL get URL method um has a parameter that you can specify that you want for instance the analysis”
• 12:13 “do note that this feature is planned to be available after General availability of the release so right now we are looking at likely”

Disclaimers in the video

• 1:41 coming-later: this is coming this release but it’s also coming in a minor so you will have to wait a bit more so it’s estimated at 26.2 or earlier
• 4:08 subject-to-change: we’ll get a a short disclaimer when I add fields for the first time just to make the user aware that um calculated fields are going to be removed and there’s also some limitations with opening Excel regarding the number of rows
• 8:00 other: the only limitations that we have with this redit H fields are that copilot assist is not just supported on them and also that calculated fields are not supported therefore they will be ignored
• 12:13 coming-later: do note that this feature is planned to be available after General availability of the release so right now we are looking at likely the minor update

Presenters (as heard): Peter, Blan.