Patent Document ID: 7818282
Application ID: 10884807

Base Claim:
1. A method for preparing multilingual reports at client sites, the client sites connected to a server and a data source of a database, the method comprising: receiving selection of a product locale from a plurality of locales at a client site, wherein the product locale defines a user interface appearance for a user interface, and wherein each of the client sites uses at least one of the plurality of locales; generating a report specification based on input received from the user interface, wherein the report specification is used to extract data from the data source of the database, and wherein the report specification provides a structure for a report produced from the report specification; receiving selection of a content locale from the plurality of locales at the client site; constructing a metadata model having run-time parameters, wherein the run-time parameters include a session parameter that is based on the content locale, and wherein the metadata model includes model objects representing the data source of the database; building a query using the report specification and the metadata model, wherein the query includes at least one data access statement having one or more expressions that determine one or more tables to use for substitution into the one or more expressions, wherein each of the one or more tables maps session parameters to values, and wherein at least one of the one or more tables comprises a parameter map defining an entire expression; substituting one or more values into the one or more expressions based on the session parameter and the one or more tables to generate a resultant query, wherein the session parameter determines an appropriate entry in each of the one or more tables; extracting content locale-specific data from the data source of the database using the resultant query; and preparing a report using the extracted content locale-specific data, wherein the content locale defines an appearance and a format for content within the report.

---

Claim 4:
4. The method of claim 1 , wherein the run-time parameters are updated by a lookup on a coded row table.