---
id: object/table/7152
type: object
title: Table 7152 "Item Analysis View"
summary: Table 7152 "Item Analysis View" in Base Application (Microsoft.Inventory.Analysis). 17 fields, 6 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "28"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 342454e323cad471bc176ecacf1a06255253102d2d6df3341650eb5f170bf812
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Analysis/ItemAnalysisView.Table.al
    title: src/Layers/W1/BaseApp/Inventory/Analysis/ItemAnalysisView.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/bi-how-analyze-data-dimension
    - https://learn.microsoft.com/dynamics365/business-central/bi-how-create-analysis-views-reports
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/finance/financial-analytics/financial-reporting
    - topic/business-central/business-functionality/sales/sales-analytics
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 7152
name: Item Analysis View
namespace: Microsoft.Inventory.Analysis
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 17
  procedures: 12
  events: 0
  subscribers: 0
relations:
  out: 6
  referenced_by: 6
  pages: 7
  extended_by: 0
  event_subscribers: 0
  calls: 1
  called_by: 0
  implements: 0
---

# Table 7152 "Item Analysis View"

> Table 7152 "Item Analysis View" in Base Application (Microsoft.Inventory.Analysis). 17 fields, 6 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC28.

Base Application · Microsoft.Inventory.Analysis · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Analysis/ItemAnalysisView.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 9370 "Analysis View List Purchase"](../page/9370.md) (2 Learn pages), [Page 9371 "Analysis View List Sales"](../page/9371.md) (2), [Page 9372 "Analysis View List Inventory"](../page/9372.md) (2).

## Properties

| Property | Value |
|---|---|
| Caption | Item Analysis View |
| DataClassification | CustomerContent |
| Permissions | TableData "Item Analysis View Entry" = rimd, TableData "Item Analysis View Budg. Entry" = rimd |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Analysis Area | Enum "Analysis Area Type" | — | enum [Enum 7130 "Analysis Area Type"](../enum/7130.md) |
| 2 | Code | Code[10] | Specifies a code for the analysis view. | NotBlank |
| 3 | Name | Text[50] | Specifies the name of the analysis view. |  |
| 4 | Last Entry No. | Integer | Specifies the number of the last item ledger entry you posted, prior to updating the analysis view. | not editable |
| 5 | Last Budget Entry No. | Integer | Specifies the number of the last item budget entry you entered prior to updating the analysis view. | not editable |
| 6 | Last Date Updated | Date | Specifies the date on which the analysis view was last updated. | not editable |
| 7 | Update on Posting | Boolean | Specifies if the analysis view is updated every time that you post an item ledger entry, for example from a sales invoice. | not editable |
| 8 | Blocked | Boolean | Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine. |  |
| 9 | Item Filter | Code[250] | Specifies a filter to specify the items that will be included in an analysis view. | TableRelation [Table 27 "Item"](../table/27.md) |
| 10 | Location Filter | Code[250] | Specifies a location filter to specify that only entries posted to a particular location are to be included in an analysis view. | TableRelation [Table 14 "Location"](../table/14.md) |
| 11 | Starting Date | Date | Specifies the date from which item ledger entries will be included in an analysis view. |  |
| 12 | Date Compression | Option | Specifies the period that the program will combine entries for, in order to create a single entry for that time period. | OptionCaption: None,Day,Week,Month,Quarter,Year,Period |
| 13 | Dimension 1 Code | Code[20] | Specifies one of the four dimensions that you can include in an analysis view. | TableRelation [Table 348 "Dimension"](../table/348.md) |
| 14 | Dimension 2 Code | Code[20] | Specifies one of the four dimensions that you can include in an analysis view. | TableRelation [Table 348 "Dimension"](../table/348.md) |
| 15 | Dimension 3 Code | Code[20] | Specifies one of the four dimensions that you can include in an analysis view. | TableRelation [Table 348 "Dimension"](../table/348.md) |
| 17 | Include Budgets | Boolean | Specifies whether to include an update of analysis view budget entries, when updating an analysis view. |  |
| 18 | Refresh When Unblocked | Boolean | — |  |

## Keys

- Key1: Analysis Area, Code (clustered)

## Procedures

- `ItemAnalysisViewReset()`
- `CheckDimensionsAreRetained(ObjectType: Integer; ObjectID: Integer; OnlyIfIncludeBudgets: Boolean)`
- `CheckViewsAreUpdated()`
- `ValidateDelete(FieldName: Text)`
- `CopyAnalysisViewFilters(ObjectType: Integer; ObjectID: Integer; AnalysisArea: Integer; AnalysisViewCode: Code[10])`
- `SetUpdateOnPosting(NewUpdateOnPosting: Boolean)`

Plus 6 local procedures.

## Triggers

OnDelete

## Relations

- lookup page [Page 7151 "Item Analysis View List"](../page/7151.md)
- Location Filter: TableRelation [Table 14 "Location"](../table/14.md)
- Item Filter: TableRelation [Table 27 "Item"](../table/27.md)
- Dimension 1 Code: TableRelation [Table 348 "Dimension"](../table/348.md)
- Dimension 2 Code: TableRelation [Table 348 "Dimension"](../table/348.md)
- Dimension 3 Code: TableRelation [Table 348 "Dimension"](../table/348.md)

## Referenced by

6 fields in 6 objects relate to this table (TableRelation or CalcFormula).

- [Table 5821 "Item Statistics Buffer"](../table/5821.md): Analysis View Filter
- [Table 7112 "Analysis Line Template"](../table/7112.md): Item Analysis View Code
- [Table 7153 "Item Analysis View Filter"](../table/7153.md): Analysis View Code
- [Table 7154 "Item Analysis View Entry"](../table/7154.md): Analysis View Code
- [Table 7156 "Item Analysis View Budg. Entry"](../table/7156.md): Analysis View Code
- [Table 7159 "Analysis Selected Dimension"](../table/7159.md): Analysis View Code

## Pages and codeunits on this table

- [Page 7150 "Invt. Analysis View Card"](../page/7150.md) (source table)
- [Page 7151 "Item Analysis View List"](../page/7151.md) (source table)
- [Page 7155 "Sales Analysis View Card"](../page/7155.md) (source table)
- [Page 7156 "Purchase Analysis View Card"](../page/7156.md) (source table)
- [Page 9370 "Analysis View List Purchase"](../page/9370.md) (source table)
- [Page 9371 "Analysis View List Sales"](../page/9371.md) (source table)
- [Page 9372 "Analysis View List Inventory"](../page/9372.md) (source table)
- [Codeunit 7150 "Update Item Analysis View"](../codeunit/7150.md) (codeunit runs on it)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 7150 "Update Item Analysis View"](../codeunit/7150.md) (2 calls: `CheckViewsAreUpdated → Update`, `SetUpdateOnPosting → (object)`)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC28

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Item Analysis View")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.
