Problem Note 30705: "ERROR: The locale defined as the default in the dds must be included in the list of locales to import records for"
If you are importing data from Detail Data Store to the SAS® Financial Management Solutions Data Mart, you might receive the message:
ERROR: The <en> locale defined as the default in the dds must be included in the list of locales to import records for.
The problem occurs during import or export when the defined location/locale and language don't match.
SAS Financial Management uses data locales to give you a choice of languages for the names and descriptions of objects of the following types:
- Dimension members
- Hierarchies
- Dimensions
- Dimension types
- Rate types
- Models
Names and descriptions of these objects are visible if you are using the SAS Financial Management Add-In for Microsoft Excel. You can view reports and planning forms in different languages.
Each data locale consists of three components--a language, a country, and a variant. If you define two or more data locales and associate a set of names and descriptions with each data locale, then a user's desktop locale
(set in the Windows Control Panel) determines which set of names and descriptions are displayed. The defined data locales are ranked according to how well they match the desktop locale, as follows:
- Language, country, and variant all match.
- Language and country match, but variant does not match.
- Language matches but country and variant do not match.
The data locale that matches the desktop locale best is known as the current data locale. You define the desktop locale by selecting 'Regional and Language Options' from your operating system's Control Panel.
For each name or description, you will see the text from the highest ranking data locale that has text for that name or description. If there is no defined data locale that matches your desktop locale at all, then the text from the designated default data locale is displayed.
You can define SAS Financial Management data locales in two ways:
- In SAS Financial Management Studio:
- For SAS Financial Management 4.x: Select Edit > Data Locales from the menu in the SAS Financial Management Studio Dimensions workspace.
- For SAS Financial Management 5.x: Select Tools > Data Locales from the menu in the SAS Financial Management Studio Dimensions workspace.
This displays the Data Locales window, which enables you to create and edit data locales and to change the designated default data locale.
- By populating the CODE_LANGUAGE table in the Detail Data Store and running:
- For SAS Financial Management 4.x: the <Import Locales> job
- For SAS Financial Management 5.x: the <solnsvc_1200_import_locales> job
from SAS Data Integration Studio to load locale information from the Detail Data Store into the SAS Financial Management database.
In general, it is better to use the CODE_LANGUAGE table and the SAS Data Integration Studio job. A data locale must be defined in the Detail Data Store to enable you to load member and hierarchy names and descriptions for that data locale from the Detail Data Store.
More information about loading language codes and locale codes through the Detail Data Store, please refer to the
SAS Solutions Services: Data Administration Guide.
Operating System and Release Information
| SAS System | SAS Financial Management | Windows | | |
| Microsoft Windows 2000 Advanced Server | | |
| Microsoft Windows 2000 Datacenter Server | | |
| Microsoft Windows 2000 Server | | |
| Microsoft Windows 2000 Professional | | |
| Microsoft Windows Server 2003 Datacenter Edition | | |
| Microsoft Windows Server 2003 Enterprise Edition | | |
| Microsoft Windows Server 2003 Standard Edition | | |
| Microsoft Windows XP Professional | | |
| 64-bit Enabled AIX | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-03-22 10:11:29 |
| Date Created: | 2007-12-06 13:45:56 |