Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Building a datawarehouse star schema
Thanks Blom0344 I have actually created two fact tables. One containing only numeric data (and monetory). And the other having only descriptive answers. (Note that both the fact tables have composite keys, and then the "answer" field itself) When I built the cube, there was no problem... -
Building a datawarehouse star schema
I have a requirement to build a design to incorporate data from a Global census. There are a series of questions to which responses are given by respondents in different countries. The answers to these questions can be numeric (or monetory) as well as descriptive. I have come up with a...
