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: Cousin
Category: Navigation
Description: The Cousin function returns a child member that has the same relative position to the parent as the supplied member.
Syntax: COUSIN( «Member1», «Member2» )
Technet Link: MDX Cousin Function




The query below returns the cousin of July 2003 for the Calendar Year 2004, which is July 2004.
 

SELECT
      COUSIN([Date].[Calendar].[Month].[July 2003], [Date].[Calendar].[CY 2004]) ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
This query returns the cousin of March 15, 2002 for the Fiscal Year 2003, which is March 15, 2003
 

SELECT
      COUSIN([Date].[Fiscal].[Date].[March 15, 2002], [Date].[Fiscal].[FY 2003]) ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
 

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