---
id: video/Fk6kWTe3f2Y
type: video
title: Deploy Analysis Views with AL Code in Business Central 2026 Wave 1 (No Manual Setup)
summary: Business Central 2026 wave 1 (version 28, runtime 17) lets analysis views be exported from analysis mode as analysis.json files, referenced in a new analysis views section of an AL list page, and deployed through an extension as locked tabs that users can duplicate. The demo on item ledger entries uses Copilot and the Claude add-in in Excel to propose view designs and JSON, then publishes them via AL.
tier: community
language: en
tags:
  - analysis views
  - al extensions
  - json deployment
  - ad hoc analysis
  - copilot
  - item ledger entries
  - analysis mode
  - version control
  - multi-tenant deployment
  - pivot tables
  - dimensions
  - queries
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:21:45.136Z"
  flags: []
generated:
  at: "2026-10-07T23:21:45.190Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: c44b59e6f11e9a3e770a0b12960e22a0fc21fb46bbd77fbf0de8a031676e6b21
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=266s
    title: "Analysis views packaged in AL extensions: preview"
    date: "2026-03-05T04:14:52.000Z"
    commit: null
    t: 266
    quote: I created yesterday one sandbox dev 28. And you can see here that we have version 28 preview here.
  - kind: video
    url: https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=266s
    title: "Analysis JSON export from web client: preview"
    date: "2026-03-05T04:14:52.000Z"
    commit: null
    t: 266
    quote: I created yesterday one sandbox dev 28. And you can see here that we have version 28 preview here.
  - kind: video
    url: https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=12s
    title: Deploy Analysis Views with AL Code in Business Central 2026 Wave 1 (No Manual Setup)
    date: "2026-03-05T04:14:52.000Z"
    commit: null
    t: 12
    quote: in Business Central 2026 wave 1 or version 28 uh Microsoft quietly is going to ship something um that uh will change the way
  - kind: video
    url: https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=24s
    title: Deploy Analysis Views with AL Code in Business Central 2026 Wave 1 (No Manual Setup)
    date: "2026-03-05T04:14:52.000Z"
    commit: null
    t: 24
    quote: You can now uh export uh uh as JSON one analysis view uh and once you have the JSON you can include that JSON
  - kind: video
    url: https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=44s
    title: Deploy Analysis Views with AL Code in Business Central 2026 Wave 1 (No Manual Setup)
    date: "2026-03-05T04:14:52.000Z"
    commit: null
    t: 44
    quote: the analysis views now will be part of the codebase. uh we can version control it and we can deploy it across environments
  - kind: video
    url: https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=124s
    title: Deploy Analysis Views with AL Code in Business Central 2026 Wave 1 (No Manual Setup)
    date: "2026-03-05T04:14:52.000Z"
    commit: null
    t: 124
    quote: analysis views can now be packaged and delivered as part of fail extensions for list pages including extensions and customizations
  - kind: video
    url: https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=172s
    title: Deploy Analysis Views with AL Code in Business Central 2026 Wave 1 (No Manual Setup)
    date: "2026-03-05T04:14:52.000Z"
    commit: null
    t: 172
    quote: we have now a new section analysis views in the page. Uh just like we had before layout or modify
links:
  learn: []
  objects:
    - object/page/31
    - object/page/38
    - object/table/32
    - object/table/18
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: Fk6kWTe3f2Y
channel: yt-bcmusings
source_name: Business Central Musings
url: https://www.youtube.com/watch?v=Fk6kWTe3f2Y
published_at: "2026-03-05T04:14:52.000Z"
duration_s: 1767
captions: derived
audience:
  - developer
  - functional consultant
  - administrator
chapters:
  - t: 0
    title: Overview of analysis views feature in BC 2026 Wave 1
  - t: 98
    title: Microsoft documentation and technical implementation details
  - t: 253
    title: Exporting and examining analysis JSON files
  - t: 363
    title: Item ledger entries demonstration with locked and unlocked views
  - t: 489
    title: Using Copilot in Excel to design analysis views
  - t: 612
    title: Generating analysis JSON files from Copilot suggestions
  - t: 761
    title: Creating and deploying analysis views through AL extension
  - t: 895
    title: Publishing and testing monthly trends analysis with Copilot
  - t: 1101
    title: Creating item profitability analysis
  - t: 1260
    title: Demonstrating pivot tables and dimensions
  - t: 1418
    title: Manual configuration and JSON file naming
  - t: 1577
    title: Related content and learning resources
features:
  - name: Analysis views packaged in AL extensions
    status: preview
    t: 12
    verified: true
    status_source: video
  - name: Analysis JSON export from web client
    status: preview
    t: 144
    verified: true
    status_source: video
  - name: Locked analysis views
    status: unclear
    t: 393
    verified: false
    status_source: video
  - name: Copilot for Excel analysis design
    status: unclear
    t: 500
    verified: false
    status_source: video
  - name: Data export to Excel for analysis
    status: unclear
    t: 475
    verified: false
    status_source: video
  - name: Analysis view component in page AL syntax
    status: unclear
    t: 158
    verified: false
    status_source: video
  - name: Multi-environment analysis view deployment
    status: unclear
    t: 44
    verified: false
    status_source: video
  - name: Analysis views via AL code
    status: unclear
    t: 783
    verified: false
    status_source: video
  - name: Ad hoc analysis mode
    status: unclear
    t: 864
    verified: false
    status_source: video
  - name: Analysis view dimensions and pivoting
    status: unclear
    t: 1260
    verified: false
    status_source: video
  - name: Analysis view export and import cycle
    status: unclear
    t: 1487
    verified: false
    status_source: video
  - name: Cross-table analysis views
    status: unclear
    t: 1441
    verified: false
    status_source: video
  - name: Analysis view JSON file format
    status: unclear
    t: 1565
    verified: false
    status_source: video
objects_mentioned:
  - page item list
  - page item ledger entries
  - page my sales analysis page
  - table Item Ledger Entry
  - table Customer
  - query Fixed Assets Query
  - query Projects Query
quotes:
  - t: 12
    text: in Business Central 2026 wave 1 or version 28 uh Microsoft quietly is going to ship something um that uh will change the way
    check: exact
  - t: 24
    text: You can now uh export uh uh as JSON one analysis view uh and once you have the JSON you can include that JSON
    check: exact
  - t: 44
    text: the analysis views now will be part of the codebase. uh we can version control it and we can deploy it across environments
    check: exact
  - t: 124
    text: analysis views can now be packaged and delivered as part of fail extensions for list pages including extensions and customizations
    check: exact
  - t: 172
    text: we have now a new section analysis views in the page. Uh just like we had before layout or modify
    check: exact
---

# Deploy Analysis Views with AL Code in Business Central 2026 Wave 1 (No Manual Setup)

> Business Central 2026 wave 1 (version 28, runtime 17) lets analysis views be exported from analysis mode as analysis.json files, referenced in a new analysis views section of an AL list page, and deployed through an extension as locked tabs that users can duplicate. The demo on item ledger entries uses Copilot and the Claude add-in in Excel to propose view designs and JSON, then publishes them via AL.

[Watch on YouTube](https://www.youtube.com/watch?v=Fk6kWTe3f2Y) · Business Central Musings · 2026-03-05 · 29:27 · tier community · reviewed (checked by Opus)

## Overview

The video shows how an analysis view built in analysis mode in the web client can be exported as a JSON file, added to an AL project and referenced from a page. The view is then deployed with the extension, so it can be version controlled and rolled out across environments and tenants without manual setup. The demo uses item ledger entries, with locked and unlocked views, pivot rows and columns, and dimensions from related tables.

The presenter also exports item ledger data to Excel and uses Copilot to suggest analysis designs, such as monthly trends and item profitability, and to generate JSON proposals. The video covers caveats on file naming, a publish error when the extension is used in multiple apps, and slow loading of related tables in the UI. It ends with pointers to Microsoft-provided queries for fixed assets and projects.

## Key points

- Export an analysis from analysis mode in the web client (Share > Export definition) as JSON and include it in the AL extension.
- The definition file name must end with analysis.json, otherwise an error occurs.
- AL pages get a new analysis views section where each analysis view has a name, a path to the analysis JSON file and a caption. A snippet for analysis view exists in VS Code.
- Views deployed this way show as locked tabs in analysis mode; users cannot change filters or layout but can duplicate them. In the demo a duplicate lost its pivot and had to be reconfigured.
- Item ledger entries were exported to Excel; Copilot (which installed Python packages) and the Claude add-in for Excel suggested analysis designs and JSON definitions, such as monthly trends and item profitability by customer posting group.
- In the demo, publishing first failed with 'used in multiple apps'; the presenter uninstalled the earlier extension and published again.
- Analysis views can add columns from related tables such as Customer, though loading related tables was slow in the demo.

## Chapters

- [0:00](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=0s) Overview of analysis views feature in BC 2026 Wave 1
- [1:38](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=98s) Microsoft documentation and technical implementation details
- [4:13](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=253s) Exporting and examining analysis JSON files
- [6:03](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=363s) Item ledger entries demonstration with locked and unlocked views
- [8:09](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=489s) Using Copilot in Excel to design analysis views
- [10:12](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=612s) Generating analysis JSON files from Copilot suggestions
- [12:41](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=761s) Creating and deploying analysis views through AL extension
- [14:55](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=895s) Publishing and testing monthly trends analysis with Copilot
- [18:21](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1101s) Creating item profitability analysis
- [21:00](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1260s) Demonstrating pivot tables and dimensions
- [23:38](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1418s) Manual configuration and JSON file naming
- [26:17](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1577s) Related content and learning resources

## Features

| Feature | Status | At | Evidence |
|---|---|---|---|
| Analysis views packaged in AL extensions | preview, demoed | [0:12](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=12s) | "I created yesterday one sandbox dev 28. And you can see here that we have version 28 preview here." ([4:26](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=266s)) |
| Analysis JSON export from web client | preview, demoed | [2:24](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=144s) | "I created yesterday one sandbox dev 28. And you can see here that we have version 28 preview here." ([4:26](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=266s)) |
| Locked analysis views | status not stated, demoed | [6:33](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=393s) |  |
| Copilot for Excel analysis design | status not stated, demoed | [8:20](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=500s) |  |
| Data export to Excel for analysis | status not stated, demoed | [7:55](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=475s) |  |
| Analysis view component in page AL syntax | status not stated, demoed | [2:38](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=158s) |  |
| Multi-environment analysis view deployment | status not stated | [0:44](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=44s) |  |
| Analysis views via AL code | status not stated, demoed | [13:03](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=783s) |  |
| Ad hoc analysis mode | status not stated, demoed | [14:24](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=864s) |  |
| Analysis view dimensions and pivoting | status not stated, demoed | [21:00](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1260s) |  |
| Analysis view export and import cycle | status not stated, demoed | [24:47](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1487s) |  |
| Cross-table analysis views | status not stated, demoed | [24:01](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1441s) |  |
| Analysis view JSON file format | status not stated | [26:05](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1565s) |  |

## 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 31 "Item List"](../objects/page/31.md) at [4:36](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=276s)
- [page 38 "Item Ledger Entries"](../objects/page/38.md) at [6:03](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=363s)
- page "my sales analysis page" at [3:16](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=196s)
- [table 32 "Item Ledger Entry"](../objects/table/32.md) at [17:45](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1065s)
- [table 18 "Customer"](../objects/table/18.md) at [24:01](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1441s)
- query "Fixed Assets Query" at [26:49](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1609s)
- query "Projects Query" at [27:15](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=1635s)

Not found in BC28-30: page "my sales analysis page", query "Fixed Assets Query", query "Projects Query".

## Quotes

- [0:12](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=12s) "in Business Central 2026 wave 1 or version 28 uh Microsoft quietly is going to ship something um that uh will change the way"
- [0:24](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=24s) "You can now uh export uh uh as JSON one analysis view uh and once you have the JSON you can include that JSON"
- [0:44](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=44s) "the analysis views now will be part of the codebase. uh we can version control it and we can deploy it across environments"
- [2:04](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=124s) "analysis views can now be packaged and delivered as part of fail extensions for list pages including extensions and customizations"
- [2:52](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=172s) "we have now a new section analysis views in the page. Uh just like we had before layout or modify"

## Disclaimers in the video

- [4:26](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=266s) preview: you can see here that we have version 28 preview here
- [14:55](https://www.youtube.com/watch?v=Fk6kWTe3f2Y&t=895s) other: Cannot publish it because this is used in multiple apps

Presenters (as heard): Marcel Chabot, E.S. Verland.