space
Previous Page | Next Page

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.

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

Previous Page | Next Page | Top of Page