Abstract: A method, a system and a storage medium for preparing multilingual reports at client sites. The client sites are connected to a server and a data source. Each of the client sites may use a different locale. A product locale is selected at the client site for defining a user interface appearance. After a report specification is generated, a content locale is selected at the client site, which defines an appearance and a format of a report. A metadata model with run-time parameters is then constructed. The run-time parameters include mapping rules for the content locale. The run-time parameters are updated based on the content locale. A query is built using the report specification and the metadata model. Data appropriate to the individual content locale is then extracted from the same data source using the query.

Abstract: The invention enhances business intelligence systems by allowing both report authors and consumers (users of reports) operating in their individual choice of interface language to have full access to content (data) in that language, or in any one of a number of languages. This functionality is provided by the inclusion of at least two locales. The invention provides for defining locale mappings, mapping a locale from an unsupported locale to supported locale, defaulting to a valid locale for users with incomplete or invalid locale specifications, and for specifying object names, descriptions, and tips in multiple languages.