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 CalculatedMember, Level.

Security Inheritance and Enforcement Rules

The following list of associations is used to determine if this object should inherit access controls from another object (inheritance), or if the association is allowed for the object (enforcement). An association will not be created unless the calling user is authorized to update one or both objects involved in the association. For more information about inheritance and enforcement rules, see the SAS 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, IsHidden, LockedBy, PublicType, SecTransctxt, 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
CalculatedMembers

Partner: OwningHierarchy

0 to * The calculated members for this hierarchy.  CalculatedMember
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
NamedSets

Partner: AssociatedHierarchies

0 to * The named sets for this hierarchy.  NamedSet
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, FavoritesContainers/Favorites, 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

CalculatedMembers
     Cardinality:   0 to *
     Partner:   OwningHierarchy

The calculated members for this hierarchy. 

Associated Types:
CalculatedMember

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

NamedSets
     Cardinality:   0 to *
     Partner:  AssociatedHierarchies

The named sets for this hierarchy. 

Associated Types:
NamedSet

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

Previous Page | Next Page | Top of Page