SAS Namespace Types

Level

Subclass of Feature

Overview

An element of a dimension hierarchy. Levels describe the dimension from the highest (most summarized) level to the lowest (most detailed) level. For example, possible levels for a Geography dimension are Country, Region, State or Province, and City.

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
Cardinality	The number of members in this level.	int
LevelType	An enumeration of types of levels. From the OLEDB for OLAP spec. REGULAR 1 TIME 8 YEARS 16 HALF_YEARS 32 QUARTERS 64 MONTHS 128 WEEKS 256 DAYS 512 HOURS 1024 MINUTES 2048 SECONDS 4096	int
SASFormat	SASFormat	String	32
SortOrder	This is an indication of the sort order of this column in this table. It can be ASCENDING, DESCENDING, ASCFORMATTED, DESFORMATTED, DSORDER.	String	24
UniqueName	The unique name for this level.	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
Aggregations Partner: Levels	0 to *	The aggregations associated with this level.	Aggregation
CalculatedMembers Partner: AssociatedLevel	0 to *	The calculated members for this level.	CalculatedMember
Hierarchies Partner: Levels	0 to *	The list of hierarchies that include this level.	Hierarchy
HierarchyLevels Partner: AssociatedLevel	0 to *	The list of hierarchy levels associated with this level.	HierarchyLevel
OLAPProperties Partner: AssociatedLevel	0 to *	The list of OLAP properties for this level.	OLAPProperty
OwningDimension Partner: Levels	1 to 1	The dimension that includes this level.	Dimension SharedDimension

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, SourceFeatureMaps/FeatureSources, SourceTransformations/TransformationSources, SpecSourceTransformations/SourceSpecifications, SpecTargetTransformations/TargetSpecifications, TargetFeatureMaps/FeatureTargets, TargetTransformations/TransformationTargets, Timestamps/Objects, Trees/Members, TSObjectNamespace/TSObjects, UsedByPrototypes/UsingPrototype, UsingPrototype/UsedByPrototypes, Variables/AssociatedObject

Attribute Details

Cardinality
     Type: int
The number of members in this level.

LevelType
     Type: int
An enumeration of types of levels. From the OLEDB for OLAP spec. REGULAR 1 TIME 8 YEARS 16 HALF_YEARS 32 QUARTERS 64 MONTHS 128 WEEKS 256 DAYS 512 HOURS 1024 MINUTES 2048 SECONDS 4096

SASFormat
     Type: String 32
SASFormat

SortOrder
     Type: String 24
This is an indication of the sort order of this column in this table. It can be ASCENDING, DESCENDING, ASCFORMATTED, DESFORMATTED, DSORDER.

UniqueName
     Type: String 256
The unique name for this level.

Association Details

Aggregations
     Cardinality: 0 to *
     Partner: Levels

The aggregations associated with this level.

Associated Types:
Aggregation

CalculatedMembers
     Cardinality: 0 to *
     Partner: AssociatedLevel

The calculated members for this level.

Associated Types:
CalculatedMember

Hierarchies
     Cardinality: 0 to *
     Partner: Levels

The list of hierarchies that include this level.

Associated Types:
Hierarchy

HierarchyLevels
     Cardinality: 0 to *
     Partner: AssociatedLevel

The list of hierarchy levels associated with this level.

Associated Types:
HierarchyLevel

OLAPProperties
     Cardinality: 0 to *
     Partner: AssociatedLevel

The list of OLAP properties for this level.

Associated Types:
OLAPProperty

OwningDimension
     Cardinality: 1 to 1
     Partner: Levels

The dimension that includes this level.

Associated Types:
Dimension, SharedDimension

Top of Page