I need to group together year 2003 and earlier in the bucket 'Earlier years' and 2009 and later in a bucket called 'Later years'. Is there any simple way to handle that within a timedimension?I have a table MatchDate with the column MatchDate, MatchYear, MatchQtr, MatchMonth.
I solved the issue by using MatchYear as 'Earlier years' for years before 2004 and 'Later years' for years after 2008. The same for MatchQtr and MatchMonth.
In the properties for Year I changed Member Key Column to MatchYear. The same thing for Quatrer and Month.That solved my issue so the Time dimension looks like:
Earlier years
2004
2005
2006
2007
2008
Later years
Of cause then it's possible to drill down into the different years.sql
No comments:
Post a Comment