SAS Namespace Types

Aggregation

Overview

A summary of detail data that is stored with or referred to by a Cube. Aggregations support rapid and efficient answers to business questions. Developers are discouraged from creating or consuming Cube metadata directly with the SAS Open Metadata Interface. Instead, Cubes should be defined by using either SAS OLAP Cube Studio or PROC OLAP. For more information, see the documentation for SAS OLAP Cube Studio and PROC OLAP.

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.

OwningCube

Attributes

Name	Description	Type	Length
Nway	Set to true, this attribute indicates the aggregation is the NWAY aggregation for the cube. The default is false.	int
Type	This describes the persistence mechanism for the aggregation. Valid values are: MOLAP, ROLAP.	String	40

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
AggregationTables Partner: Aggregations	0 to *	The tables that contain columns used in the aggregations.	PhysicalTable WorkTable
Levels Partner: Aggregations	0 to *	The levels associated with this aggregation.	Level
OwningCube Partner: Aggregations	1 to 1	The cube associated with this aggregation.	Cube

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

Nway
Type: int
Set to true, this attribute indicates the aggregation is the NWAY aggregation for the cube. The default is false.

Type
Type: String 40
This describes the persistence mechanism for the aggregation. Valid values are: MOLAP, ROLAP.

Association Details

AggregationTables
     Cardinality: 0 to *
     Partner: Aggregations

The tables that contain columns used in the aggregations.

Associated Types:
PhysicalTable, WorkTable

Levels
     Cardinality: 0 to *
     Partner: Aggregations

The levels associated with this aggregation.

Associated Types:
Level

OwningCube
     Cardinality: 1 to 1
     Partner: Aggregations

The cube associated with this aggregation.

Associated Types:
Cube

Top of Page