Urgent: getting next time level for a given member - 06-04-2005 , 04:43 AM
I have a member of time dimension Time.[year]..[Q1].. I want
to find out a member that fits same time next Quarter which will be
Time.[year]..[Q2]. 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.
Re: Urgent: getting next time level for a given member - 06-05-2005 , 06:26 PM
How about: ParallelPeriod([Time].[Quarter], -1)
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***
Re: Urgent: getting next time level for a given member - 06-06-2005 , 10:43 AM
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...
Which would return...