Hi All

I have the grain of fact table in this fashion

EncounterID PersonID QuestionID AnswerID
1 1000 Cigar Yes
1 1000 Cigarette Yes
1 1000 Pipe No
2 2000 Cigar Yes

I have created a member property for QuestionID
Now, I want to write a MDX which returns people who smoke cigar and
cigarette. If anyone can give me some idea, I really appreciate it.

thanks

Milind