2.2.5.3.2.1 Multiple Consolidation Ranges
A multiple consolidation ranges PivotCache (section 2.2.5.3) is used for summarizing multiple ranges that contain source data in cross-tab format. A multiple consolidation ranges PivotCache is a collection of ranges and page information that is specified by the sequence of records that conforms to the SXTBL rule (section 2.1.7.20.3). Each range is specified by one of the DConName (section 2.4.85), DConBin (section 2.4.83), or DConRef (section 2.4.86) records.
The following figure shows an example of a range in cross-tab format. The first column of the range contains names of sales people ("George" and "Allan"). The first row in the range contains product groups ("Cars" and "Bikes"). The remaining cells in the range contain numeric values representing how many products in a certain product group were sold by each sales person.
Figure 3: Example of a range in cross-tab format
A multiple consolidation ranges PivotCache is used to summarize multiple cross-tab ranges as shown in the following figure, which shows eight cross-tab ranges.
Figure 4: Example of eight ranges in cross-tab format
The values in the first column of each range are used to create a cache field (section 2.2.5.3.5) with a default name specified by the application. Each cache item (section 2.2.5.3.6) of this cache field corresponds to one of the values in the first column of the range, eliminating duplicates. This cache field is the first cache field in the collection of sequences of records that conform to the FDB rule (section 2.1.7.12) in the sequence of records that conforms to the PIVOTCACHE rule.
The values in the first row of each range are used to create a cache field with a default name specified by the application. Each cache item of this cache field corresponds to one of the values in the first row of the range, eliminating duplicates. This cache field is the second cache field in the collection of FDB rules (section 2.1.7.12) in the PIVOTCACHE rule (section 2.1.7.12).
The values in all other cells of each range are used to create a cache field with a default name specified by the application. Each cache item of this cache field corresponds to one of the values in the other cells of the range, eliminating duplicates. This cache field is the third cache field in the collection of FDB rules in PIVOTCACHE rule.
A PivotTable view (section 2.2.5.4) associated with the multiple consolidation ranges PivotCache is added on creation. The pivot fields (section 2.2.5.4.3) corresponding to the cache fields described previously are added to the row axis (section 2.2.5.4.9.2), column axis (section 2.2.5.4.9.3), and data axis (section 2.2.5.4.9.5), respectively.
Up to four additional cache fields can optionally exist with default names specified by the application. The corresponding pivot fields are added to the page axis (section 2.2.5.4.9.1) of the PivotTable view on creation, enabling the user to summarize data from all or a subset of the ranges. The ranges to be summarized in the PivotTable (section 2.2.5) are selected by adding a manual filter (section 2.2.5.4.7) to one or more of these pivot fields on the page axis. The number of optional cache fields created is user-defined and is equal to the cPages field of the SXTbl record (section 2.4.305). Each optional cache field corresponds to an SXTBRGIITM record.
The first SXTBRGIITM record (section 2.4.307) in the SXTBL collection (section 2.1.7.20.3) corresponds to the fourth cache field in the collection of FDB rules. Each cache item of this cache field corresponds to the SXString record (section 2.4.304) in the collection of SXString records directly following this SXTBRGIITM record.
The second SXTBRGIITM record in the SXTBL collection corresponds to the fifth cache field in the collection of FDB rules. Each cache item of this cache field corresponds to the SXString record in the collection of SXString records directly following this SXTBRGIITM record.
The third SXTBRGIITM record in the SXTBL collection corresponds to the sixth cache field in the collection of FDB rules. Each cache item of this cache field corresponds to the SXString record in the collection of SXString records directly following this SXTBRGIITM record.
The fourth SXTBRGIITM record in the SXTBL collection corresponds to the seventh cache field in the collection of FDB rules. Each cache item of this cache field corresponds to the SXString record in the collection of SXString records directly following this SXTBRGIITM record.
The following figure shows a multiple consolidation ranges PivotTable report (section 2.2.5) with two pivot fields on the page axis. The PivotTable report is based on the eight ranges in the figure titled Example of eight ranges in cross-tab format and summarizes the values from all the ranges because no manual filter (section 2.2.5.4.7) has been applied to any of the pivot fields on the page axis.
Figure 5: Multiple consolidation ranges PivotTable
The rgiitem field of the SxTbpg record (section 2.4.306) specifies the relationship between each range and the SXString records that follow each SXTBRGIITM record.