18.104.22.168.5 Cache Fields
A cache field represents an entity by which data can be summarized.
In this example, four cache fields exist in the PivotCache. Each cache field corresponds to one of the columns in the source data: Country, Product, Date, and Sales.
The sequence of records that conforms to the FDB rule (section 22.214.171.124), and optionally the SXADDLCACHEFIELD rule (section 126.96.36.199.3), specify a cache field. A cache field is contained in a PivotCache.
A cache field index is a zero-based index of an FDB rule in the PIVOTCACHE rule (section 188.8.131.52).
A cache field typically corresponds to a source data entity. However, grouping (section 184.108.40.206.7) cache fields and cache fields representing calculated fields (section 220.127.116.11.8) do not correspond to source data entities (section 18.104.22.168.2). Such cache fields are fully specified by information in the PivotCache.
The cfdbdb field of the SXDB record (section 2.4.275) specifies the number of cache fields that correspond to source data entities. If the cache field index of an SXFDB record (section 2.4.283) is less than cfdbdb, the cache field corresponds to a source data entity. Otherwise, the cache field does not correspond to a source data entity. A non- OLAP PivotCache (section 22.214.171.124.4) MUST have one or more cache fields corresponding to source data columns. An OLAP PivotCache MUST NOT have cache fields that do not correspond to source data entities.
In a non- OLAP PivotCache, a cache field typically corresponds to one column in the source data and contains information about that column. The cache field name is specified by the stFieldName field of the SXFDB record. The cache field name of a cache field corresponding to a source data column is derived from the name of that column in the source data and is used to associate the cache field with that source data column.
All cache field names MUST be unique, when using a case-insensitive comparison, within the associated PivotCache.