2.2.4.2.2.10.1 CalculationProperty

This complex type represents properties associated with a calculation in the MDX script.

 <xsd:complexType name="CalculationProperty">
     <xsd:all>
       <xsd:element name="CalculationReference" type="xsd:string"/>
       <xsd:element name="CalculationType">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string">
             <xsd:enumeration value="Member" />
             <xsd:enumeration value="Set" />
             <xsd:enumeration value="Cells" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Translations" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Translation"  type="Translation" minOccurs="0"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="Description" type="xsd:string" minOccurs="0"/>
       <xsd:element name="Visible" type="xsd:boolean" minOccurs="0"/>
       <xsd:element name="SolveOrder" type="xsd:integer" minOccurs="0"/>
       <xsd:element name="FormatString" type="xsd:string" minOccurs="0"/>
       <xsd:element name="ForeColor" type="xsd:string" minOccurs="0"/>
       <xsd:element name="BackColor" type="xsd:string" minOccurs="0"/>
       <xsd:element name="FontName" type="xsd:string" minOccurs="0"/>
       <xsd:element name="FontSize" type="xsd:string" minOccurs="0"/>
       <xsd:element name="FontFlags" type="xsd:string" minOccurs="0"/>
       <xsd:element name="NonEmptyBehavior" type="xsd:string" minOccurs="0"/>
       <xsd:element name="AssociatedMeasureGroupID" type="xsd:string" minOccurs="0"/>
       <xsd:element name="DisplayFolder" type="xsd:string" minOccurs="0"/>
       <xsd:element name="Language" type="xsd:integer" minOccurs="0"/>
       <xsd:element name ="VisualizationProperties" 
                          type="eng300:CalculationPropertiesVisualizationProperties" 
                          minOccurs="0" maxOccurs="1"/>
     </xsd:all>
   </xsd:complexType>

Element

Read-Only

Default value

Description

CalculationReference

[Required]

The name of the object to which the CalculationProperty applies.

CalculationType

[Required]

Specifies the type of calculation to which the CalculationProperty applies.

Translations

Empty

A collection of objects of type Translation.

Description

Empty

The object description.

Visible

True

When true, indicates that this object is visible to the user; otherwise, false. Applies to Set and Member.

SolveOrder

Empty

Indicates the solve order in which the CalculationProperty element is applied to a calculated member or calculated cell definition. Applies to Member and Cell CalculationType.

FormatString

Empty

An MDX expression that defines the FormatString to be used in the display. Applies to Member and Cell CalculationType.

ForeColor

Empty

An MDX expression that defines the ForeColor to be used in the display. Applies to Member and Cell CalculationType.

BackColor

Empty

An MDX expression that defines the BackColor to be used in the display. Applies to Member and Cell CalculationType.

FontName

Empty

An MDX expression that defines the FontName to be used in the display. Applies to Member and Cell CalculationType.

FontSize

Empty

An MDX expression that defines the FontSize to be used in the display. Applies to Member and Cell CalculationType.

FontFlags

Empty

An MDX expression that defines the FontFlags to be used in the display. Applies to Member and Cell CalculationType.

NonEmptyBehavior

Empty

A valid MDX Set expression that only applies when CalculationType is set to "Member".

AssociatedMeasureGroupID

Empty

The ID of the measure group with which this calculation is associated.

DisplayFolder

Empty

The folder in which to list the parent CalculationProperty object. Applies to Member and Set CalculationType.

Language

Empty

The LCID of the language to use by default. See [MS-LCID] for information about LCIDs. If empty, the server will determine the language to use.<83>

VisualizationProperties

A complex type that specifies a set of properties for visualization of the DimensionAttribute.