Share via

2.2.5.3.10 PivotTable What-if Analysis

  • Article

PivotTable What-if Analysis enables the editing of summarized values in an OLAP PivotTable view (section 2.2.5.3), for example, editing summarized values in the data area (section 2.2.5.3.8.1.4) of the PivotTable view.

The sequence of records that conform to the SXEDITS rule (defined in section 2.1.7.40) specifies the values in the OLAP PivotTable view that have been modified and specifies the corresponding values in the OLAP source data (section 2.2.5.2.1). The sequence of records that conform to the SXEDIT rule (defined in section 2.1.7.40) specifies a value or a formula. A value is specified by the Xnum (section 2.5.172) field of a BrtBeginSXEdit (section 2.4.245) record and MUST exist if and only if the sxet field of the BrtBeginSXEdit record is equal to SXET_NUM (section 2.5.147). A formula is specified by the FRTHeader field of the BrtBeginSXEdit record. The location of the modified value in the OLAP PivotTable view is specified by the PivotTable rule (section 2.2.5.3.9) that immediately follows the BrtBeginSXEdit record. The OLAP tuple that identifies the corresponding value in the OLAP source data is specified by the rgStTuple field of the BrtSXTupleItems (section 2.4.821) record that immediate follows the BrtBeginSXEdit record.

The sequence of records that conforms to the SXCHANGES rule (defined in section 2.1.7.40) specifies the values in the OLAP PivotTable view that have been designated for OLAP allocation and specifies the corresponding values in the OLAP source data. The order of the BrtBeginSXChange (section 2.4.235) records determines the order in which they are designated for OLAP allocation. The sequence of records that conforms to the SXCHANGE rule (defined in section 2.1.7.40) specifies a single edited value designated for OLAP allocation. An OLAP allocation value is specified by the xnum field of a BrtBeginSXChange record. The OLAP tuple that identifies the location of the edited value in the OLAP PivotTable view and the corresponding value in the OLAP source data is specified by the rgStTuple field of a BrtSXTupleItems record that immediately follows the BrtBeginSXChange record. The sxma field of the BrtBeginSXChange record specifies the OLAP allocation method.

For example, when an OLAP PivotTable is refreshed, the values designated for OLAP allocation (SXCHANGES) are sent to the OLAP source data (section 2.2.5.2.1) provider along with the OLAP allocation method indicating how to allocate the updated values. The OLAP source data provider updates the values, and those new values are then refreshed and summarized in the data area (section 2.2.5.3.8.1.4) of the PivotTable view (section 2.2.5.3) instead of summarizing the original values from the OLAP source data.

If the fEnableWB field of the BrtBeginSXView14 (section 2.4.276) is 0x0, SXEDITS (section 2.1.7.40) and SXCHANGES (section 2.1.7.40) MUST NOT exist in the part. PivotTable What-if Analysis is enabled if and only if the fEnableWB field of the BrtBeginSXView14 record is 0x1 and the source data is OLAP.