We have SQL Server 2008, and use Targit as a reporting front end. We need a very simple type of report, with years across columns, and months/days on rows, with the values in the intersection. Like this:
2008 2009 2010
Sep1 1 2 3
Sep2 4 5 6
Sep3 7 8 9
We have a date table, which contains date ID, year, month, day, as numeric and as text, and descriptive texts as well. Like this:
20100901;"Sep 1 2010";2010;9;"Sep";1;901;"Sep 1"
(20100901 is the primary key, which is included in the table with the values)
Now, our developer insists that it is impossible to do a crosstab thing on that in Analysis Services. He says we then have to create a second table containing only months and days. That sounds insane to me. Then we would have to create a new table every
time someone wants to view it differently; years/quarters, quarters/months, years/season, etc. That is madness to me. Surely there is a way to achieve such a simple crosstab??
View Complete Post