--- id: object/table/361 type: object title: Table 361 "Analysis by Dim. Parameters" summary: Table 361 "Analysis by Dim. Parameters" in Base Application (Microsoft.Finance.Analysis). 23 fields, 1 public procedures. Present since at least BC23, still in BC30, changed in BC29. tier: official language: en tags: - table - base application versions: introduced: null last_changed: "29" 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: 0e67d487283004e3b2d91a9d3b05026f02c392414c4ca3fbc6cdb50bf5097433 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/Analysis/AnalysisByDimParameters.Table.al title: src/Layers/W1/BaseApp/Finance/Analysis/AnalysisByDimParameters.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: - https://learn.microsoft.com/dynamics365/business-central/finance-dimensions objects: [] features: [] topics: - topic/business-central/business-functionality/finance/working-with-dimensions localizations: [] videos: [] posts: [] guidelines: [] object_type: table object_id: 361 name: Analysis by Dim. Parameters namespace: Microsoft.Finance.Analysis app: Base Application extends: null first_version: "23" last_version: "30" present_in: - "23" - "24" - "25" - "26" - "27" - "28" - "29" - "30" changed_in: - "29" source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 23 procedures: 1 events: 0 subscribers: 0 relations: out: 1 referenced_by: 0 pages: 2 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 361 "Analysis by Dim. Parameters" > Table 361 "Analysis by Dim. Parameters" in Base Application (Microsoft.Finance.Analysis). 23 fields, 1 public procedures. Present since at least BC23, still in BC30, changed in BC29. Base Application · Microsoft.Finance.Analysis · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/Analysis/AnalysisByDimParameters.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 408 "G/L Balance by Dimension"](../page/408.md) (1 Learn page). ## Properties | Property | Value | |---|---| | DataClassification | SystemMetadata | ## 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 View Code | Code[10] | Specifies the code for the analysis view that the filter belongs to. | TableRelation [Table 363 "Analysis View"](../table/363.md) (Analysis View) | | 3 | Line Dim Option | Enum "Analysis Dimension Option" | — | enum [Enum 727 "Analysis Dimension Option"](../enum/727.md) | | 4 | Column Dim Option | Enum "Analysis Dimension Option" | — | enum [Enum 727 "Analysis Dimension Option"](../enum/727.md) | | 5 | Date Filter | Text[250] | Specifies the dates that will be used to filter the amounts in the window. | | | 6 | Account Filter | Text[250] | Specifies a filter for the general ledger accounts for which entries will be shown in the matrix window. | | | 7 | Bus. Unit Filter | Text[250] | Business Unit Filter caption | | | 8 | Cash Flow Forecast Filter | Text[250] | Specifies the cash flow forecast that information in the matrix is shown for. | | | 9 | Budget Filter | Text[250] | Specifies the budget that information in the matrix is shown for. | | | 10 | Dimension 1 Filter | Text[250] | Specifies a filter for the Dimension 1 for which entries will be shown in the matrix window. | | | 11 | Dimension 2 Filter | Text[250] | Specifies a filter for the Dimension 2 for which entries will be shown in the matrix window. | | | 12 | Dimension 3 Filter | Text[250] | Specifies a filter for the Dimension 3 for which entries will be shown in the matrix window. | | | 13 | Dimension 4 Filter | Text[250] | Specifies a filter for the Dimension 4 for which entries will be shown in the matrix window. | | | 20 | Show Actual/Budgets | Enum "Analysis Show Amount Type" | Specifies if the selected value is shown in the window. | enum [Enum 747 "Analysis Show Amount Type"](../enum/747.md) | | 21 | Show Amount Field | Enum "Analysis Show Amount Field" | Specifies the type of entries that will be included in the matrix window. The Amount options means that amounts that are the sum of debit and credit amounts are shown. | enum [Enum 748 "Analysis Show Amount Field"](../enum/748.md) | | 22 | Closing Entries | Option | Specifies whether the balance shown will include closing entries. If you want to see the amounts on income statement accounts in closed years, you must exclude closing entries. | OptionCaption: Include,Exclude | | 23 | Rounding Factor | Enum "Analysis Rounding Factor" | Specifies the factor that is used to round the amounts. | enum [Enum 364 "Analysis Rounding Factor"](../enum/364.md) | | 24 | Show In Add. Currency | Boolean | Specifies whether to show the reported amounts in the additional reporting currency. | | | 25 | Show Column Name | Boolean | Specifies that the names of columns are shown in the matrix window. | | | 26 | Show Opposite Sign | Boolean | Specifies whether to show debits as negative amounts (with minus signs) and credits as positive amounts in the matrix window. | | | 30 | Period Type | Enum "Analysis Period Type" | Specifies by which period amounts are displayed. | enum [Enum 362 "Analysis Period Type"](../enum/362.md) | | 31 | Column Set | Text[250] | Specifies the range of values that are displayed in the matrix window, for example, the total period. To change the contents of the field, choose Next Set or Previous Set. | | | 33 | Amount Type | Enum "Analysis Amount Type" | Specifies how amounts are displayed. Net Change: The net change in the balance for the selected period. Balance at Date: The balance as of the last day in the selected period. | enum [Enum 363 "Analysis Amount Type"](../enum/363.md) | | 34 | Analysis Account Source | Enum "Analysis Account Source" | — | enum [Enum 7133 "Analysis Account Source"](../enum/7133.md) | ## Keys - Key 1: Analysis View Code (clustered) ## Procedures - `GetRangeMinDateFilter(): Date`: Gets the minimum date from the date filter expression for period boundary calculations. Provides the starting date for analysis range validation and period setup. ## Triggers OnInsert, OnModify, OnDelete, OnRename ## Relations - Analysis View Code: TableRelation [Table 363 "Analysis View"](../table/363.md) ## Pages and codeunits on this table - [Page 408 "G/L Balance by Dimension"](../page/408.md) (source table) - [Page 554 "Analysis by Dimensions"](../page/554.md) (source table) ## Across versions - Present in: BC23-30 - Changed (declaration) in: BC29 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). 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: "Analysis by Dim. Parameters")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.