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 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.

OwningDimension

Attributes

Name	Description	Type	Length
Cardinality	The number of members in this level.	int
LevelType	An enumeration of types of levels.	int
SASFormat	The SASFormat for this level.	String	32
SortOrder	This is an indication of the sort order of this column in this table. It can be ASCENDING, DESCENDING, ASCFORMATTED, DESFORMATTED, or DSORDER.	String	24
UniqueName	The unique name for this level.	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
Aggregations Partner: Levels	0 to *	The aggregations associated with this level.	Aggregation
Hierarchies Partner: Levels	0 to *	The list of hierarchies that include this level.	Hierarchy
HierarchyLevels Partner: AssociatedLevel	0 to *	The list of hierarchy levels that are 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 , 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
The SASFormat for this level.

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, or 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

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 that are 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