Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LuckyJim
Starting Member
9 Posts |
 Posted - 2010-08-09 : 07:59:02
|
| Hi allIn 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 2010Q2 2004Q3 2009Q4 2007For 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 |
|
|
LuckyJim
Starting Member
9 Posts |
Posted - 2010-08-09 : 09:49:46
|
| Sorted - added a composite key |
 |
|
|
|
|
|
Calculated Column not display correctly