Table 361 "Analysis by Dim. Parameters"

Base Application · Microsoft.Finance.Analysis · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 408 “G/L Balance by Dimension” (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 Δ BC29	Code[10]	Specifies the code for the analysis view that the filter belongs to.	TableRelation Table 363 “Analysis View” (Analysis View)
3	Line Dim Option	Enum “Analysis Dimension Option”	—	enum Enum 727 “Analysis Dimension Option”
4	Column Dim Option	Enum “Analysis Dimension Option”	—	enum Enum 727 “Analysis Dimension Option”
5	Date Filter Δ BC29	Text[250]	Specifies the dates that will be used to filter the amounts in the window.
6	Account Filter Δ BC29	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 Δ BC29	Text[250]	Specifies the cash flow forecast that information in the matrix is shown for.
9	Budget Filter Δ BC29	Text[250]	Specifies the budget that information in the matrix is shown for.
10	Dimension 1 Filter Δ BC29	Text[250]	Specifies a filter for the Dimension 1 for which entries will be shown in the matrix window.
11	Dimension 2 Filter Δ BC29	Text[250]	Specifies a filter for the Dimension 2 for which entries will be shown in the matrix window.
12	Dimension 3 Filter Δ BC29	Text[250]	Specifies a filter for the Dimension 3 for which entries will be shown in the matrix window.
13	Dimension 4 Filter Δ BC29	Text[250]	Specifies a filter for the Dimension 4 for which entries will be shown in the matrix window.
20	Show Actual/Budgets Δ BC29	Enum “Analysis Show Amount Type”	Specifies if the selected value is shown in the window.	enum Enum 747 “Analysis Show Amount Type”
21	Show Amount Field Δ BC29	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”
22	Closing Entries Δ BC29	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 Δ BC29	Enum “Analysis Rounding Factor”	Specifies the factor that is used to round the amounts.	enum Enum 364 “Analysis Rounding Factor”
24	Show In Add. Currency Δ BC29	Boolean	Specifies whether to show the reported amounts in the additional reporting currency.
25	Show Column Name Δ BC29	Boolean	Specifies that the names of columns are shown in the matrix window.
26	Show Opposite Sign Δ BC29	Boolean	Specifies whether to show debits as negative amounts (with minus signs) and credits as positive amounts in the matrix window.
30	Period Type Δ BC29	Enum “Analysis Period Type”	Specifies by which period amounts are displayed.	enum Enum 362 “Analysis Period Type”
31	Column Set Δ BC29	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 Δ BC29	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”
34	Analysis Account Source	Enum “Analysis Account Source”	—	enum Enum 7133 “Analysis Account Source”

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”

Pages and codeunits on this table

Page 408 “G/L Balance by Dimension” (source table)
Page 554 “Analysis by Dimensions” (source table)

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.