2.2.4.2.2.8.1 DimensionAttribute

  • Article

The DimensionAttribute complex type represents an attribute of a dimension.

   <xsd:complexType name="DimensionAttribute">
     <xsd:all>
       <xsd:element name="Name" type="xsd:string"/>
       <xsd:element name="ID" type="xsd:string" minOccurs="0"/>
       <xsd:element name="Description" type="xsd:string" minOccurs="0"/>
       <xsd:element name="Type" minOccurs="0">
         <xsd:complexType>
           <xsd:simpleContent>
             <xsd:extension base="DimensionAttributeTypeEnumType">
               <xsd:attribute name="valuens" >
                 <xsd:simpleType>
                   <xsd:restriction base="xsd:string">
                     <xsd:enumeration value=
              "http://schemas.microsoft.com/analysisservices/2010/engine/200/200" />
                   </xsd:restriction>
                 </xsd:simpleType>
               </xsd:attribute>
             </xsd:extension>
           </xsd:simpleContent>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="Usage" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Regular" />
             <xsd:enumeration value="Key" />
             <xsd:enumeration value="Parent" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Source" type="Binding" minOccurs="0" />
       <xsd:element name="EstimatedCount" type="xsd:long" minOccurs="0"/>
       <xsd:element name="KeyColumns" >
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="KeyColumn"  type="DataItem" minOccurs="0"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="NameColumn" type="DataItem" minOccurs="0" />
       <xsd:element name="ValueColumn" type="DataItem" minOccurs="0" />
       <xsd:element name="Translations" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Translation"  type="AttributeTranslation" minOccurs="0"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="AttributeRelationships" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="AttributeRelationship"  type="AttributeRelationship"
                          minOccurs="0" maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="DiscretizationMethod" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="None" />
             <xsd:enumeration value="Automatic" />
             <xsd:enumeration value="EqualAreas" />
             <xsd:enumeration value="Clusters" />
             <xsd:enumeration value="Thresholds" />
             <xsd:enumeration value="UserDefined" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DiscretizationBucketCount" type="xsd:integer" minOccurs="0"/>
       <xsd:element name="RootMemberIf" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="ParentIsBlankSelfOrMissing" />
             <xsd:enumeration value="ParentIsBlank" />
             <xsd:enumeration value="ParentIsSelf" />
             <xsd:enumeration value="ParentIsMissing" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="OrderBy" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Key" />
             <xsd:enumeration value="Name" />
             <xsd:enumeration value="AttributeKey" />
             <xsd:enumeration value="AttributeName" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DefaultMember" type="xsd:string" minOccurs="0"/>
       <xsd:element name="OrderByAttributeID" type="xsd:string" minOccurs="0"/>
       <xsd:element name="SkippedLevelsColumn" type="DataItem" minOccurs="0" />
       <xsd:element name="NamingTemplate" type="xsd:string" minOccurs="0"/>
       <xsd:element name="MembersWithData"  minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="NonLeafDataHidden" />
             <xsd:enumeration value="NonLeafDataVisible" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="MembersWithDataCaption" type="xsd:string" minOccurs="0"/>
       <xsd:element name="NamingTemplateTranslations" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="NamingTemplateTranslation"  type="Translation"
                          minOccurs="0" maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="CustomRollupColumn" type="DataItem" minOccurs="0" />
       <xsd:element name="CustomRollupPropertiesColumn" type="DataItem"
                    minOccurs="0" />
       <xsd:element name="UnaryOperatorColumn" type="DataItem" minOccurs="0" />
       <xsd:element name="AttributeHierarchyOrdered" type="xsd:boolean"
                    minOccurs="0"/>
       <xsd:element name="MemberNamesUnique" type="xsd:boolean" minOccurs="0"/>
       <xsd:element name="IsAggregatable" type="xsd:boolean" minOccurs="0"/>
       <xsd:element name="AttributeHierarchyEnabled" type="xsd:boolean"
                    minOccurs="0"/>
       <xsd:element name="AttributeHierarchyOptimizedState" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="FullyOptimized" />
             <xsd:enumeration value="NotOptimized" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="AttributeHierarchyVisible" type="xsd:boolean"
                    minOccurs="0"/>
       <xsd:element name="AttributeHierarchyDisplayFolder" type="xsd:string"
                    minOccurs="0"/>
       <xsd:element name="KeyUniquenessGuarantee" type="xsd:boolean"
                    minOccurs="0"/>
       <xsd:element name="GroupingBehavior" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="EncourageGrouping" />
             <xsd:enumeration value="DiscourageGrouping" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="InstanceSelection" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="None" />
             <xsd:enumeration value="DropDown" />
             <xsd:enumeration value="List" />
             <xsd:enumeration value="FilteredList" />
             <xsd:enumeration value="MandatoryFilter" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Annotations" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Annotation"  type="Annotation" minOccurs="0"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="ProcessingState" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Processed" />
             <xsd:enumeration value="Unprocessed" />
             <xsd:enumeration value="InvalidExpression" />
             <xsd:enumeration value="CalculationError" />
             <xsd:enumeration value="DependencyError" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="AttributeHierarchyProcessingState" 
                    type="eng300:AttributeHierarchyProcessingState" 
                    minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Processed" />
             <xsd:enumeration value="Unprocessed" />
             <xsd:enumeration value="DependencyError" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name ="VisualizationProperties" 
                    type="eng300:DimensionAttributeVisualizationProperties" 
                    minOccurs="0" maxOccurs="1"/>
       <xsd:element name ="ExtendedType" type="xsd:string" minOccurs="0" maxOccurs="1"/>
     </xsd:all>
   </xsd:complexType>
            
   <xsd:simpleType name="DimensionAttributeTypeEnumType">
     <xsd:restriction base="xsd:string" >
       <xsd:enumeration value="Account" />
       <xsd:enumeration value="AccountName" />
       <xsd:enumeration value="AccountNumber" />
       <xsd:enumeration value="AccountType" />
       <xsd:enumeration value="Address" />
       <xsd:enumeration value="AddressBuilding" />
       <xsd:enumeration value="AddressCity" />
       <xsd:enumeration value="AddressCountry" />
       <xsd:enumeration value="AddressFax" />
       <xsd:enumeration value="AddressFloor" />
       <xsd:enumeration value="AddressHouse" />
       <xsd:enumeration value="AddressPhone" />
       <xsd:enumeration value="AddressQuarter" />
       <xsd:enumeration value="AddressRoom" />
       <xsd:enumeration value="AddressStateOrProvince" />
       <xsd:enumeration value="AddressStreet" />
       <xsd:enumeration value="AddressZip" />
       <xsd:enumeration value="BomResource" />
       <xsd:enumeration value="Caption" />
       <xsd:enumeration value="CaptionAbbreviation" />
       <xsd:enumeration value="CaptionDescription" />
       <xsd:enumeration value="Channel" />
       <xsd:enumeration value="City" />
       <xsd:enumeration value="Company" />
       <xsd:enumeration value="Continent" />
       <xsd:enumeration value="Country" />
       <xsd:enumeration value="County" />
       <xsd:enumeration value="CurrencyDestination" />
       <xsd:enumeration value="CurrencyIsoCode" />
       <xsd:enumeration value="CurrencyName" />
       <xsd:enumeration value="CurrencySource" />
       <xsd:enumeration value="CustomerGroup" />
       <xsd:enumeration value="CustomerHousehold" />
       <xsd:enumeration value="Customers" />
       <xsd:enumeration value="Date" />
       <xsd:enumeration value="DateCanceled" />
       <xsd:enumeration value="DateDuration" />
       <xsd:enumeration value="DateEnded" />
       <xsd:enumeration value="DateModified" />
       <xsd:enumeration value="DateStart" />
       <xsd:enumeration value="DayOfHalfYear" />
       <xsd:enumeration value="DayOfMonth" />
       <xsd:enumeration value="DayOfQuarter" />
       <xsd:enumeration value="DayOfTenDays" />
       <xsd:enumeration value="DayOfTrimester" />
       <xsd:enumeration value="DayOfWeek" />
       <xsd:enumeration value="DayOfYear" />
       <xsd:enumeration value="Days" />
       <xsd:enumeration value="DeletedFlag" />
       <xsd:enumeration value="ExtendedType" />
       <xsd:enumeration value="FiscalDate" />
       <xsd:enumeration value="FiscalDayOfHalfYear" />
       <xsd:enumeration value="FiscalDayOfMonth" />
       <xsd:enumeration value="FiscalDayOfQuarter" />
       <xsd:enumeration value="FiscalDayOfTrimester" />
       <xsd:enumeration value="FiscalDayOfWeek" />
       <xsd:enumeration value="FiscalDayOfYear" />
       <xsd:enumeration value="FiscalHalfYears" />
       <xsd:enumeration value="FiscalHalfYearOfYear" />
       <xsd:enumeration value="FiscalMonths" />
       <xsd:enumeration value="FiscalMonthOfHalfYear" />
       <xsd:enumeration value="FiscalMonthOfQuarter" />
       <xsd:enumeration value="FiscalMonthOfTrimester" />
       <xsd:enumeration value="FiscalMonthOfYear" />
       <xsd:enumeration value="FiscalQuarters" />
       <xsd:enumeration value="FiscalQuarterOfHalfYear" />
       <xsd:enumeration value="FiscalQuarterOfYear" />
       <xsd:enumeration value="FiscalTrimesters" />
       <xsd:enumeration value="FiscalTrimesterOfYear" />
       <xsd:enumeration value="FiscalWeeks" />
       <xsd:enumeration value="FiscalWeekOfHalfYear" />
       <xsd:enumeration value="FiscalWeekOfMonth" />
       <xsd:enumeration value="FiscalWeekOfQuarter" />
       <xsd:enumeration value="FiscalWeekOfTrimester" />
       <xsd:enumeration value="FiscalWeekOfYear" />
       <xsd:enumeration value="FiscalYears" />
       <xsd:enumeration value="FormattingColor" />
       <xsd:enumeration value="FormattingFont" />
       <xsd:enumeration value="FormattingFontEffects" />
       <xsd:enumeration value="FormattingFontSize" />
       <xsd:enumeration value="FormattingOrder" />
       <xsd:enumeration value="FormattingSubtotal" />
       <xsd:enumeration value="GeoBoundaryBottom" />
       <xsd:enumeration value="GeoBoundaryFront" />
       <xsd:enumeration value="GeoBoundaryLeft" />
       <xsd:enumeration value="GeoBoundaryPolygon" />
       <xsd:enumeration value="GeoBoundaryRear" />
       <xsd:enumeration value="GeoBoundaryRight" />
       <xsd:enumeration value="GeoBoundaryTop" />
       <xsd:enumeration value="GeoCentroidX" />
       <xsd:enumeration value="GeoCentroidY" />
       <xsd:enumeration value="GeoCentroidZ" />
       <xsd:enumeration value="HalfYears" />
       <xsd:enumeration value="HalfYearOfYear" />
       <xsd:enumeration value="Hours" />
       <xsd:enumeration value="ID" />
       <xsd:enumeration value="Image" />
       <xsd:enumeration value="ImageBmp" />
       <xsd:enumeration value="ImageGif" />
       <xsd:enumeration value="ImageJpg" />
       <xsd:enumeration value="ImagePng" />
       <xsd:enumeration value="ImageTiff" />
       <xsd:enumeration value="ImageUrl" />
       <xsd:enumeration value="IsHoliday" />
       <xsd:enumeration value="Iso8601Date" />
       <xsd:enumeration value="Iso8601DayOfWeek" />
       <xsd:enumeration value="Iso8601DayOfYear" />
       <xsd:enumeration value="Iso8601Weeks" />
       <xsd:enumeration value="Iso8601WeekOfYear" />
       <xsd:enumeration value="Iso8601Years" />
       <xsd:enumeration value="IsPeakDay" />
       <xsd:enumeration value="IsWeekDay" />
       <xsd:enumeration value="IsWorkingDay" />
       <xsd:enumeration value="ManufacturingDate" />
       <xsd:enumeration value="ManufacturingDayOfHalfYear" />
       <xsd:enumeration value="ManufacturingDayOfMonth" />
       <xsd:enumeration value="ManufacturingDayOfQuarter" />
       <xsd:enumeration value="ManufacturingDayOfWeek" />
       <xsd:enumeration value="ManufacturingDayOfYear" />
       <xsd:enumeration value="ManufacturingHalfYears" />
       <xsd:enumeration value="ManufacturingHalfYearOfYear" />
       <xsd:enumeration value="ManufacturingMonths" />
       <xsd:enumeration value="ManufacturingMonthOfHalfYear" />
       <xsd:enumeration value="ManufacturingMonthOfQuarter" />
       <xsd:enumeration value="ManufacturingMonthOfYear" />
       <xsd:enumeration value="ManufacturingQuarters" />
       <xsd:enumeration value="ManufacturingQuarterOfHalfYear" />
       <xsd:enumeration value="ManufacturingQuarterOfYear" />
       <xsd:enumeration value="ManufacturingWeeks" />
       <xsd:enumeration value="ManufacturingWeekOfHalfYear" />
       <xsd:enumeration value="ManufacturingWeekOfMonth" />
       <xsd:enumeration value="ManufacturingWeekOfQuarter" />
       <xsd:enumeration value="ManufacturingWeekOfYear" />
       <xsd:enumeration value="ManufacturingYears" />
       <xsd:enumeration value="Minutes" />
       <xsd:enumeration value="Months" />
       <xsd:enumeration value="MonthOfHalfYear" />
       <xsd:enumeration value="MonthOfQuarter" />
       <xsd:enumeration value="MonthOfTrimester" />
       <xsd:enumeration value="MonthOfYear" />
       <xsd:enumeration value="OrganizationalUnit" />
       <xsd:enumeration value="OrgTitle" />
       <xsd:enumeration value="PercentOwnership" />
       <xsd:enumeration value="PercentVoteRight" />
       <xsd:enumeration value="Person" />
       <xsd:enumeration value="PersonContact" />
       <xsd:enumeration value="PersonDemographic" />
       <xsd:enumeration value="PersonFirstName" />
       <xsd:enumeration value="PersonFullName" />
       <xsd:enumeration value="PersonLastName" />
       <xsd:enumeration value="PersonMiddleName" />
       <xsd:enumeration value="PhysicalColor" />
       <xsd:enumeration value="PhysicalDensity" />
       <xsd:enumeration value="PhysicalDepth" />
       <xsd:enumeration value="PhysicalHeight" />
       <xsd:enumeration value="PhysicalSize" />
       <xsd:enumeration value="PhysicalVolume" />
       <xsd:enumeration value="PhysicalWeight" />
       <xsd:enumeration value="PhysicalWidth" />
       <xsd:enumeration value="Point" />
       <xsd:enumeration value="PostalCode" />
       <xsd:enumeration value="Product" />
       <xsd:enumeration value="ProductBrand" />
       <xsd:enumeration value="ProductCategory" />
       <xsd:enumeration value="ProductGroup" />
       <xsd:enumeration value="ProductSKU" />
       <xsd:enumeration value="Project" />
       <xsd:enumeration value="ProjectCode" />
       <xsd:enumeration value="ProjectCompletion" />
       <xsd:enumeration value="ProjectEndDate" />
       <xsd:enumeration value="ProjectName" />
       <xsd:enumeration value="ProjectStartDate" />
       <xsd:enumeration value="Promotion" />
       <xsd:enumeration value="QtyRangeHigh" />
       <xsd:enumeration value="QtyRangeLow" />
       <xsd:enumeration value="Quantitative" />
       <xsd:enumeration value="Quarters" />
       <xsd:enumeration value="QuarterOfHalfYear" />
       <xsd:enumeration value="QuarterOfYear" />
       <xsd:enumeration value="Rate" />
       <xsd:enumeration value="RateType" />
       <xsd:enumeration value="Region" />
       <xsd:enumeration value="Regular" />
       <xsd:enumeration value="RelationToParent" />
       <xsd:enumeration value="ReportingDate" />
       <xsd:enumeration value="ReportingDayOfHalfYear" />
       <xsd:enumeration value="ReportingDayOfMonth" />
       <xsd:enumeration value="ReportingDayOfQuarter" />
       <xsd:enumeration value="ReportingDayOfTrimester" />
       <xsd:enumeration value="ReportingDayOfWeek" />
       <xsd:enumeration value="ReportingDayOfYear" />
       <xsd:enumeration value="ReportingHalfYears" />
       <xsd:enumeration value="ReportingHalfYearOfYear" />
       <xsd:enumeration value="ReportingMonths" />
       <xsd:enumeration value="ReportingMonthOfHalfYear" />
       <xsd:enumeration value="ReportingMonthOfQuarter" />
       <xsd:enumeration value="ReportingMonthOfTrimester" />
       <xsd:enumeration value="ReportingMonthOfYear" />
       <xsd:enumeration value="ReportingQuarters" />
       <xsd:enumeration value="ReportingQuarterOfHalfYear" />
       <xsd:enumeration value="ReportingQuarterOfYear" />
       <xsd:enumeration value="ReportingTrimesters" />
       <xsd:enumeration value="ReportingTrimesterOfYear" />
       <xsd:enumeration value="ReportingWeeks" />
       <xsd:enumeration value="ReportingWeekOfHalfYear" />
       <xsd:enumeration value="ReportingWeekOfMonth" />
       <xsd:enumeration value="ReportingWeekOfQuarter" />
       <xsd:enumeration value="ReportingWeekOfTrimester" />
       <xsd:enumeration value="ReportingWeekOfYear" />
       <xsd:enumeration value="ReportingYears" />
       <xsd:enumeration value="Representative" />
       <xsd:enumeration value="RowNumber" />
       <xsd:enumeration value="ScdEndDate" />
       <xsd:enumeration value="ScdOriginalID" />
       <xsd:enumeration value="ScdStartDate" />
       <xsd:enumeration value="ScdStatus" />
       <xsd:enumeration value="Scenario" />
       <xsd:enumeration value="Seconds" />
       <xsd:enumeration value="Sequence" />
       <xsd:enumeration value="ShortCaption" />
       <xsd:enumeration value="StateOrProvince" />
       <xsd:enumeration value="TenDay" />
       <xsd:enumeration value="TenDayOfHalfYear" />
       <xsd:enumeration value="TenDayOfMonth" />
       <xsd:enumeration value="TenDayOfQuarter" />
       <xsd:enumeration value="TenDayOfTrimester" />
       <xsd:enumeration value="TenDayOfYear" />
       <xsd:enumeration value="Trimesters" />
       <xsd:enumeration value="TrimesterOfYear" />
       <xsd:enumeration value="UndefinedTime" />
       <xsd:enumeration value="Utility" />
       <xsd:enumeration value="Version" />
       <xsd:enumeration value="WebHtml" />
       <xsd:enumeration value="WebMailAlias" />
       <xsd:enumeration value="WebUrl" />
       <xsd:enumeration value="WebXmlOrXsl" />
       <xsd:enumeration value="WeekOfYear" />
       <xsd:enumeration value="Weeks" />
       <xsd:enumeration value="WinterSummerSeason" />
       <xsd:enumeration value="Years" />
     </xsd:restriction>
   </xsd:simpleType>

Element

Read-Only

Default value

Description

Name

[Required]

The object name.

ID

Defaults to Name.

The object ID string.

Description

Empty

The object description.

Type

"Regular"

The type of the Attribute.

The values that are specified in the enumeration allow the tagging of a DimensionAttribute with a standard code. However, the codes do not carry a specific definition and can be used within organizations for any purpose. These codes do not change processing by the server.

If the value "RowNumber" is used for the Type element, the valuens attribute MUST be present.

Usage

"Regular"

An enumeration value that indicates whether the Attribute is a key, parent, or regular. If the usage of the attribute is as a key, the Usage element MUST be specified as "Key". Otherwise, the Usage element is optional and has a default value of "Regular".

Source

Empty

Source is of type Binding. However, one of the following types MUST be used:

AttributeBinding

UserDefinedGroupBinding

MeasureBinding

CalculatedMeasureBinding

CubeAttributeBinding

TimeAttributeBinding

EstimatedCount

Empty

The estimated number of distinct values of the attribute.

KeyColumns

[Required]

A collection of objects of type DataItem. Every attribute needs to have at least one KeyColumn collection that defines the KeyColumn(s) for this Attribute's data. The Source element within the DataItem MUST be one of the following types:

AttributeBinding

MeasureBinding

CalculatedMeasureBinding

CubeAttributeBinding

TimeAttributeBinding

RowNumberBinding

CubeDimensionBinding

ColumnBinding

RowBinding

InheritedBinding

ExpressionBinding

NameColumn

Defaults to KeyColumn (if non-composite) with WChar data type.

An object of type DataItem. Defines the column that will be used for the Names of Attribute members. The Source element within the DataItem MUST be one of the following types:

AttributeBinding

MeasureBinding

CalculatedMeasureBinding

CubeAttributeBinding

TimeAttributeBinding

RowNumberBinding

CubeDimensionBinding

ColumnBinding

RowBinding

InheritedBinding

ValueColumn

Defaults to NameColumn (if specified), or else KeyColumn (if non-composite)

An object of type DataItem. Defines the column that will be used for the Names of Attribute members. The Source element within the DataItem MUST be one of the following types:

AttributeBinding

MeasureBinding

CalculatedMeasureBinding

CubeAttributeBinding

TimeAttributeBinding

RowNumberBinding

CubeDimensionBinding

ColumnBinding

RowBinding

InheritedBinding

Translations

Empty

A collection of Translation objects.

AttributeRelationships

Empty

A collection of AttributeRelationship objects.

DiscretizationMethod

"None"

The discretization method that will be applied to the attribute.

DiscretizationBucketCount

Empty

The number of buckets in which to discretize.

RootMemberIf

"ParentIsBlankSelfOrMissing"

Defines the means of indicating the topmost members of a parent-child hierarchy. Applicable only if Usage = Parent. The enumeration values are as follows:

ParentIsBlankSelfOrMissing - Only members that meet one or more of the conditions described for ParentIsBlank, ParentIsSelf, or ParentIsMissing are treated as root members.

ParentIsBlank - Only members with a null, a zero, or an empty string in the key columns represented by the KeyColumns collection of DimensionAttribute are treated as root members.

ParentIsSelf - Only members with themselves as parents are treated as root members.

ParentIsMissing - Only members with parents that cannot be found are treated as root members.

OrderBy

"Name"

The column by which the attribute will be ordered.

DefaultMember

Empty

An MDX expression describing the Default Member.

OrderByAttributeID

Empty

The ID of another attribute by which to order this attribute (only allowed if OrderBy = AttributeKey or AttributeName).

SkippedLevelsColumn

Empty

An object of type DataItem that provides the details of a column that stores the number of skipped (empty) levels between each member and its parent. The Source element within the DataItem MUST be one of the following types:

ColumnBinding

AttributeBinding

NamingTemplate

Empty

A string that defines a template for how levels in a parent-child hierarchy are named.

Applicable only if Usage = Parent.

MembersWithData

"NonLeafDataVisible"

Used only by parent attributes to determine whether to display data members for nonleaf members in the parent attribute. Applicable only if Usage = Parent.

MembersWithDataCaption

Empty

Provides a template string that is used to create captions for system-generated data members. Applicable only if Usage = Parent.

NamingTemplateTranslations

Empty

Provides a template for naming levels of a parent-child hierarchy. Applicable only if Usage = Parent.

CustomRollupColumn

Empty

An object of type DataItem that defines the details of a column that provides a custom rollup formula. The Source element within the DataItem MUST be one of the following types:

ColumnBinding

AttributeBinding

CustomRollupPropertiesColumn

Empty

An object of type DataItem that defines the details of a column providing the property of the custom rollup. The Source element within the DataItem MUST be one of the following types:

ColumnBinding

AttributeBinding

UnaryOperatorColumn

Empty

An object of type DataItem that defines the details of a column that provides a unary operator. Applicable only if Usage = Parent. The Source element within the DataItem MUST be one of the following types:

ColumnBinding

AttributeBinding

AttributeHierarchyOrdered

True

When true, indicates that attribute hierarchies are ordered; otherwise, false.

MemberNamesUnique

False

When true, indicates that Member names are unique; otherwise, false.

IsAggregatable

True

When true, indicates that this Attribute is aggregatable; otherwise, false.

AttributeHierarchyEnabled

True

When true, indicates that an attribute hierarchy is enabled for this attribute; otherwise, false.

If the DimensionAttribute is used as a MeasureGroupAttribute with Type=Granularity, the AttributeHierarchyEnabled element MUST be set to True.

AttributeHierarchyOptimizedState

"FullyOptimized"

Indicates the type of optimization for this attribute hierarchy. The following values are allowed:

  • "FullyOptimized" – Indexes are built for the attribute hierarchy.

  • "NotOptimized" – Indexes are not built for the attribute hierarchy.

AttributeHierarchyVisible

True

When true, indicates that an attribute hierarchy is visible; otherwise, false.

AttributeHierarchyDisplayFolder

Empty

Indicates the name of the attribute hierarchy display folder.

KeyUniquenessGuarantee

False

When true, indicates that the relationship between the attribute key and its name, and the relationship to related attributes, is guaranteed to be valid; otherwise, false.

GroupingBehavior

"EncourageGrouping"

Indicates which type of GroupingBehavior will be applied to this Attribute.

InstanceSelection

"None"

Provides a hint to client applications to suggest how a list of items is to be displayed, based on the expected number of items in the list.

Annotations

Empty

A collection of Annotation objects.

ProcessingState

Yes

Represents the processing state of the attribute. For calculated columns, any of the five available enumeration values can appear. Attributes that are not calculated columns can have only the values Processed or Unprocessed.<70>

AttributeHierarchyProcessingState

Yes

Represents the processing state of the attribute.<71>

VisualizationProperties

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

ExtendedType

"None"

When a client needs to set the Type property of the DimensionAttribute to a value other than one of the enum values (for example, ABC) that is provided by DimensionAttributeTypeEnumType,<72> the client MUST first set the Type property of the DimensionAttribute to ExtendedType and then assign the value (ABC) to the ExtendedType property.<73>