SAS Namespace Types |
Subclass of Feature
Subtypes
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.
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
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
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.
AssociatedCube
Cardinality: 0 to 1
Partner: Formulas
The list of cubes that contain this global formula.
Associated Types:
Cube
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.