Localize your global Xcelsius dashboard

If your dashboard is intended for a global audience, you may need to be able to localize it. By localization, most people refer to the ability to translate at minimum the labels and headers of the dashboard, based on the user locale, language. BusinessObjects provides localization solutions for its reporting platform, most notably in the form of the Translation Manager tool which allows you to provide various translations for your universe objects that are automatically displayed based on the user locale in InfoView. Unfortunately, the translation manager does not apply to Xcelsius dashboards. To work around that, you can implement a simple data driven approach that combined the power of webi with a simple translation table for your dashboard meta data to deliver a localized global dashboard.

First, you will need to create a translations table that will contain your dashboard meta-date, the labels and headers you use. You will need at least three columns in the table, the label value, the locale you enter it in, and some value to identify the label in the dashboard (in this example, I used sort order)


Add this table to your universe. Now, create a webi report that includes the value column. To make sure the labels displayed are at the appropriate language, add a filter to your block to filter the rows where the locale is the same as the user preferred viewing locale. You can do that by creating a variable that checks for this condition, and then apply a block filter based on this variable.

Now, use LiveOffice to embed the report data in your dashboard and use the labels column for your dashboard labels. They will automatically filtered based on your user selected locale in InfoView and presented in the appropriate language.

This entry was posted in Xcelsius and tagged , , , , , , . Bookmark the permalink.

2 Responses to Localize your global Xcelsius dashboard

  1. as says:

    This is not working…

    what should be the refresh options for the object in xcelsius….. latest instance or from database?>

    • Ron Keler says:

      If you have multiple users from different regions who use different locale all accessing the same report, then you would want to make sure you refresh the report and not use a saved instance to assure each user locale is represented retrieved on demand

Comments are closed.