Weekly Report -
12-20-2004
, 02:17 PM
Hi everybody,
When a well-know MDX statement my outcome is:
Jan Wk 1 2004 / Jan Wk 2 2004 .... / Jan Wk 4 2004 /
Jan Wk 1 2003 / Jan Wk 2 2003 ....
Product 1
Product 2
....
Select
{Descendants([Date].[Month].[January, 2004], [Date].[Week], Self),
Descendants([Date].[Month].[January, 2003], [Date].[Week], Self)} on
columns,
{[Product].[Line].Members} on rows
From [Sales]
Where ([Measures].[Unit Count])
Note: The showed month is a dynamic parameter.
Now, I want to get the next weekly report:
Jan Wk 1 Jan Wk 2 ....
2004 2003 2004 2003 ...
Product 1
Product 2
.....
Is it possible? How can I do?
Thanks in advance,
Marco |