Friday, November 5, 2010

MDX: Ordered versus Purchased Product by a Customer

WITH
 MEMBER Measures.SoldProducts AS
    DISTINCTCOUNT(
      NonEmpty
      (
        Descendants
        (
          [Product].[Product Categories]
         ,[Product].[Product Categories].[Product]
        )
       ,[Measures].[Internet Sales Amount]
      ))
    
SELECT
  {
  [Measures].[Internet Order Quantity],Measures.SoldProducts
  } ON 0
 ,filter( [Customer].[Customer].&[15536],Measures.SoldProducts>0) ON 1
FROM [Adventure Works]

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

LinkWithin

Related Posts with Thumbnails