International Considerations (Analysis Services - Multidimensional Data)
Microsoft SQL Server Analysis Services supports the storage and manipulation of multilingual data and metadata. Features include national language and collation support for sorts and comparisons, translations for multilingual metadata support, and currency conversion functionality. Using the Analysis Services multilingual and multicultural features, you can do the following:
Define the language and collation support for Analysis Services instances and databases.
You can define the default language and Windows collation for an Analysis Services instance, as well as defining translations for the properties of Analysis Services databases.
To define the language and collation support for Analysis Services instances and databases:
Define language and collation support for objects in an Analysis Services database.
Translations for data and metadata can be defined on an Analysis Services instance so that client applications can receive Analysis Services objects in a specified language and collation.
To define and retrieve translated data and metadata:
Provide support for multiple currencies in an Analysis Services database.
Analysis Services provides currency conversion support by using specialized Multidimensional Expressions (MDX) scripts to convert measures containing currency data.
To provide support for multiple currencies in an Analysis Services database:
Describes how to specify default language and Windows collation for an Analysis Services instance, as well as how your choices affect data and metadata managed by Analysis Services.
Describes how to define translations for an Analysis Services database and objects contained by the database, as well as how Analysis Services resolves requests for translated data and metadata from client applications.
Describes how to define a currency conversion using the Business Intelligence Wizard.
Describes the common issues encountered by client applications when working with multilingual and multicultural data and metadata in Analysis Services.