Tuesday, March 27, 2012

Customize dimension attributes in SSAS

I have a time dimension table with an integer column "Quarter". In the SSAS Dimension I would like to display this as "Q 1" etc. instead of just "1".

I could easily add a column in the root table, but would prefer to format the column in the SSAS dimension. Can't find a "Format" property for an attribute. Is there a way to do this?

The most simple way to do this is to add a named calculation(a new column) in the data source view for the dimension table.

Add this attribute to the dimension or use is as the name column for the quarter attribute/column.

Add: 'Q' + ' ' + Cast(Quarter as Char(1))

HTH

Thomas Ivarsson

|||if u have choosen "typical" time dimension in analysis services, u would get "Quarter" in the display.

No comments:

Post a Comment