Custom Reports and Multiple Languages

Vision supports the creation of data cubes in English (United States) and English (International) languages if you purchase the Vision Multilingual module. A system administrator creates separate Vision data cubes for different languages.

When you create a custom report in Excel, you connect to the data cube with the language for the report. A Vision English International analysis database that contains the data cubes has _en-GB at the end of its name.

English International Language and Custom Reports in Excel

When you connect to the English International data cubes in Excel, you must perform an additional step so that the Vision dimensions, measures, and system labels display in the English International language in the Excel PivotTable Field List. You must add a locale identifier code to the connection string in the .odc file for each Project and General Ledger data cube. You need to complete this step only one time for each data cube.

Producing Reports in Both the English United States and English International Languages

If you want to produce the same report in both the English United States and English International languages, you can use one .xlsx Excel report file for both reports. However, if you have Vision system labels that are different for each language, any dimensions added to the report design that have a system label in their name are removed from the .xlsx file when you are connected to the English International language and open the report. In that scenario, you need to add the missing dimension back to the report, or you could create a separate .xlsx Excel report file for each language.

An example of different systems labels is to have “job” set up as the system label for WBS (work breakdown structure) 1 in the English United States Vision data base and “project” set up as the system label for WBS 1 in the English International Vision data base.