space
Previous Page | Next Page

SAS Namespace Types

Aggregation


Subclass of PrimaryType


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 is a list of associations which 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.

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  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
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 that contains this aggregation.  Cube

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 , 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 that contains this aggregation. 

Associated Types:
Cube


space
Previous Page | Next Page | Top of Page