2.4.299 SXPIEx

The SXPIEx record specifies OLAP extensions to the page axis of a PivotTable view. The number of SXPIEx records MUST equal the number of array elements in the rgsxpi field of the SXPI record. Each SXPIEx record corresponds to the SXPI_Item at the same position in the rgsxpi field of the SXPI record.

For more information, see OLAP Page Filtering.


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

frtHeaderOld

isxth

stUnique (variable)

...

stDisplay (variable)

...

frtHeaderOld (4 bytes): An FrtHeaderOld structure. The frtHeaderOld.rt field MUST be 0x080E.

isxth (4 bytes): An unsigned integer that specifies a pivot hierarchy index, as specified in Pivot Hierarchies, of the pivot hierarchy associated with this entry on the page axis. The sxaxis.sxaxisPage field of the SXTH record of the pivot hierarchy MUST be 1. 

stUnique (variable): A XLUnicodeString structure that specifies the unique name of the OLAP member that is used for filtering. The length of the string MUST be less than or equal to 255.

stDisplay (variable): A XLUnicodeString structure that specifies the caption of this OLAP member. The length of the string MUST be less than or equal to 255.