Home Forums Data Warehousing Strategies and Ideas modelling "questions" & "answers" dimensions where answer can be multiple choice or freetext RE: modelling "questions" & "answers" dimensions where answer can be multiple choice or freetext

  • How about using a "junk dimension" for the free text answers? Your answer dimension could contain the "Other" option, but if something was entered as free text you could still reference that from the fact...and defaulted when it wasn't used.