space
Previous Page | Next Page

SAS Namespace Types

GlobalFormula


Subclass of Feature

Subtypes


Overview

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.

Attributes

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

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
AssociatedCube

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

Expression
     Type:  String V1000

The formula.

GlobalFormulaRole
     Type:  String 60  

Valid values are CalculatedMember or NamedSet.

UniqueName
     Type:  String 1000  

The fully qualified unique name for the global formula.

Association Details

AssociatedCube
     Cardinality:   0 to 1
     Partner:  Formulas

The list of cubes that contain this global formula. 

Associated Types:
Cube

Previous Page | Next Page | Top of Page