Hi there!

I want to show the Sales of Quarter1 - Quarter3 from this year. This works
okay, but the problem is that i want the same Range of previous Year be
shown as [Sales PrevYear]. I know I have to use ParallelPeriod, but I don't
get any data for [Sales PrevYear]. Is there someone who can give me a hint?

My MDX looks like this:

with member [Time].[Filter] as 'sum([2004].[Q1]:[2004].[Q3])'
member [Measures].[Sales 2003] as '(parallelPeriod([Time].[Year], 1),
[Measures].[Sales])'
select
{[Measures].AllMembers} on columns,
{ [MyDimension].members} on rows
from MYCUBE
where ( [Time].[Filter])

The problem is that ParallelPeriod() won't work with
[Time].[Filter] as expected, because it is a calculated
[Time] member. Here is another approach, for Foodmart:

Member [Time].[Filter] as 'Sum([TimeSet])'
Member [Measures].[Sales 1997] as
'Sum([TimeSet],
(ParallelPeriod([Time].[Year]),
[Measures].[Warehouse Sales]))'
Select
{[Measures].[Warehouse Sales],
[Measures].[Sales 1997]} on columns,
{[Store].[Store State].members} on rows
from Warehouse
where ([Time].[Filter])

- Deepak