Crosssell in cube? How?

hi guys, had users ask me other day , i'm not sure start...

 

we have dimension (product) has 1 many relationship our customer fact table.  in configuration, can see how many customers own each product.

 

what user requesting able see how many customers have different product combinations.  example, how many customers have product , b?  or a, b , c?

 

is there way in cube?

 

thanks!

 

data mining you're going want use probably. take @ , see if answers question:

http://forums.microsoft.com/msdn/showpost.aspx?postid=820872&siteid=1

 

if you've got data mining question, try data mining forum:

http://forums.microsoft.com/msdn/showforum.aspx?forumid=81&siteid=1

 

if want try doing mdx, following might trick:

 

select {} on 0,

intersect(

exists(

[customer].[customer].[customer].members

,([date].[calendar].[june 2004],[product].[category].[bikes])

,"internet sales"

)

,exists(

[customer].[customer].[customer].members

,([date].[calendar].[june 2004],[product].[category].[clothing])

,"internet sales"

)

)

on 1

from [adventure works]

 

there bunch of ways write that, way gets people bought bikes month, people bought clothing month, finds customers in both sets.

SQL Server  >  SQL Server Analysis Services