2.4.273.82 SXAddl_SXCSXFilter12_SXDSXFilter

Office

The SXAddl_SXCSXFilter12_SXDSXFilter record specifies the filter information of an advanced filter for an SXCSXFilter2.2.5.1.1.1.21 class.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

hdr

...

reserved1

...

reserved2

isxvd

isxvdMProp

sxft

unused

isxdiMeasure

isxthMeasure

hdr (6 bytes):  An SXAddlHdr structure. The value of hdr.sxc MUST equal 0x1D and the value of hdr.sxd MUST equal 0x38.

reserved1 (4 bytes): MUST be zero and MUST be ignored.

reserved2 (2 bytes): MUST be zero and MUST be ignored.

isxvd (4 bytes): An unsigned integer that specifies a pivot field index as specified in pivot fields. The pivot field index specifies which pivot field this filter applies to. The value MUST be less than the cDim field of the SxView record of this PivotTable view.

isxvdMProp (4 bytes):  A signed integer that specifies the member property pivot field on which this advanced filter is based. MUST be a value from the following table:

Value

Meaning

-1

This advanced filter is not defined on a member property.

Greater than or equal to zero

This value specifies a pivot field index as specified in pivot fields. The pivot field index specifies which pivot field this advanced filter is based on.

This value MUST be -1 and MUST be ignored if the value of the sxft field is less than 0x00000004 or greater than 0x00000011. The value MUST be greater than or equal to -1 and less than the value of the cDim field of the SxView record of this PivotTable view.

sxft (4 bytes): A SxFT structure that specifies the advanced filter type. If the value is equal to SXFTCOUNT, SXFTPERCENT, or SXFTSUM, the cft field in SXAddl_SXCSXFilter2.4.273.86_SXDXIsFilter MUST be equal to CFTTOP10.

unused (4 bytes): Undefined and MUST be ignored.

isxdiMeasure (4 bytes): A signed integer that specifies a data item index of the data item on which this advanced filter is based. If this is an OLAP PivotTable view then isxdiMeasure MUST be -1, if this is a value filter then isxdiMeasure MUST be greater than or equal to zero and less than the number of SXDI records in this PivotTable view. Otherwise isxdiMeasure MUST be 0.

isxthMeasure (4 bytes): A signed integer that specifies a pivot hierarchy index of the measure pivot hierarchy on which this advanced filter applies. If this is a non-OLAP PivotTable view then isxthMeasure MUST be -1. If this is a value filter then isxthMeasure MUST be greater than or equal to zero and less than the number of SXTH records in this PivotTable view. Otherwise isxthMeasure MUST be 0.

Show: