I would like to design a dimension as part of a cube to enable all survey results to be displayed in a single excel chart.
I have 10 questions each with answer choices (A, B, C, D, NO Response)
The excel chart would have a bar for each question, and each bar would be composed of 4 colors representing either A,B,C or D.
I can generate 10 dimensions (one for each question), but I can't get it to fit in the same chart. I would like to create one dimension encapsulating the entire survey..by possibly using attributes.
Is there a bettwer way to do this...using excel and as2005
Any help or advise would be appreciated!