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