I have a a BI repository where all the dimension and measure names on the cube where named in Spanish (I am CostaRican, you see) but now the company I work for is planning on doing a demo to english-speaking customers and they've asked me if it is possible to "translate" all those names and descriptions to english, french or some other language, in a relatively easy way.

I must admit that I've been working with SQL Server for only about 6 months, so I'm not an expert.

I would greatly appreciate any help you could give me.