Previous Page | Next Page

SAS Namespace Types


Subclass of Feature



PROC OLAP and SAS OLAP Cube Studio enable a user to define a formula for the dimension of a cube. This formula results in the creation of a calculated member or named set. In SAS 9.2, the GlobalFormula metadata type was used to store the formula that created the calculated member or named set. The GlobalFormula metadata type did not accommodate the formula to be associated with the Dimension, Hierarchy, or Level to which it belongs. Therefore, in SAS 9.3, the GlobalFormula metadata type was elevated to an abstract type, and the CalculatedMember and NamedSet metadata types were introduced. The new metadata types are used in cubes that have a UsageVersion of 5.0 or higher. The CONVERT option of PROC OLAP can be used to convert a 4.0 cube to a 5.0 cube. A 4.0 cube is also converted to a 5.0 cube by SAS OLAP Cube Studio when a shared dimension is added to the 4.0 cube. For more information, see CalculatedMember and NamedSet.

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.


Name Description Type Length
Expression The formula.   String V1000
GlobalFormulaRole Valid values are CalculatedMember or NamedSet.   String 60  
UniqueName The fully qualified unique name for the global formula.   String 1000  

Inherited Attributes
Name, Id, Desc, MetadataCreated, MetadataUpdated, ChangeState, IsHidden, LockedBy, PublicType, UsageVersion


= 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

Partner: Formulas

0 to 1 The list of cubes that contain this global formula. 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, 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

     Type:  String V1000

The formula.

     Type:  String 60  

Valid values are CalculatedMember or NamedSet.

     Type:  String 1000  

The fully qualified unique name for the global formula.

Association Details

     Cardinality:   0 to 1
     Partner:  Formulas

The list of cubes that contain this global formula. 

Associated Types:

Previous Page | Next Page | Top of Page