Home      Functions     Common Solutions      Contact     






MDX Functions:
 
MDX Functions

 
Common Solutions

Common Solutions
 
Resource Links

MDX Books
MDX Related Software
MDX Related Blogs
 
Other Links

Contact Us
 
Microsoft SQL Server Analysis Services Function Page
Function Name: ParallelPeriod
Category: Time
Description: The ParallelPeriod function returns a member from a prior period in the same relative position as a supplied member.
Syntax: PARALLELPERIOD( [«Level»[, «Numeric Expression»[, «Member»] ] ] )
Technet Link: MDX ParallelPeriod Function




The query below returns the member March 2003 which is at the supplied Month level (May 2003) and two prior periods (Fiscal.Month) from the supplied member of May 2003.
 

SELECT
      PARALLELPERIOD([Date].[Fiscal].[Month], 2, [Date].[Fiscal].[Month].[May 2003]) ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
The query below returns the member November 2002 which is at the supplied Month level (May 2003) and two prior periods (Fiscal Quarter) away from the supplied member of May 2003.
 

SELECT
      PARALLELPERIOD([Date].[Fiscal].[Fiscal Quarter], 2, [Date].[Fiscal].[Month].[May 2003]) ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
The query below returns the member Q3 CY 2001 which is at the supplied Calendar Quarter level (Q1 CY 2004) and three prior periods (Calendar Year) away from the supplied member of Q1 CY 2004.
 

SELECT
      PARALLELPERIOD([Date].[Calendar].[Calendar Year], 3, [Date].[Calendar].[Calendar Quarter].[Q1 CY 2004]) ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
 

 
Copyright 2008 by MDXpert.com.
 
Terms of Use                              Privacy Statement
 
Site Powered By - WinHost.Com