2.2.10.1.3.5.3 CalculatedMembers

  • Article

The syntax is defined as follows.           

 CalculatedMembers = 
 OPEN(140)
   Int16 (141)
   Int16(142) 
   DPATH(143)
   String(144)
   Int32(145)
   Int32(241) 
   Int32(583)
   [String(146)]
   String(252)
   Int32(147) 
   Int32(406)
   Int32(485)
   Int32(531)
   [String(532)] 
   [UInt16(533)] 
   [UInt16(534)] 
   [UInt32(535)] 
   [UInt32(536)] 
   String(537) 
   String(538)                                 
   String(539) 
   String(540) 
   String(541)
   UInt16(554) 
 CLOSE       

Element

Description

OPEN(140)

A common data structure that indicates the beginning of the element.

Int16 (141)

This value indicates the current level.

Int16(142)

This value indicates the number of levels.

DPATH(143)

This value indicates the DPATH to a calculated member.

String(144)

This value indicates a member name.

Int32(145)

This value indicates the ID of the Vertex assigned by the query engine (for internal calculation).

Int32(241)

This value indicates the current number of calculated members.

Int32(583)

This value indicates a Cookie. The same value is passed back and forth between the client and server. A value of 0 specifies that it comes from client; otherwise it is an internal cookie that is used by the server.

[String(146)]

Returned only when INT32(583)=0. Contains MDX formula text for the CalculatedMember.

String(252)

This value indicates a format string. For example, Standard.

Int32(147)

This value indicates a solve order.

Int32(406)

This value indicates whether formula is hidden.

Int32(485)

Mask for internal calculation pathways of Vertices. See section 2.2.10.1.3.5.2.1 for more information. Used in calculated members.

Int32(531)

This value indicates whether Calculated Member has the following attributes.

Has format property 0x00000001

Has font name property 0x00000002

Has font size property 0x00000004

Has font attribute property 0x00000008

Has back color property 0x00000010

Has fore color property 0x00000020

[String(532)]

FontName property value, optional.

[UInt16(533)]

FontSize property value, optional.

[UInt16(534)]

FontAttribute property value, optional.

[UInt32(535)]

Background Color property value, optional.

[UInt32(536)]

Foreground Color property value, optional.

String(537)

MDX Background Color property value.

String(538)

MDX Foreground Color property value.

String(539)

MDX Font size property value.

String(540)

MDX Font attribute property value.

String(541)

MDX Font Name property value.

UInt16(554)

If NonEmptyBehavior not set by user, this is 0. If NonEmptyBehavior is set, this value is the ID of the Measure used for NonEmptyBehavior.

CLOSE

A common data structure that indicates the end of the element.