dbTalk Databases Forums  

Survey Cube Problem Multiple Choice question

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Survey Cube Problem Multiple Choice question in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sam
 
Posts: n/a

Default Survey Cube Problem Multiple Choice question - 04-21-2006 , 02:46 PM






problem!!!!

below is one of the question from the Survey:

which color you like? (select all that apply)
Red
Green
Blue
.... and so on 20 more


I have fact table

PanelFact
----------------
PanelID (PK)
Age
Gender
Race


Do i have to create One Dimension for each color ? If not How i can
show these option to user? If yes How can i show user just one option
Color and then they click on it and they see all the color? I d'not
want user to just see all the color as each dimension.

any help would be appericated!!!

Thanks
Sam


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.