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
Martin Schoombee
SSCoach
Points: 19116
More actions
July 2, 2015 at 12:59 pm
#1810039
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.