E
Elyo Ravuna
In order to use the "translations" feature of Sql Server Analysis Services
2008 we need to set the locale identifier of the OLEDB connection string.
However, it doesn't seem to be possible in Excel 2007.
Here are the steps to reproduce the problem.
1- Open Excel 2007
2- Data > From other sources > From Analysis Services
3- Select a server and a database (it doesn't matter which), click next,
click finish
4- Click properties, clear the "retrieve data and errors in the Office
display language" checkbox, go to the definition tab, add "Locale
Identifier=1055" to the end of the connection string.
5- Click ok twice.
7- You will see that the locale identifier is not taken into consideration.
8- Click Data > Properties, go to the definition tab, you will see that the
"locale identifier" you have just written is lost, it is missing from the
connection string.
How can we set the "locale identifier" of an analysis services connection
string in Excel 2007?
Best regards.
Elyo Ravuna
Avnet Technology Solutions - Turkey
2008 we need to set the locale identifier of the OLEDB connection string.
However, it doesn't seem to be possible in Excel 2007.
Here are the steps to reproduce the problem.
1- Open Excel 2007
2- Data > From other sources > From Analysis Services
3- Select a server and a database (it doesn't matter which), click next,
click finish
4- Click properties, clear the "retrieve data and errors in the Office
display language" checkbox, go to the definition tab, add "Locale
Identifier=1055" to the end of the connection string.
5- Click ok twice.
7- You will see that the locale identifier is not taken into consideration.
8- Click Data > Properties, go to the definition tab, you will see that the
"locale identifier" you have just written is lost, it is missing from the
connection string.
How can we set the "locale identifier" of an analysis services connection
string in Excel 2007?
Best regards.
Elyo Ravuna
Avnet Technology Solutions - Turkey