[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

mps (OLAP Member Properties)

Represents the collection of OLAP member property. Member properties contain additional information that's available about the items in an OLAP dimension field. For example, if a Geography dimension has property fields Population and Average Income available, you could create a PivotTable report that displays the sales figures for cities where your products are selling well. By displaying and analyzing the population and income figures for these cities, you could target cities with similar demographics for your marketing campaign.

 

[Example:

<sh:mps count="3">
<sh:mp field="7"/>
<sh:mp field="8"/>
<sh:mp field="9"/>
</sh:mps>

end example]

Parent Elements

pivotHierarchy3.10.1.72)

 

Child Elements

Subclause

mp (OLAP Member Property)

§3.10.1.57

 

Attributes

Description

count (OLAP Member Properties Count)

Specifies the number of OLAP member properties in the collection.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_MemberProperties">

   <sequence>

   <element name="mp" maxOccurs="unbounded" type="CT_MemberProperty"/>

   </sequence>

   <attribute name="count" type="xsd:unsignedInt"/>

</complexType>