Friday, August 2, 2013

Dimension Attribute Properties

AttributeHierarchyDisplayFolder

This property is used to group attribute hierarchies into folders.

AttributeHierarchyEnabled

If this property set to true means that attribute can be used in user defined hierarchy. If it is false the attribute cannot be used in user defined hierarchy and cannot referenced in MDX statements.

AttributeHierarchyOptimizedState

If this property set to Fully Optimized, means analysis service builds the index for query performance.
Not optimized means indexes are not created for that attribute.

AttributeHierarchyVisible

This property determines wheter the attribute is visible to client application or not. 

DefaultMember

If the query belongs to hierarchy in a dimension the default members for an attributes are ignored. Otherwise default member setting will effect.
If  we did not set thedefault member and IsAggregatable Property set to true then All is the default member. If IsAggregatable Property set to false the default member is first member of the first visible level.

IsAggregatable

If this property set to true means the members of the attribute can be aggregated. Then will define ALL level having aggregated data. If this property set to false then default member property should be specified.




Dimension Design Best Practices

No comments:

Post a Comment