var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Calculated Column not display correctly in SSAS Dimension
In a Time dimension I want to display the Quarters like this
'Q1 2007' instead of the 1,2,3,4 that are the data values.
I created a calculated column called CLDR_Quarter_Name in the DSV that looks like this
'Q' + CONVERT(CHAR(1),CLDR_QUARTER) + ' ' + CONVERT(NVARCHAR(4),CLDR_Year)
When I browse the data in the DSV it looks fine.
But when I try to use it as a 'NamedColumn' for the Quarters attribute it does not work.
When I browse the dimension the list of years appear but when I drill down
the Quarters all have the same names. So I get:
For every year. Just for info if I drill down the dates all make sense.
It just seems to be the naming of the Quarters that is screwy.
I am at a loss.
Anyone any ideas ?
sorted - needed a composite key