Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Help with MDX for Report - ParallelPeriod

1 view
Skip to first unread message

Bill Goodwin

unread,
Dec 13, 2009, 11:22:09 AM12/13/09
to
Hi

I have been asked if I can generate a report of sales for a specified week
which has to include a column for each day of the same period last year
(week).

I have got this far with Reporting Services, and on reading, it appears that
I need to include the ParallelPeriod.
I have used the AdventureWorks 2008 Analysis Services Sample cube.

-- MDX Generated by Reporting Services

SELECT NON EMPTY { [Measures].[Internet Sales Amount] } ON COLUMNS, NON
EMPTY { ([Product].[Product Categories].[Subcategory].ALLMEMBERS *
[Date].[Calendar Weeks].[Date].ALLMEMBERS * [Date].[Day of Week].[Day of
Week].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS FROM ( SELECT ( STRTOSET(@DateCalendarWeeks, CONSTRAINED) ) ON
COLUMNS FROM [Adventure Works]) CELL PROPERTIES VALUE, BACK_COLOR,
FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

I have been experimenting, but I just get error after error. Also, how
can I add another parameter for end date? This would be for another report.

Can anyone help please.

Many thanks
Bill


0 new messages