Modeling - survey questions with 4 alternatives

View previous topic View next topic Go down

Modeling - survey questions with 4 alternatives

Post  MarcelMessias on Wed Jun 06, 2012 8:37 pm

hello, I am modeling a questionnaire with twelve questions. Each question has four alternatives are; A, B, C and D. After publication of the cube, need to analyze and find relationships among the alternatives. I thought that every question could be a dimension and a fact table would, however, I have problem because the metric is a counter. How can I make it, pass me a script. please.

MarcelMessias

Posts : 1
Join date : 2012-06-06

View user profile

Back to top Go down

Re: Modeling - survey questions with 4 alternatives

Post  tinkureddy on Fri Jun 08, 2012 2:18 pm

I think you should have a dimension for Questions and fact which will have your Alternatives as measures (hoping they are flags 1 or 0).

tinkureddy

Posts : 2
Join date : 2012-06-08

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum