Page 554 "Analysis by Dimensions"
Base Application · Microsoft.Finance.Analysis
Across versions
- BC23-30present
Neighbourhood 5 connected objects and pages
Base Application · Microsoft.Finance.Analysis · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Analysis by Dimensions |
| SourceTable | Analysis by Dim. Parameters |
| PageType | Card |
Fields on this page
Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).
| Group | Control | Shows | ToolTip |
|---|---|---|---|
| General | Analysis View Code | Analysis View Code | Specifies the code for the analysis view that the filter belongs to. from the table field |
| Show as Lines | LineDimCode |
Specifies which values you want to show as lines in the window. This allows you to see the same matrix window from various perspectives, especially when you use both the Show as Lines field and the Show as Columns field. | |
| Show as Columns | ColumnDimCode |
Specifies which values you want to show as columns in the window. This allows you to see the same matrix window from various perspectives, especially when you use both the Show as Lines field and the Show as Columns field. | |
| Filters | Date Filter | Date Filter | Specifies the dates that will be used to filter the amounts in the window. from the table field |
| Account Filter | Account Filter | Specifies a filter for the general ledger accounts for which entries will be shown in the matrix window. from the table field | |
| BusUnitFilter | Bus. Unit Filter | — | |
| Cash Flow Forecast Filter | Cash Flow Forecast Filter | Specifies the cash flow forecast that information in the matrix is shown for. from the table field | |
| Budget Filter | Budget Filter | Specifies the budget that information in the matrix is shown for. from the table field | |
| Dimension 1 Filter | Dimension 1 Filter | Specifies a filter for the Dimension 1 for which entries will be shown in the matrix window. from the table field | |
| Dimension 2 Filter | Dimension 2 Filter | Specifies a filter for the Dimension 2 for which entries will be shown in the matrix window. from the table field | |
| Dimension 3 Filter | Dimension 3 Filter | Specifies a filter for the Dimension 3 for which entries will be shown in the matrix window. from the table field | |
| Dimension 4 Filter | Dimension 4 Filter | Specifies a filter for the Dimension 4 for which entries will be shown in the matrix window. from the table field | |
| Options | ShowActualBudg | Show Actual/Budgets | Specifies if the selected value is shown in the window. from the table field |
| Show Amount Field | 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. from the table field | |
| ClosingEntryFilter | Closing Entries | Specifies whether the amounts shown in the matrix window will include closing entries. | |
| RoundingFactor | Rounding Factor | Specifies the factor that is used to round the amounts. from the table field | |
| ShowInAddCurr | Show In Add. Currency | Specifies if the reported amounts are shown in the additional reporting currency. | |
| ShowColumnName | Show Column Name | Specifies that the names of columns are shown in the matrix window. from the table field | |
| ShowOppositeSign | Show Opposite Sign | Specifies whether to show debits as negative amounts (with minus signs) and credits as positive amounts in the matrix window. from the table field | |
| Matrix Options | PeriodType | Period Type | Specifies by which period amounts are displayed. from the table field |
| ColumnsSet | Column Set | 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. from the table field | |
| QtyType | 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. from the table field |
Actions
| Group | Action | ToolTip | Runs |
|---|---|---|---|
| Actions | Reverse Lines and Columns | Change the display of the matrix by inverting the values in the Show as Lines and Show as Columns fields. | |
| Processing | Show Matrix | View the data overview according to the selected filters and options. | |
| Previous Set | Go to the previous set of data. | ||
| Next Set | Go to the next set of data. |
Events published
OnAfterFindRecord(var DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; var AnalysisView: Record "Analysis View"; Which: Text[250]; var Found: Boolean; var AnalysisByDimParameters: Record "Analysis by Dim. Parameters")(integration): Integration event raised after finding dimension records for matrix display. Enables customization of dimension record processing and buffer population logic.- subscribers: Codeunit 2621 “Stat. Acc. Analysis View Mgt.” HandleOnAfterFindRecord
OnAfterGetCaptionClass(AnalysisViewDimType: Integer; var AnalysisView: Record "Analysis View"; var ReturnValue: Text[250])(integration): Integration event raised after generating caption class for dimension filters. Enables customization of caption class formatting for dimension filter fields.OnAfterNextRecord(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; var AnalysisView: Record "Analysis View"; Steps: Integer; var ResultSteps: Integer)(integration): Integration event raised after navigating through dimension records in matrix. Enables customization of dimension navigation and result processing logic.OnBeforeOpenPage(var AnalysisByDimParameters: Record "Analysis by Dim. Parameters")(integration): Integration event raised before page opens for analysis by dimensions initialization. Enables customization of analysis parameters before page display.OnBeforeDimCodeToDimOption(DimCode: Text[30]; var AnalysisView: Record "Analysis View"; var Result: Enum "Analysis Dimension Option"; var IsHandled: Boolean)(integration): Integration event raised before converting dimension code to dimension option enum. Enables custom dimension code mapping for extended analysis view types.OnBeforeNextRecord(DimOption: Enum "Analysis Dimension Option"; var DimensionValue: Record "Dimension Value")(integration): Integration event for custom dimension navigation logic in analysis by dimensions.OnBeforeFindRecord(DimOption: Enum "Analysis Dimension Option"; var DimensionValue: Record "Dimension Value")(integration): Integration event for custom dimension record finding logic in analysis by dimensions.OnBeforeValidateColumnDimCode(var GLAccountSource: Boolean; var ColumnDimCode: Text[30]; var InternalDateFilter: Text; var IsHandled: Boolean; var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var AnalysisView: Record "Analysis View"; var AnalysisViewEntry: Record "Analysis View Entry"; var PeriodInitialized: Boolean)(integration): Integration event for custom validation logic when column dimension code is changed.OnBeforeValidateLineDimCode(var GLAccountSource: Boolean; var LineDimCode: Text[30]; var InternalDateFilter: Text; var IsHandled: Boolean; var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var AnalysisView: Record "Analysis View"; var AnalysisViewEntry: Record "Analysis View Entry")(integration): Integration event for custom validation logic when line dimension code is changed.OnGetDimSelectionOnBeforeDimSelectionLookup(var AnalysisView: Record "Analysis View"; var DimSelection: Page "Dimension Selection")(integration): Integration event for customizing dimension selection lookup before opening the page.OnValidateAnalysisViewCodeOnAfterRecSetFilters(var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var AnalysisView: Record "Analysis View")(integration): Integration event for custom logic after setting analysis view filters on record.OnGetCaptions(var AnalysisView: Record "Analysis View"; var LineDimCode: Text[30]; var AccountCaption: Text[30]; var UnitCaption: Text[30]; OpenPage: Boolean)(integration): Integration event for customizing captions in analysis by dimensions display.- subscribers: Codeunit 2621 “Stat. Acc. Analysis View Mgt.” HandleOnGetAnalysisByDimensionsCaptions
OnGetAnalysisViewDimensionOption(var AnalysisView: Record "Analysis View"; var Result: enum "Analysis Dimension Option"; DimCode: Text[30])(integration): Integration event for determining analysis view dimension option from dimension code.- subscribers: Codeunit 2621 “Stat. Acc. Analysis View Mgt.” HandleOnGetAnalysisViewDimensionOption
OnLookupAccountFilterOnAccountSourceElseCase(var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; AnalysisView: Record "Analysis View")(integration): Integration event for custom account filter lookup when account source is not standard.OnOpenPageOnGetBusUnitFilterCaptionElseCase(var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; AnalysisView: Record "Analysis View"; var BusUnitFilterCaption: Text[80])(integration): Integration event for customizing business unit filter caption when account source is not standard.OnFindPeriodOnAfterSetInternalDateFilter(PeriodType: Enum "Analysis Period Type"; var DateFilter: Text)(integration): Integration event for customizing date filter after period finding logic.
Procedures
DimCodeToDimOption(DimCode: Text[30]): Enum "Analysis Dimension Option": Converts dimension code text to corresponding Analysis Dimension Option enum value. Maps dimension codes to appropriate enum values for matrix row and column configuration.FindRecord(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; Which: Text[250]): Boolean: Finds records based on dimension option and populates dimension code buffer for matrix display. Handles navigation through G/L accounts, periods, business units, cash flow, and dimension values.NextRecord(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; Steps: Integer): Integer: Navigates to next/previous records in dimension data for matrix column generation. Advances through dimension values by specified number of steps for pagination.GetCaptionClass(AnalysisViewDimType: Integer): Text[250]: Generates caption class string for dimension filter fields based on analysis view configuration. Provides dynamic captions for dimension 1-4 filters using actual dimension codes from analysis view.CreateCaptionSet(RecRef: Record "Dimension Code Buffer"; Step: Option First,Previous,Same,Next; MaximumNoOfCaptions: Integer; var PrimaryKeyFirstCaptionInCurrSe: Text[1024]; var CaptionSet: array[32] of Text[1024]; var CaptionRange: Text[1024])(protected)SetAnalysisViewCode(NextAnalysisViewCode: Code[10]): Sets the analysis view code for the page and initializes the record for analysis configuration. Prepares the temporary record with the specified analysis view for dimension analysis setup.
Plus 13 local procedures.
Triggers
OnFindRecord, OnInit, OnOpenPage, OnQueryClosePage
Relations
- source table Table 361 “Analysis by Dim. Parameters”
Extended by
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 362 “PeriodPageManagement” (3 calls:
FindPeriod → FindDate,FindRecord → FindDate,NextRecord → NextDate)
Called by
- Table 363 “Analysis View” (1 call:
RunAnalysisByDimensionPage → (object))
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: "page", object_name: "Analysis by Dimensions"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.