MemberProperties class

Office 2013 and later

OLAP Member Properties. When the object is serialized out as xml, its qualified name is x:mps.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

[ISO/IEC 29500-1 1st Edition]

mps (OLAP Member Properties)

Represents the collection of OLAP member property. Member properties contain additional information that is available about the items in an OLAP dimension field. [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. end example]

[Example:

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

end example]

Parent Elements

pivotHierarchy (§18.10.1.72)

Child Elements

Subclause

mp (OLAP Member Property)

§18.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 W3C XML Schema unsignedInt datatype.

[Note: The W3C XML Schema definition of this element’s content model (CT_MemberProperties) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: