Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Create a cube with a survey result. Pls help!

Status
Not open for further replies.

maxzikpi

MIS
Jan 20, 2014
3
0
0
US
How to Create a OLAP cube with a survey result. Where I need to calculate the number of 'yes' and 'no' answers of every distinct survey question.
Just a sample of 5 survey questions.
Pls I need it ASAP.
 
With only 5 questions and Yes/No answers, this might be better suited for an Access database or Excel pivot table. Or even a basic spreadsheet.

==================================
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright


 
well need to be able calculate it when the cube populate
 
First, you haven't identified what OLAP software you are using. Second, the best solution probably does not involve a cube, which is more suited for multi-dimensional numeric data. You have two dimensions; people and questions. This is a simple 2x2 table, not a cube.

==================================
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright


 
1- am using BID
2- I already have a cube with all this data fact table. and I just need to know how to calculate the measure or dimension to get a percentage of yes or no
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top