November 27, 2013 at 3:45 am
I have a SSAS multidim cube (2012) and I am trying to set format for some dimension attribute (for example percentage - I would like to display 0.12 as 12%).
I have tried with both dot and coma as decimal
I have tried with data types decimal, float and varchar/nvarchar
I have tried setting both the format string and format properties (both together and one at a time)
I have tried other format strings than "Percentage", both the ones that are included in SSAS and custom ones (##.## etc.)
It works for measure but I cant get it to work for any dimension attributes (I got 0.12 instead of 12%).
I know that excel translates all dimension attributes to strings but I don't get this to work in SSMS either.
Do anyone know if this is a bug in SSAS?
I have found a couple of posts like this one: http://www.ssas-info.com/forum/6-ssas-admindevelopers-lounge/2196-format-option-not-working-for-attribute
January 31, 2014 at 4:55 am
I found adding a \ before the currency symbol worked for me when I was trying to display amounts as currencies. You could try that and see if it works for you
Cheers
matt
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply