How Siebel CRM Creates a Chart Applet

Siebel CRM builds a chart as an applet that contains one or more Chart object definitions. A Chart is a child of an applet. The Business Component property of a chart applet identifies the business component that provides data that Siebel CRM displays in a chart applet. Records in this business component are subject to the current view, the current query, and visibility requirements. Business component fields provide the data for the category, data point, and series axes in a chart applet. The properties of the chart object define the relationship between axes and fields. Siebel CRM also supports the building of charts based on Virtual Business Components (VBC). This allows charts to be built using data from external data sources.

A single bar or line graph is the simplest form of chart applet. It contains no series axis and only a category field and a data point field are defined. Siebel CRM plots pairs of category and data point field values as points or bars. If multiple records use the same category value, then Siebel CRM adds together their data point values.

The following figure shows opportunities on the data point axis that Siebel CRM plots against the source of the opportunity on the category axis. Example sources include referral, magazine article, web site, and so on. To create the data required for the line, Siebel CRM checks the Source field in each record and tallies the number of opportunities for each distinct source value.

Oppty Chart Applet - Source Analysis: This image is described in the surrounding text.

The following table and figure shows the result, which is a two row temporary table that includes a column for each source.

Mailer	Seminar eMail	Unspecified
1	21	4

Temporary Table for Single Line Chart Data: This image is described in the surrounding text.

The following figure includes a multiple line chart where Siebel CRM adds a row to the temporary table for each line in the series.

Example of a Multiple Line Chart: This image is described in the surrounding text.

The following table and figure shows the temporary table for a multiple line chart.

<Empty>	Network Card	Monitor	Pentium 300	Pentium 400	Pentium 500
Critical	2	0	0	0	0
High	2	0	0	0	0
Medium	0	1	0	0	0
Low	0	0	0	0	0
Question	0	0	1	1	1
Unspecified	0	0	1	0	0

Example of a Temporary Table for Multiple Line Chart Data: This image is described in the surrounding text.