February 15, 2014 at 3:51 pm
Hi to all.
I have a cube SSAS 2008 R2 ..
In Calculation Tab i have a measure called i.e XYZ that is a number.
In the properties i choose FORMAT STRING --- standard (I am not interested in CURRENCY Format).
My problem is that when i browse this measure in SQL SERVER Management , it appears with good format.
Example if it contains 12345,10 it si showed as 12,345.00
SSAS was installed in US Language.
When i browse this measure in Excel 2010- Or Excel 2010 this measure appears not the same..
It appears 12345,10 without thousands separators...
I need to format manually inside Excel...
I work in Italy, so Excel it was installed in Italian Language.
I read that it is possibile use an useful properties called LANGUAGE ..
This property can be setted in each of calculated measure i need..
(Look this article to understand better what i am talking about..)
Using this property you can write something like this to comunicate to your client tool, Language you want to use...example LANGUAGE = 1033 it means United States and so on...
Do anyone know where can i find all lists of these possible values of LANGUAGE Properties ???
In my case i need LANGUAGE code for Europe or Italy...
Regards in advance...
February 16, 2014 at 9:50 am
Hi Steve.
Thanks a lot for your kind answer...
I will be test as soon as possibile...
Do you meet my same trouble ???
Regards.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply