2.5.99 PCDCalcMemCommon

The PCDCalcMemCommon structure specifies an OLAP calculated member.


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

A

B

C

reserved

wSolveOrder

fSet

stName (variable)

...

stMdx (variable)

...

stMemberName (variable)

...

stSourceHier (variable)

...

stParentUnique (variable)

...

A - fLoadMemberName (1 bit): A bit that specifies whether or not stMemberName exists. This value MUST be 1 if fSet is 0. It MUST be 0 if fSet is 1.

B - fLoadSourceHier (1 bit): A bit that specifies whether stSourceHier exists. This value MUST be 1 if fSet is 0. It MUST be 0 if fSet is 1.

C - fLoadParentUnique (1 bit): A bit that specifies whether stParentUnique exists. This value MUST be 0 if fSet is 1.

reserved (29 bits): This value MUST be 0, and MUST be ignored.

wSolveOrder (4 bytes): A signed integer that specifies the order in which this OLAP calculated member is calculated in relation to other OLAP calculated members. The value is used in SOLVE_ORDER property in the MDX statement for creating the calculated member. The value MUST be ignored if fSet is 1.

fSet (4 bytes): A Boolean (section 2.5.98.3) that specifies whether this record specifies a named set (section 2.2.5.2.7.3) or an OLAP calculated member.

Value

Meaning

0x00000000

This record specifies an OLAP calculated member.

0x00000001

This record specifies a named set.

stName (variable): An XLWideString (section 2.5.169) that specifies the name of the OLAP calculated member. The length of this value MUST be greater than zero and MUST be less than 65536 characters.

stMdx (variable): An XLWideString that specifies the Multidimensional Expressions (MDX) of the OLAP calculated member. The length of this value MUST be greater than zero. If this OLAP calculated member is associated with an external connection (section 2.2.8) that is not associated with a PivotCache (section 2.2.5.2), the length of this value MUST be less than 32768 characters. Otherwise, if the bVerCacheCreated field of the BrtBeginPivotCacheDef (section 2.4.168) record that immediately precedes the containing record is greater than or equal to 3, then the length of this value MUST be less than 32768 characters, otherwise it MUST be less than 2049 characters.

stMemberName (variable): An optional XLWideString that specifies the MDX unique name for the OLAP calculated member. The length of this value MUST be less than 65536 characters. It MUST exist only if fLoadMemberName is 1.

stSourceHier (variable): An optional XLWideString (section 2.5.169) that specifies the name of the cache hierarchy (section 2.2.5.2.7) to which the OLAP calculated member belongs. The length of this value MUST be less than 65536. It MUST exist only if fLoadSourceHier is 1.

stParentUnique (variable): An optional XLWideString that specifies the name of the parent OLAP member of the OLAP calculated member. The length of this value MUST be less than 65536. If this value does not exist, this OLAP calculated member has no parent OLAP member. It MUST exist only if fLoadParentUnique is 1.