Table 770 "Analysis Report Chart Setup"

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

Properties

Property	Value
Caption	Analysis Report Chart Setup
DataClassification	CustomerContent

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	User ID Δ BC28	Text[132]	Specifies the ID of the user who posted the entry, to be used, for example, in the change log.	not editable; DataClassification EndUserIdentifiableInformation
2	Name Δ BC28	Text[30]	Specifies the name of the specific chart.
10	Analysis Area Δ BC28	Enum “Analysis Area Type”	Specifies if the analysis report chart shows values for sales, purchase, or inventory.	enum Enum 7130 “Analysis Area Type”; not editable
20	Analysis Report Name Δ BC28	Code[10]	Specifies the name of the analysis report that is used to generate the specific chart that is shown in, for example, the Sales Performance window.	TableRelation Table 7111 “Analysis Report Name” (“Analysis Report Name”.Name where(“Analysis Area” = field(“Analysis Area”)))
21	Analysis Line Template Name Δ BC28	Code[10]	Specifies the name of the analysis line template that is used to generate the specific chart that is shown in, for example, the Sales Performance window.	TableRelation Table 7111 “Analysis Report Name” (“Analysis Report Name”.“Analysis Line Template Name” where(“Analysis Area” = field(“Analysis Area”), Name = field(“Analysis Report Name”))); not editable
22	Analysis Column Template Name Δ BC28	Code[10]	Specifies the name of the analysis column template that is used to generate the chart that is shown in, for example, the Sales Performance window.	TableRelation Table 7111 “Analysis Report Name” (“Analysis Report Name”.“Analysis Column Template Name” where(“Analysis Area” = field(“Analysis Area”), Name = field(“Analysis Report Name”))); not editable
30	Base X-Axis on Δ BC28	Option	Specifies how the values from the selected analysis report are displayed in the specific chart.	OptionCaption: Period,Line,Column
31	Start Date Δ BC28	Date	Specifies the first date on which analysis report values are included in the chart.
32	End Date Δ BC28	Date	Specifies the last date on which analysis report values are included in the chart.
41	Period Length Δ BC28	Option	Specifies the length of periods in the chart.	OptionCaption: Day,Week,Month,Quarter,Year
42	No. of Periods Δ BC28	Integer	Specifies how many periods are shown in the chart.
50	Last Viewed	Boolean	—	not editable

Keys

Key1: User ID, Analysis Area, Name (clustered)

Procedures

SetAnalysisReportName(ReportName: Code[10])
SetShowPer(ShowPer: Option)
SetPeriodLength(PeriodLength: Option)
SetLastViewed()
SetLinkToLines(var AnalysisReportChartLine: Record "Analysis Report Chart Line")
SetLinkToMeasureLines(var AnalysisReportChartLine: Record "Analysis Report Chart Line")
SetLinkToDimensionLines(var AnalysisReportChartLine: Record "Analysis Report Chart Line")
RefreshLines(Force: Boolean)
FilterAnalysisLine(var AnalysisLine: Record "Analysis Line")
FilterAnalysisColumn(var AnalysisColumn: Record "Analysis Column")
SetMeasureChartTypesToDefault(var AnalysisReportChartLine: Record "Analysis Report Chart Line")
SetDimensionChartTypesToDefault(var AnalysisReportChartLine: Record "Analysis Report Chart Line")

Plus 4 local procedures.

Triggers

OnDelete

Relations

lookup page Page 779 “Analysis Report Chart List”
Analysis Column Template Name: TableRelation Table 7111 “Analysis Report Name”
Analysis Line Template Name: TableRelation Table 7111 “Analysis Report Name”
Analysis Report Name: TableRelation Table 7111 “Analysis Report Name”

Referenced by

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

Table 771 “Analysis Report Chart Line”: Analysis Area, Analysis Column Template Name, Analysis Line Template Name, Name, User ID

Pages and codeunits on this table

Page 775 “Analysis Report Chart Setup” (source table)
Page 779 “Analysis Report Chart List” (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 Report Chart Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.