This topic has not yet been rated - Rate this topic

Dimension Data Type (ASSL)

SQL Server 2008

Defines a primitive data type that represents a database dimension.


<Dimension>
   <Name>...</Name>
   <ID>...</ID>
   <CreatedTimestamp>...</CreatedTimestamp>
   <LastSchemaUpdate>...</LastSchemaUpdate>
   <Description>...</Description>
   <Source>...</Source>
   <MiningModelID>...</MiningModelID>
   <Type>...</Type>
   <UnknownMember>...</UnknownMember>
   <MdxMissingMemberMode>...</MdxMissingMemberMode>
   <ErrorConfiguration>...</ErrorConfiguration>
   <StorageMode>...</StorageMode>
   <WriteEnabled>...</WriteEnabled>
   <ProcessingPriority>...</ProcessingPriority>
   <LastProcessed>...</LastProcessed>
   <DimensionPermissions>...</DimensionPermissions>
   <DependsOnDimensionID>...</DependsOnDimensionID>
   <Language>...</Language>
   <Collation>...</Collation>
   <UnknownMemberName>...</UnknownMemberName>
   <UnknownMemberTranslations>...</UnknownMemberTranslations>
   <State>...</State>
   <ProactiveCaching>...</ProactiveCaching>
   <ProcessingMode>...</ProcessingMode>
   <CurrentStorageMode>...</CurrentStorageMode>
   <Translations>...</Translations>
   <Attributes>...</Attributes>
   <AttributeAllMemberName>...</AttributeAllMemberName>
   <AttributeAllMemberTranslations>...</AttributeAllMemberTranslations>
   <Hierarchies>...</Hierarchies>
   <Annotations>...</Annotations>
</Dimension>

Data Type Characteristics

Characteristic	Description
Base data types	None
Derived data types	None

Data Type Relationships

Relationship	Element
Parent elements	None
Child elements	Annotations, AttributeAllMemberName, AttributeAllMemberTranslations, Attributes, Collation, CreatedTimestamp, CurrentStorageMode, DependsOnDimensionID, Description, DimensionPermissions, ErrorConfiguration, Hierarchies, ID, Language, LastProcessed, LastSchemaUpdate, MdxMissingMemberMode, MiningModelID, Name, ProactiveCaching, ProcessingMode, ProcessingPriority, Source, State, StorageMode, Translations, Type, UnknownMember, UnknownMemberName, UnknownMemberTranslations, WriteEnabled
Derived elements	Dimension

Remarks

The corresponding elements in the Analysis Management Objects (AMO) object model are Dimension, AggregationDimension, AggregationDesignDimension, CubeDimension, MeasureGroupDimension, and PerspectiveDimension.

Reference

Analysis Services Scripting Language XML Data Types (ASSL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD