I'm currently working on a multi-lingual data warehouse project involving French and Dutch. I've already figured out that Mondrian Schema can be translated using properties files, I already got that part working.

Now, I also would like to internationalize the data: for example I have company_type_FR and company_type_NL in the DB and I'd like pentaho to pick the right field based on the locale. Is this possible? If yes, how?

Eternal gratitude will be yours ;-)