Export (0) Print
Expand All
Expand Minimize

2.4.273.100 SXAddl_SXCView_SXDCalcMember

Office

The SXAddl_SXCView_SXDCalcMember record specifies OLAP calculated members properties for a PivotTable view, for an SxcView 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

...

A

B

C

D

E

F

reserved2

...

reserved3

stName (variable)

...

stMDXFormula (variable)

...

stMemberName (variable)

...

stSourceHierarchy (variable)

...

stParentUnqiue (variable)

...

wSolveOrder

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

A - fParentUnique (1 bit): A bit that specifies whether stParentUnique exists. If the value is 1, stParentUnique exists. If fSet is 1, this field MUST be zero.

B - fMemberName (1 bit): A bit that specifies whether stMemberName exists. If the value is 1, stMemberName exists. If fSet is 1, this field MUST be zero; otherwise, this field MUST be 1.

C - fSourceHier (1 bit): A bit that specifies whether stSourceHierarchy exists. If the value is 1, stSourceHierarchy exists. If fSet is 1, this field MUST be zero; otherwise, this field MUST be 1.

D - fLongFormula (1 bit): A bit that specifies whether the length of the user-specified MDXexpression that defines the calculation is greater than 255 characters.

MUST be a value from the following table:

Value

Meaning

0

Length of the user-specified MDX expression is less than or equal to 255 characters and stMDXFormula contains the MDX.

1

Length of the user-specified MDX expression is greater than 255 characters and the user-specified MDX expression is written to a subsequent SXAddl_SXCView_SXDCalcMemString record.

E - reserved1 (4 bits): MUST be zero, and MUST be ignored.

F - fSet (1 bit): A bit that specifies whether this calculation is for an OLAP named set.

reserved2 (23 bits): MUST be zero, and MUST be ignored.

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

stName (variable): An XLUnicodeString structure that specifies the MDX unique name of this OLAP calculated member. The length of this field MUST be greater than 0 characters and less than or equal to 255 characters.

stMDXFormula (variable): An XLUnicodeString structure that specifies the user-specified MDX expression for this OLAP calculated member. If fLongFormula is 1, this field does not exist. If fLongFormula is 0, the length of this field MUST be greater than 0 characters and less than or equal to 255 characters.

stMemberName (variable): An XLUnicodeString structure that specifies the name of this OLAP calculated member. If fMemberName is 0, this field does not exist. If fMemberName is 1, the length of this field MUST be less than or equal to 255 characters.

stSourceHierarchy (variable): An XLUnicodeString structure that specifies the MDX unique name of the OLAP hierarchy that this OLAP calculated member is associated with. If fSourceHier is zero this field does not exist. If fSourceHier is 1 then the length of this field MUST be less than or equal to 255 characters.

stParentUnqiue (variable): An XLUnicodeString structure that specifies the MDX unique name of the parent member (3) that this OLAP calculated member is associated with. If fParentUnique is zero this field does not exist. If fParentUnique is 1 then the length of this field MUST be less than or equal to 255 characters.

wSolveOrder (4 bytes): An unsigned integer that specifies the calculation order when there are multiple OLAP calculated members. The calculation order goes from lowest wSolveOrder value to highest. If the value is zero the calculation order is determined by the OLAPdata provider.

Show:
© 2014 Microsoft