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.

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

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

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


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