Hi all!
I have to use ParallelPeriod to generate this??

Sales
Sales in jan-2005 + feb-2005 25.000
Sales in jan-2004 + feb-2004 23.250

ParallelPeriod for a set of time members...

Thanks in advance,
Cristiano

==========================
Cristiano Moraes da Silva
cristiano (AT) dbccompany (DOT) com.br
Porto Alegre - RS - Brasil

Depends on how the set of Time Members is to be defined, and on how the
measures to be analyzed are aggregated. Here's an example from the
Foodmart Warehouse cube:

'([Measures].[Warehouse Sales],ParallelPeriod([Time].[Year]))'
Set [JanFeb98Set] as
'{[Time].[1998].[Q1].[1],[Time].[1998].[Q1].[2]}'
Member [Time].[JanFeb98Sum] as
'Sum([JanFeb98Set])', SOLVE_ORDER = 10

Select {[Measures].[Warehouse Sales],
[Measures].[PreviousSales]} on columns,
{Descendants([Time].[1998],[Time].[Month]),
[Time].[JanFeb98Sum]} on rows
from Warehouse

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thank you!
That's exactly what I needed.

Cristiano.

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote