Export (0) Print
Expand All
Expand Minimize

2.4.273.57 SXAddl_SXCHierarchy_SXDProperty

Office

The SXAddl_SXCHierarchy_SXDProperty record specifies a member property of a pivot hierarchy for a SxcHierarchy class. The member property is displayed if the OLAP PivotTable view is recalculated and the pivot hierarchy is either on the row axis as specified by the sxaxis.sxaxisRw field of SXTH or on the column axis as specified by the sxaxis.sxaxisCol field of SXTH.


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

...

A

B

C

reserved1

...

reserved2

cchProperty

stProperty (variable)

...

cchLevelUnq

ichPropName

cchPropName

isxtl

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

A - fDisplayInReport (1 bit): A bit that specifies whether this member property is displayed in the row axis or in the column axis, if this member property is associated with a pivot field.

B - fDisplayInTip (1 bit): A bit that specifies whether this member property is displayed in a ToolTip.

C - fDisplayInCaption (1 bit): A bit that specifies whether this member property is used as a caption for pivot items in the pivot field that is in this pivot hierarchy and is specified by the SXVDTex record with an isxtl field equal to the value of the isxtl field of this record. MUST be 0 if the PivotCache functionality level of the associated PivotCache is less than 3.

reserved1 (29 bits): MUST be zero, and MUST be ignored.

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

cchProperty (2 bytes): An unsigned integer that specifies the length in characters of stProperty.

The value MUST be greater than or equal to five characters and less than or equal to 255 characters.

stProperty (variable): An XLUnicodeStringNoCch that specifies the MDX unique name of this member property. If a cache field has a matching value in the stFieldName field of SXFDB, then the cache field is a member property cache field and is associated with this pivot hierarchy.

The length is specified in cchProperty.

cchLevelUnq (2 bytes): An unsigned integer that specifies the length in characters of the OLAP level MDX unique name of the cache pivot hierarchy in stProperty. The OLAP level MDX unique name comes before the member property name in stProperty. For example, if the value for stProperty equals "[Store].[Store Name].[Store Manager]", then cchLevelUnq equals 20. This refers to "[Store].[Store Name]".

If the PivotCache functionality level of the associated PivotCache is 3, then this value is undefined and MUST be ignored.

ichPropName (2 bytes): An unsigned integer that specifies the zero-based index of the character where the property name portion begins in stProperty. For example, if the value for stProperty equals "[Store].[Store Name].[Store Manager]", ichPropName equals 22. This refers to the starting character of "Store Manager".

If the PivotCache functionality level of the associated PivotCache is 3, then this value is undefined and MUST be ignored.

cchPropName (2 bytes): An unsigned integer that specifies the length in characters of the name portion of stProperty. For example, if the value for stProperty equals "[Store].[Store Name].[Store Manager]", cchPropName equals 13. This refers to the length of "Store Manager".

If the PivotCache functionality level of the associated PivotCache is 3, then this value is undefined and MUST be ignored.

isxtl (2 bytes): A signed integer that specifies the zero-based index of the OLAP level in the pivot hierarchy that this property applies to. The value MUST be greater than or equal to -1.

Show:
© 2014 Microsoft