Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Modeling - survey questions with 4 alternatives

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Modeling - survey questions with 4 alternatives Empty Modeling - survey questions with 4 alternatives

Post  MarcelMessias 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

Back to top Go down

Modeling - survey questions with 4 alternatives Empty Re: Modeling - survey questions with 4 alternatives

Post  tinkureddy 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

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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