Managing the Multilingual Feature

The Universal Data Model template can only load Field descriptions in one language.

By default the language is ENG.

At this time, only Sage X3 offers truly a multilingual environment.

Important

If the Universal Data Model is installed in Consolidation mode, i.e. more than one ERP is installed, the multilingual feature must be disabled.

To enable or disable this feature:

  1. In the Administration section , click on Global Variables in the left pane.
  2. Find the variable UDM_MULTILAN_FLAG and click on the pencil iconon the right to change its value.
  3. In the Script field, enter 0 or 1 to disable or enable the multilingual feature and click on Update.
Note

The value you set for this variable determines whether or not the languages that exist in the ATEXTRA table should be imported to the cubes for Sage X3 data sources.

In either case, Nectari will use the following Clause in the UDM Analytical Dimension cube to determine whether or not other languages are displayed.

WHERE ATEXTRA_0.LANGUE_0 = CASE WHEN @@UDM_MULTILAN_FLAG = 1 THEN ATEXTRA_0.LANGUE_0 ELSE @@UDM_LANG END

If you entered 0, only the language defined by its external code in the UDM_LANG variable will be imported.

If you entered 1, do as follows to enable the multilingual feature:

  1. In the Administration section , click on OLAP Manager in the left pane.
  2. Select the UDM Analytical Dimension cube and follow the instructions described in Building, Loading or Refreshing Cubes to refresh the cube.