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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.