question

Hi there, I am going through the process now of looking into possible different structures for a survey and answer data warehouse. I've created the below cube (FactSurvey) and related dimensions (company, customer, employee, form, geography, reporting name, and date). Company is who commissioned the survey. Customer is the individual whose property is surveyed. Employee is the surveyor. Form is the specific survey form used. Reporting Name is the points surveyed. Each row in the FactSurvey table should be a point of fact on the survey, for example one question for Reporting Name might be 'Does the kitchen have a smoke detector?' and the ColumnValue would be either a 'Yes', or 'No'. My question is, having created this structure how can I create a measure on, for example, How many properties surveyed for XYZ company by ABC surveyor have a kitchen with a smoke detector'? Or is this not a suitable warehouse structure? TIA![alt text][1] [1]: /storage/temp/4540-dw-structure.jpg