2.2.4.165 SetOperation

  • Article

Namespace: http://www.microsoft.com/performancepoint/scorecards

This complex type specifies a set operation.

It is the abstract base type for AddAllMembersSetOp, AddCalcMemberSetOp, AddChildrenSetOp, AddDefaultMemberSetOp, AddDescendantsLeavesSetOp, AddDescendantsSetOp, AddDescendantsSubtreeSetOp, AddFilterSetOp, AddFilterTopBottomSetOp, AddMemberSetOp, AddNamedSetSetOp, AddParentSiblingsSetOp, EliminateDescendantsSetOp and EliminateMemberSetOp.

 <xs:complexType name="SetOperation" abstract="true" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:sequence>
     <xs:element minOccurs="0" maxOccurs="1" name="Name" type="xs:string"/>
     <xs:element minOccurs="1" maxOccurs="1" name="FilterValue1" type="xs:double"/>
     <xs:element minOccurs="1" maxOccurs="1" name="FilterValue2" type="xs:double"/>
     <xs:element minOccurs="0" maxOccurs="1" name="TupleSet" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="TupleCaption" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="FilterHierarchy" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="FilterMeasure" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="DefaultMeasure" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="Level" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="LevelDepth" type="xs:string"/>
     <xs:element minOccurs="1" maxOccurs="1" name="FilterType" type="xs:int"/>
     <xs:element minOccurs="0" maxOccurs="1" name="MemberDefinition" type="xs:string"/>
   </xs:sequence>
 </xs:complexType>

Name: Specifies the name of a set operation.

FilterValue1: This contains the first filter value for those filter operations that need two filter values (for example, filtering a set such that the result is between a given minimum and maximum values). This is also used for filter operations that only require one filter value.

FilterValue2: For filter operations that need two filter values, this contains the second filter value. This is ignored for filter operations that only need one filter value.

TupleSet: This is the string representation of the tuple set used in filter operation to specify what to filter. The tuple set definition MUST be a valid MDX expression.

TupleCaption: This contains the tuple caption that will be displayed on the information bar.

FilterHierarchy: This contains the hierarchy unique name in a valid MDX that is used on the filter operation.

FilterMeasure: This contains the measure display name in that is used on the filter operation.

DefaultMeasure:  This attribute is deprecated from the protocol and MUST NOT be used.

Level: This is used in filter set operation. This contains the level display name where the filter is being applied.

LevelDepth: This is used in filter set operation. This contains the level number where the filter is being applied.

FilterType: Specifies the type of filter. This MUST be one of the following values

Value

Meaning

0

No filter specified

1

Specifies top count.

2

Specifies top percent.

3

Specifies top sum.

4

Specifies bottom count.

5

Specifies bottom percent.

6

Specifies bottom sum.

7

Specifies equal.

8

Specifies not equals.

9

Specifies greater than.

10

Specifies greater than or equals.

11

Specifies less than.

12

Specifies less than or equals.

13

Specifies between.

14

Specifies not between.

 

MemberDefinition:  This defines a calculated member in a valid MDX being added to a MemberSet (see section 2.2.4.144).