 |
|
| SAS Namespace Types |
Dimension
Subclass of Classifier
Subtypes
Overview
A group of closely related hierarchies. Hierarchies within a dimension typically represent different groupings of information that pertains to a single concept. For example, a Time dimension might consist of two hierarchies: (1) Year, Month, Date, and (2) Year, Week, Day. See also Hierarchy.
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.
- Cubes
Attributes
| Name | Description | Type | Length |
| Cardinality | The number of unique values for the dimension. | double | |
| DimensionType | The type of this dimension: STANDARD, MEASURES or TIME. | 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 dimension. | String | 256 |
Inherited Attributes
Name, Id, Desc, MetadataCreated,
MetadataUpdated,
ChangeState,
IsHidden,
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 |
| AssociatedOLAPSchema Partner: Dimensions | 0 to 1 | The OLAP schema that contains this dimension. | OLAPSchema |
| Cubes Partner: Dimensions | 0 to * | The list of cubes that include this dimension. | Cube |
| Hierarchies Partner: OwningDimension | 0 to * | The list of hierarchies for this dimension. | Hierarchy |
| Levels Partner: OwningDimension | 0 to * | The list of levels for this dimension. | Level |
| Measures Partner: OwningDimension | 0 to * | The measures in this dimension. | Measure CalculatedMeasure |
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,
SourceClassifierMaps/ClassifierSources,
SourceTransformations/TransformationSources,
SpecSourceTransformations/SourceSpecifications,
SpecTargetTransformations/TargetSpecifications,
TargetClassifierMaps/ClassifierTargets,
TargetTransformations/TransformationTargets,
Timestamps/Objects,
Trees/Members,
TSObjectNamespace/TSObjects,
UsedByPrototypes/UsingPrototype,
UsingPrototype/UsedByPrototypes,
Variables/AssociatedObject
Attribute Details
Cardinality
Type: doubleThe number of unique values for the dimension.
DimensionType
Type: String 32The type of this dimension: STANDARD, MEASURES or TIME.
SortOrder
Type: String 24This is an indication of the sort order of this column in this table. It can be ASCENDING, DESCENDING, ASCFORMATTED, DESFORMATTED, DSORDER.
UniqueName
Type: String 256The unique name for this dimension.
Association Details
AssociatedOLAPSchema
Cardinality: 0 to 1
Partner: Dimensions
The OLAP schema that contains this dimension.
Associated Types:
OLAPSchemaCubes
Cardinality: 0 to *
Partner: Dimensions
The list of cubes that include this dimension.
Associated Types:
CubeHierarchies
Cardinality: 0 to *
Partner: OwningDimension
The list of hierarchies for this dimension.
Associated Types:
HierarchyLevels
Cardinality: 0 to *
Partner: OwningDimension
The list of levels for this dimension.
Associated Types:
LevelMeasures
Cardinality: 0 to *
Partner: OwningDimension
The measures in this dimension.
Associated Types:
Measure, CalculatedMeasure
|
|
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.