August 9, 2010 at 6:02 am
Hi all
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:
Q1 2010
Q2 2004
Q3 2009
Q4 2007
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 ?
TIA
August 9, 2010 at 7:21 am
THat's because Q1 2007 and Q1 2008 have the same key on the Quarter level. You should add the column holding the year value from your time table to the key of the quarter attribute.
August 9, 2010 at 7:32 am
Thanks for that but am a bit lost - where do I get the key of the Quarter attribute.
Please accept my apologies for being such a newb....
August 9, 2010 at 7:52 am
Thanks Dirk - sorted. Added a composite key on the qtr and year fields.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply