space
Previous Page | Next Page

SAS Namespace Types

Hierarchy


Subclass of PrimaryType


Overview

An arrangement of members of a dimension into levels that are based on parent-child relationships. Members of a hierarchy are arranged from more general to more specific. For example, in a Time dimension, a hierarchy might consist of the members Year, Quarter, Month, and Day. In a Geography dimension, a hierarchy might consist of the members Country, State or Province, and City. More than one hierarchy can be defined for a dimension. Each hierarchy provides a navigational path that enables users to drill down to increasing levels of detail. See also: Level.

Security Inheritance and Enforcement Rules

The following is a list of associations that are used to determine if this object should inherit access controls from another object (inheritance) or if the association is allowed for the object (enforcement). For more information about inheritance and enforcement rules, see the SAS 9.2 Intelligence Platform: Security Administration Guide.

Attributes

Name Description Type Length
AllMember This is the member at the highest level of a rollup in the hierarchy.   String 64  
Cardinality The number of levels in the hierarchy.   double  
DefaultMember The default member for the hierarchy.   String 64  
UniqueName The unique name for this hierarchy.   String 256  

Inherited Attributes
Name Id Desc MetadataCreated MetadataUpdated ChangeState  LockedBy  PublicType  UsageVersion 

Associations

= indicates the resident side of an association, or where the association is persisted for cross-repository associations. If no resident side is indicated, this association may not cross repository boundaries.

Name Cardinality Description Associated Types
Cubes

Partner: Hierarchies

0 to * The list of cubes that support this hierarchy.  Cube
Levels

Partner: Hierarchies

0 to * The list of levels that comprise this hierarchy.  Level
OLAPProperties

Partner: Hierarchies

0 to * The list of OLAP properties for this hierarchy.  OLAPProperty
OwningDimension

Partner: Hierarchies

1 to 1 The dimension that contains this hierarchy.   Dimension
SharedDimension
RootHierarchyLevel

Partner: AssociatedHierarchy

0 to 1 The root level for this hierarchy.  HierarchyLevel

Inherited Associations
AccessControls/Objects , Changes/Objects , CustomAssociations/OwningObject , Documents/Objects , Extensions/OwningObject , ExternalIdentities/OwningObject , Groups/Members , Implementors/ImplementedObjects , Keywords/Objects , LocalizedAttributes/AssociatedLocalizedObject , Notes/Objects , PrimaryPropertyGroup/AssociatedObject , Prompts/PromptEnabledObject , Properties/AssociatedObject , PropertySets/OwningObject , ReferencedObjects/AssociatedObjects , ResponsibleParties/Objects , SourceTransformations/TransformationSources , SpecSourceTransformations/SourceSpecifications , SpecTargetTransformations/TargetSpecifications , TargetTransformations/TransformationTargets , Timestamps/Objects , Trees/Members , TSObjectNamespace/TSObjects , UsedByPrototypes/UsingPrototype , UsingPrototype/UsedByPrototypes , Variables/AssociatedObject 

Attribute Details

AllMember
     Type:  String 64  

This is the member at the highest level of a rollup in the hierarchy.

Cardinality
     Type:  double  

The number of levels in the hierarchy.

DefaultMember
     Type:  String 64  

The default member for the hierarchy.

UniqueName
     Type:  String 256  

The unique name for this hierarchy.

Association Details

Cubes
     Cardinality:   0 to *
     Partner:   Hierarchies

The list of cubes that support this hierarchy. 

Associated Types:
Cube

Levels
     Cardinality:   0 to *
     Partner:   Hierarchies

The list of levels that comprise this hierarchy. 

Associated Types:
Level

OLAPProperties
     Cardinality:   0 to *
     Partner:   Hierarchies

The list of OLAP properties for this hierarchy. 

Associated Types:
OLAPProperty

OwningDimension
     Cardinality:   1 to 1
     Partner:   Hierarchies

The dimension that contains this hierarchy.  

Associated Types:
Dimension   SharedDimension

RootHierarchyLevel
     Cardinality:   0 to 1
     Partner:   AssociatedHierarchy

The root level for this hierarchy. 

Associated Types:
HierarchyLevel


space
Previous Page | Next Page | Top of Page