$DEFAULT_LANGUAGE

The $DEFAULT_LANGUAGE property specifies that the dimension for which it is an attribute is the language dimension for the analytic workspace in which it is defined, and specifies the default language for a language dimension.

Note:

There can be only one language dimension in an analytic workspace and only that dimension can have a $DEFAULT_LANGUAGE property.

Syntax

Before you add or delete a $DEFAULT_LANGUAGE property to your language dimension, you must make that dimension the most recently defined or considered object (see DEFINE and CONSIDER). You add $DEFAULT_LANGUAGE property using a PROPERTY statement:

To add the property, issue the following statement.

PROPERTY '$DEFAULT_LANGUAGE' language
To delete the property, issue the following statement.

PROPERTY DELETE '$DEFAULT_LANGUAGE'

Arguments

language: A TEXT expression that is one of the values in your language dimension, or an empty string.

Notes

Working with Language Dimensions

A language dimension is a dimension that has a $DEFAULT_LANGUAGE property defined for it. There can only be one language dimension in an analytic workspace. Working with language dimensions involves:

Creating a Language Dimension
Working with Language Dimension Status

Creating a Language Dimension To create a language dimension, take the following steps:

Define a TEXT dimension using DEFINE DIMENSION.
Add the $DEFAULT_LANGUAGE property to the dimension thereby identifying the dimension as the language dimension in the analytic workspace.
Populate the dimension with the names of the languages you want to support. As language names, use valid values for NLS_LANGUAGE. (See "NLS Options".)

Working with Language Dimension Status When an analytic workspace with a language dimension is attached, Oracle OLAP initializes the status of the language dimension, as follows:

Oracle OLAP limits the language dimension to the value of the SESSION_NLS_LANGUAGE option if the language dimension contains that value.
When the language dimension's $DEFAULT_LANGUAGE property is empty or names a nonexistent value, Oracle OLAP limits the language dimension to the value of the language dimension to the first value in the dimension's default order.

By default, once initialized, the status of a language dimension cannot be changed. However, you can change this behavior by changing the value of the LOCK_LANGUAGE_DIMS option from TRUE to FALSE which changes the status of the language dimension to ALL and allows you to issue LIMIT statements against the dimension.

Exporting Language Dimensions

When exporting an analytic workspace using EXPORT (to EIF), Oracle OLAP takes the following steps to determine what values of the language dimension to export:

If the value of the LOCK_LANGUAGE_DIMS option is FALSE when an EXPORT statement executes, Oracle OLAP honors the current status of the language dimension and performs the export accordingly.
If the value of the LOCK_LANGUAGE_DIMS option is TRUE when an EXPORT statement executes, Oracle OLAP:
1. Changes the value of the LOCK_LANGUAGE_DIMS option to FALSE (thereby setting the status to ALL) before executing the EXPORT statement.
2. Executes the EXPORT statement. Oracle OLAP exports all of the values of the language dimension.
3. Changes the value of the LOCK_LANGUAGE_DIMS option to TRUE and resets the status of the language dimension according to the value of the SESSION_NLS_LANGUAGE option.