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 |
|
zambo2013
Starting Member
1 Post |
 Posted - 2009-10-16 : 17:53:37
|
| I am using SSAS 2005. Time dimension is having following attribues. TimeKey -> Business Date -> Month -> Quarter -> YearI have defined the attribute relationships in the same way and made them rigid. Everything is working fine except year. Quarter breaks correctly into Months. Months into Dates. But when I bring Year, data is not organized correctly. 2009 expands only expands into Q3 and it shows all months of Q3 of all years not just 2009.2008 does not show anything and likewise.It is showing fours quarter into four years only once and under that quarter it is showing months of that quarter for all the years.Can someone please tell me where is the problem.ThanksChris |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-10-23 : 15:40:56
|
| can you show us some sample data of time dimension?<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
Quarters not rolling into Years correctly