Hi,

I have a member of time dimension Time.[year].[1997].[Q1].[1]. I want
to find out a member that fits same time next Quarter which will be
Time.[year].[1997].[Q2].[4] i.e first month of next quarter. I tried
using lead, next member.

Can any one tell another way arround for this as the above donot work
much successfully as i need a generic way to move to the next time like
an year ahead or a quarter ahead. I tried VBA!DateDiff and VBA!DATEADD
but could not find much success.

How about: ParallelPeriod([Time].[Quarter], -1)


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

You may also want to consider using the Cousins function which was
devised for this purpose and will work with any dimension type instead
of just Time. As in...

Cousin([Time].[1997].[Q1].[1],[Time].[1997].[Q2])

Which would return...

[Time].[1997].[Q2].[4]