Tuesday, March 20, 2012

Current Lanaguage in connection?

Hi.

I have a SQL Server Analysis Services Connection in Reporting Services. But my problem is that I need to allways have the same language on dataset values. Since I have multiple languages in my olap it all depends on the language setting on the invidual computer what language the new dataset values will become. Since the developers have diffrent language settings the datasets can get really ugly. I would prefere to have english on dataset values under development. But only on the dataset becouse our reports support more then one language.

I found a Current Language property under the connection setting that might be what I'm looking for? But I get error message becouse from format no mather what format I try. I have tryed stuff like, en, en-US, english, en-english and many more but havnt managed to find one that works yet.

Do anyone know what format the Current Language expect? And do anyone know if it would solve my proble, or if there are som other way to solve my problem?

Thanks!

I'm not familiar with Current Language, but the Locale Identifier property of the AS connection string expects a LCID. I used this a while back for dynamic languages (see http://blogs.msdn.com/bwelcker/archive/2005/07/03/435130.aspx) If this doesn't work, you could try posting over at the SSAS forum.|||

Thanks Brian.

The Locale Identifier was exactly what I was looking for! The only reason I asked about the Current Language was becouse it was the only advanced parameter I found that might have somthing to do with language. But when adding Locale Identifier directly to the string it worked perfectly!

Thanks again.

No comments:

Post a Comment