![]() Previous |
![]() Next |
The MAINTAIN command with the RENAME keyword changes the spelling of one or more dimension values. You cannot use RENAME keyword with a composite or with dimensions of type INTEGER, DAY, WEEK, MONTH, QUARTER, or YEAR.
Note: You can also issue a MAINTAIN RENAME statement for a surrogate dimension that has a Maintain trigger. In this case, Oracle OLAP only executes the Maintain trigger program; no other action occurs. See "Trigger Programs" for more information for more information. Issuing a MAINTAIN statement for a surrogate dimension that does not have a Maintain trigger, returns an error. |
Syntax
MAINTAIN dimension RENAME {value new-value}...
Parameters
A non-concat dimension of type TEXT or ID that is already defined in an attached analytic workspace and whose values are to be renamed. You cannot specify a dimension of type INTEGER, DAY, WEEK, MONTH, QUARTER, or YEAR.
Specifies an existing dimension value to be renamed. You can specify a dimension value, a character expression whose value is a dimension value, or an INTEGER
expression whose value represents the position of a dimension value.
A text constant or a TEXT or ID expression that is the new spelling for the dimension value.
Examples
Renaming Values of a TEXT Dimension
This statement changes the spelling of the cities Chic
and Bost
to Chicago
and Boston
.
MAINTAIN city RENAME 'Chic' 'Chicago' 'Bost' 'Boston'
In this example you use the TEXT variable textvar
to change the second city to Atlanta
.
textvar = 'Atlanta' MAINTAIN city RENAME 2 textvar