 |
|
| 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. Beginning 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.
- AssociatedCube
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,
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 |
| 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 V1000The formula.
GlobalFormulaRole
Type: String 60Valid values are CalculatedMember or NamedSet.
UniqueName
Type: String 1000The 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
|
|
Copyright © SAS Institute Inc. All rights reserved.