cube design question--named set?

hello experts,

 

i'm new ssas 2005. i need following calculation , i'm wondering if possible in ssas 2005?

 

dinstinctcount (set a intersect set b)

 

set as:

select distinct student-id table cond1 , cond2 , cond3

set b as:

select distinct student-id table b cond1 , cond2

...

for now, have 2 tables in dsv both fact table , dimension table, student-terms and student-programs, have created measures distinctcount of student-id in these 2 tables. default thought create 2 named sets set , set b,do intersect , calcuate a measure somehow. however, couldn't create named set conditions following

 

existing([student terms].[student id].[student id].members, [student terms].[ftds].&[yes])

 

is there way create set conditions, set functions , count number afterwards?

 

could shed light me?

 

thanks lot in advance!!!

 

cherry-tree

sounds lot homework question me.

as hint, how many sets talking???   have set a, , set b.

draw picture showing cond's.

SQL Server  >  SQL Server Analysis Services