Format string on dimension attributes SSAS

• joakim.fenno

  Say Hey Kid

  Points: 704

  More actions

  November 27, 2013 at 3:45 am

  #301704

  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

• m.pinto

  SSC Rookie

  Points: 40

  More actions

  January 31, 2014 at 4:55 am

  #1684994

  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