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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.