2.4.127 BrtBeginPCDCalcMem14
The BrtBeginPCDCalcMem14 (section 2.4.127) record specifies extended properties of an OLAP calculated member specified by BrtBeginPCDCalcMem (section 2.4.126) or BrtBeginPCDCalcMemExt (section 2.4.128) that immediately precedes this record and specifies the beginning of a collection of records as defined by the Common Productions part (section 2.1.8) ABNF.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
unused |
irstDisplayFolder (variable) |
|||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
irstMDXFormulaLong (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
FRTHeader (4 bytes): An FRTBlank (section 2.5.55) that specifies the future record (section 2.1.6) information for this record.
A - fFlattenHierarchies (1 bit): A bit that specifies whether to display members from different levels of the same cache hierarchy (section 2.2.5.2.7) of this named set (section 2.2.5.2.7.3) in the same pivot field (section 2.2.5). This field MUST be ignored if the pcdCalcMemCommon.fSet field in the BrtBeginPCDCalcMem or the BrtBeginPCDCalcMemExt record that immediately precedes this record is 0. If the BrtPCDH14 (section 2.4.719) record that corresponds to the named set (section 2.2.5.2.7.3) exists, this value MUST be equal to the value in the fFlattenHierarchies field of the BrtPCDH14 record. The possible values for this field are listed in the following table.
-
Value
Meaning
0
Each member from a different level of the same cache hierarchy of this named set is displayed in a separate pivot field (section 2.2.5).
1
All members from different levels of the same cache hierarchy of this named set are displayed in the same pivot field.
B - fDynamicSet (1 bit): A bit that specifies whether this named set is a dynamic OLAP named set. This field MUST be ignored if the pcdCalcMemCommon.fSet field in the BrtBeginPCDCalcMem or BrtBeginPCDCalcMemExt record that immediately precedes this record is 0. The possible values for this field are listed in the following table.
-
Value
Meaning
0
This named set is a static OLAP named set.
1
This named set is a dynamic OLAP named set.
C - fHierarchizeDistinct (1 bit): A bit that specifies whether to automatically order and remove duplicates from this named set. This field MUST be ignored if the pcdCalcMemCommon.fSet field in the BrtBeginPCDCalcMem or BrtBeginPCDCalcMemExt record that immediately precedes this record is 0. If the BrtPCDH14 record that corresponds to the named set exists, this value MUST be equal to the value in the fHierarchizeDistinct field of the BrtPCDH14 record. The possible values for this field are listed in the following table.
-
Value
Meaning
0
Do not automatically order and remove duplicates from this named set.
1
Automatically order and remove duplicates from this named set.
unused (5 bits): This field is unused and MUST be ignored.
irstDisplayFolder (variable): An XLWideString (section 2.5.169) that specifies the display folder of this named set. The length of this value MUST be less than 65,536 characters. This field MUST be ignored if the pcdCalcMemCommon.fSet field in the BrtBeginPCDCalcMem or BrtBeginPCDCalcMemExt record that immediately precedes this record is 0.
irstMDXFormulaLong (variable): An XLWideString that specifies the Multidimensional Expressions (MDX) of the OLAP calculated member. The length of this value MUST be 0 or it MUST be greater than 32,767 characters and less than 1,073,741,824 characters. If this value is greater than 32,767 characters, the length of the pcdCalcMemCommon.stMdx field in the BrtBeginPCDCalcMem or BrtBeginPCDCalcMemExt record that immediately precedes this record MUST be 1 and the first character of the pcdCalcMemCommon.stMdx field MUST be equal to 0x0020.