{.............vins bin...............}: MDX: Ordered versus Purchased Product by a Customer

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.

Subscribe to: Post Comments (Atom)