Multi Language Cubes
Say you need to build a cube for Germany, France, Spanish and UK users. Would it be better to a) Create 4 cube translations (well 3 actually, as 1 is a “default language”), or b) Building the cube on the fly and set the attribute & measure names in a specific language?
If a specific cube is for a specific country and that country only use one language (i.e. Germany, France, UK), and the cube is already built on-the-fly, then yes you can set the attribute & measure names in a specific language. Also, if some of the attributes & measures are not known in advance (as in, they are known only at run time), then yes, set the attribute & measure names at run time, possibly from a “translation table” stored in the database.