|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
The LOCK_LANGUAGE_DIMS option specifies if the status of language dimension can be changed.
See also:"Working with Language Dimension Status", $DEFAULT_LANGUAGE property, SESSION_NLS_LANGUAGE option, and STATIC_SESSION_LANGUAGE option.
LOCK_LANGUAGE_DIMS= TRUE | FALSE
Specifies that Oracle OLAP returns an error if a LIMIT statement tries to limit the status of a language dimension.
When a program changes the value the LOCK_LANGUAGE_DIMS option from FALSE to TRUE, Oracle OLAP resets the status of the language dimension in any attached analytic workspace according to the value of the SESSION_NLS_LANGUAGE option.
Sets the status of the language dimension to ALL, and specifies that programs can modify the status of the language dimension using LIMIT.
When a program changes the value the LOCK_LANGUAGE_DIMS option from TRUE to FALSE, Oracle OLAP resets the status of the language dimension in any attached analytic workspace to ALL.
Example 5-48 Explicitly Limiting a Language Dimension
Assume that your analytic workspace contains a language dimension named
mylangs that has the following definition and values.
DEFINE MYLANGS DIMENSION TEXT PROPERTY '$DEFAULT_LANGUAGE' - 'AMERICAN' MYLANGS -------------- FRENCH AMERICAN
Assume also, as shown by the following report, that when you attach the analytic workspace that the status of
mylangs is American.
REPORT mylangs MYLANGS -------------- AMERICAN
As the following code illustrates, you can explicitly change the status of
mylangs to French using LIMIT if you first set the value of LOCK_LANGUAGE_DIMS to FALSE. You cannot use LIMIT against a language dimension when the value of LOCK_LANGUAGE_DIMS has its default value of TRUE.
" Try to LIMIT mylangs LIMIT mylangs to 'FRENCH' ORA-33558: The status or contents of the MYAW3!MYLANGS dimension cannot be changed while the LOCK_LANGUAGE_DIMS option is set to yes. " Got an error SHOW LOCK_LANGUAGE_DIMS TRUE " Got the error because LOCK_LANGUAGE_DIMS was TRUE "Change LOCK_LANGUAGE_DIMS to FALSE LOCK_LANGUAGE_DIMS = FALSE " Try to LIMIT mylangs again LIMIT mylangs TO 'FRENCH' " Verify if the LIMIT worked. It did REPORT mylangs MYLANGS -------------- FRENCH " Then relock the language LOCK_LANGUAGE_DIMS = TRUE