How do I create an OLAP cube in Microsoft SQL 2000 Analysis service
which will generate the following types of data for a report

Here are the source tables (in SQL 2000)
Note: not all fields are listed

SURVE
--------
(PK) Survey_ID in
Survey_Name varchar(200

QUESTION
-----------
(PK) Question_ID in
Question_Name varchar(200

ANSWER
-----------
(PK) Answer_ID in
Answer_Choice_Text varchar(200
Answer_Value in

RESPONDENTS_ANSWER
--------------
(PK)Respondent_ID in
(PK)Question_ID in
(PK)Answer_ID in

I want to build reports which crosstab the count of respondent answer
against respondent answers of a different question

For example:
Question 1) Do you watch the NBA
-Yes
-N

Question 2) What is your favorite NBA Team
-Mav
-Laker
-King
-Spur

Here is the report I want to create via OLAP in SQL 2000 Analysis Services

What is your favorite team
Mavs Lakers Kings Spurs Tota
----- --- --- --- --- --
Do you Yes 5 5 5 5 2
watch NBA? No 10 2 1 2 1
----- --- --- --- --- --
Total 15 7 6 7 3

So far, I have my fact table as Respondent_Answers, and a dimensio
that includes: Survey/Questions/Answers. I need to somehow hav
another dimension which includes Survey/Questions/Answers which I ca
crosstab the actual Respondent_Values, or someting. Please help

The goal is to have the capability to crosstab any question vs an
other question. I'm looking for a solution to compare 2 stati
questions

Thanks
-Jonathan