SAS Namespace Types

Hierarchy

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.

OwningDimension

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

Top of Page