![]() Previous |
![]() Next |
In most cases, you refer to the value of a dimension by specifying the value following the conventions for the data type of the value. For example, assume that you have a TEXT
dimension named geog
. You can add the value "World" to the dimension by issuing the following statement.
MAINTAIN geog ADD 'World'
Note, however, that when you use a TEXT
dimension value in a numeric expression or compare values in a non-numeric dimension, Oracle OLAP uses the INTEGER
position number of the value in the array (as based on the default status list) rather than the value itself.
Special considerations apply to specifying the values of composites and concat dimensions.