ssas2008, more design question. i'm having survey table, survey-answers, questions table , option table. option containts textual response posibilities specific questions. quite easy model. questions parent-child dimension.
but, have option query example give me responses people question b(and subquestions) have answered question option x.
i've created dupliated question/option dimension used filtering not cant nice relation ship between answers , filter.
this structure http://www.dewildeeend.be/images/harry/capture.png
any suggestion appreciated
that picture doesnt dw me.
try combining tables single answer dw fact table, make dimension tables desire:
response dimension, hieararchy
people dimension
and
answer fact
Comments
Post a Comment