Skip to main content

Reports & Analytics - Key Tables

Full column listings for the 2 key tables in this category.

ANALYZERPROFILE (99 columns)

# Column Type Length Nullable Default
1 APid int NO
2 APTitle nvarchar 4000 YES
3 APSQL ntext 1073741823 YES
4 APEmailsubject ntext 1073741823 YES
5 APEmailBody ntext 1073741823 YES
6 APEmailto ntext 1073741823 YES
7 APEmailcc ntext 1073741823 YES
8 APReportingPeriod int YES ((0))
9 APAvailableFields ntext 1073741823 YES
10 APSelectedFields ntext 1073741823 YES
11 APReportingPeriodstartdate datetime YES
12 APReportingPeriodenddate datetime YES
13 APReportingPeriodDateField nvarchar 4000 YES
14 APSQLID int YES ((-1))
15 APrestrictaccess bit NO ((0))
16 APGroupID int YES ((1))
17 APChartTitle nvarchar 4000 YES
18 APXAxis nvarchar 4000 YES
19 APYAxis nvarchar 4000 YES
20 APXAxisCaption nvarchar 4000 YES
21 APYAxisCaption nvarchar 4000 YES
22 APGraphOrderBy nvarchar 4000 YES
23 APChartType int YES ((-1))
24 APGraphOrder int YES ((-1))
25 APCount bit YES ((0))
26 APSum bit YES ((0))
27 APShowGraphValues bit YES ((0))
28 APClient nvarchar 4000 YES ('')
29 APDesc nvarchar 4000 YES ('')
30 apbuiltinid bit YES ((1))
31 apseriestype1 int YES ((-1))
32 apseriestype2 int YES ((-1))
33 apseriestype3 int YES ((-1))
34 apseriestype4 int YES ((-1))
35 apseriestype5 int YES ((-1))
36 apyaxis1 nvarchar 4000 YES ('')
37 apyaxis2 nvarchar 4000 YES ('')
38 apyaxis3 nvarchar 4000 YES ('')
39 apyaxis4 nvarchar 4000 YES ('')
40 apyaxis5 nvarchar 4000 YES ('')
41 apstackbars bit YES ((0))
42 apsystemreportid int YES ((0))
43 APIncludeSummary bit YES ((0))
44 APTimezoneName nvarchar 4000 YES ('')
45 APOnlyShowSummaries bit YES ((0))
46 APUseTechLink bit YES ((0))
47 APpublishedID nvarchar 255 YES ('')
48 APDisplayTitle nvarchar 500 YES ('')
49 APPdfTemplateId int YES ((0))
50 APGUID uniqueidentifier YES (newid())
51 APtype int YES ((0))
52 APdataSourceId int YES ((0))
53 APCanBeAccessedByAllUsers bit YES ((0))
54 APreportTableHTML nvarchar -1 YES
55 APreportTableRowHTML nvarchar -1 YES
56 APreportTableGroupHTML nvarchar -1 YES
57 APreportTableTotalHTML nvarchar -1 YES
58 apcolourpallette nvarchar 4000 YES ('')
59 apapiqueryid int YES
60 apshowtoponly bit YES
61 aptopcount int YES
62 apshowtrendline bit YES ((0))
63 apshowdatavalues bit YES ((0))
64 APmainEntity nvarchar 50 YES ('')
65 apreportcomparison int YES ((0))
66 apchartcomparison int YES ((0))
67 apaiprompt nvarchar -1 YES
68 apaithreadid nvarchar 255 YES
69 apairunid nvarchar 255 YES
70 apaverage bit YES ((0))
71 apaverageaspercentage bit YES ((0))
72 appublishtype int YES ((0))
73 apapplyquerybuilderperms bit YES
74 aplastrundate datetime YES ((0))
75 apformatvaluesascurrency bit YES
76 apcurrencysymbol nvarchar 10 YES
77 apreportingperioddateonly bit YES
78 apaianalysis nvarchar -1 YES
79 apaiuserprompt nvarchar 4000 YES
80 apaianalysisgenerationdatetime datetime YES ((0))
81 aponlineid int YES
82 aponlinedatasourceid int YES
83 aplabeldisplaytype int YES
84 apguidehtml nvarchar 4000 YES ('')
85 APsplitBarsByField nvarchar 255 YES
86 APsplitBarsByFieldAllowChange bit YES
87 APclientPageSize int YES ((10000))
88 APforecastId int YES
89 APshowForecastTable bit YES
90 APshowForecastChart bit YES
91 APchartCarryForward bit YES
92 APreportTableAutosizeWidth bit YES
93 APchartPadding int YES
94 APdataLabelMin float YES
95 aprunaianalysisbeforeschedule bit YES
96 apcreatedby int YES
97 aplastupdatedby int YES
98 apdatecreated datetime YES ((0))
99 aplastupdated datetime YES ((0))

Widget (69 columns)

# Column Type Length Nullable Default
1 Wid int NO
2 WdashboardId int YES
3 Wseq int YES
4 Wwidth int YES
5 Wheight int YES
6 Wx int YES
7 Wy int YES
8 Wtitle nvarchar 255 YES
9 Wtype int YES
10 WreportId int YES
11 WcounterType int YES
12 WcolumnName nvarchar 255 YES
13 WcustomHtml nvarchar -1 YES
14 WcustomCss nvarchar 4000 YES
15 wthresholdvalue float YES
16 wcolourchangerule int YES
17 wchangedcolour nvarchar 10 YES
18 winitialcolour nvarchar 10 YES
19 WTicketAreaId int YES
20 WViewType nvarchar 20 YES
21 WFilterId int YES
22 WTreeId int YES
23 WTreeId2 int YES
24 WPageSize int YES
25 WColumnsId int YES
26 woverridedrilldownid int YES ((-1))
27 wcountformattype int YES ((0))
28 Wrelation int YES ((0))
29 Wstyle int YES ((0))
30 Wfieldid int YES
31 Wtoutcomeid int YES ((0))
32 Wmode nvarchar 10 YES ('')
33 wopenreportinnewtab bit YES ((0))
34 wtfieldcolumns int YES ((1))
35 Wdisplaytype int YES ((0))
36 wcharttype int YES
37 wxaxis nvarchar 4000 YES
38 wxaxiscaption nvarchar 4000 YES
39 wyaxis nvarchar 4000 YES
40 wyaxiscaption nvarchar 4000 YES
41 wgraphorderby nvarchar 4000 YES
42 wgraphorder int YES
43 wcount bit YES
44 wsum bit YES
45 waverage bit YES
46 waverageaspercentage bit YES
47 wshowtoponly bit YES
48 wtopcount int YES
49 wshowtrendline bit YES
50 wshowdatavalues bit YES
51 wstackbars bit YES
52 wcolourpallette nvarchar 4000 YES
53 wchartcomparison int YES
54 wautosize bit YES
55 wformatvaluesascurrency bit YES
56 wcurrencysymbol nvarchar 10 YES
57 wcurrencyoverride bit YES ((0))
58 wcurrencysymboloverride nvarchar 10 YES
59 wtrailingzeroes int YES
60 Wdatefilterfieldname nvarchar 250 YES
61 WsplitBarsByField nvarchar 255 YES
62 WchartCarryForward bit YES
63 wmultiseriestype int YES
64 wdarkinitialcolour nvarchar 10 YES ('')
65 wdarkchangedcolour nvarchar 10 YES ('')
66 WchartPadding int YES
67 WdataLabelMin float YES
68 wguid uniqueidentifier NO (newid())
69 wrefreshrate int YES ((120))
Back to top