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.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  SSRS Matrix - Time Dimension

Author  Topic  Yvett Starting Member 1 Post Posted - 2010-11-22 : 05:27:32 Hi, I've developed one ssrs report in "sql server 2005", but I stumbled across a problem with time dimensions. In my design (Matrix) I used assistance Assambly to compare weekday (Monday, 01.11.2010 vs. Monday, 02.11.2009) but, at the same time, I need to compare the whole Month (01.Nov. - 30.Nov.2010 vs. 01.Nov. - 30-Nov.2009). So a have: Last Year This Year Mon. 02.11.2009 Mon. 01.11.2010 Tues.03.11.2009 Tues.02.11.2010 Wed. 04.11.2009 Wed. 03.11.2010 …. … But, what I need: Last Year This Year Sun. 01.11.2009 NULL Mon. 02.11.2009 Mon. 01.11.2010 Tues 03.11.2009 Tues.02.11.2010 Wed. 04.11.2009 Wed. 03.11.2010 …. … Mon. 30.11.2009 Tues.30.11.2010 Does anyone have any ideas? Building MDX queries? or another idea? Thank you in advance. Yvett