Survey Analysis in SSAS

• Jonathan Mallia

  SSCertifiable

  Points: 5192

  More actions

  April 27, 2012 at 3:12 am

  #146905

  Hello everyone,

  Given you already have a survey data model in place, with an SSAS cube in place, is it possible to create analysis such, for example, who are the persons who answered Yes in question 1, and answered No in question 5?

  Is it possible to create this type of analysis in SSAS?

  Thanks in advance!

  Jon

• Bill Anton

  SSCrazy

  Points: 2437

  More actions

  May 8, 2012 at 6:24 am

  #1484466

  Yes. Read this...

  http://www.sqlbi.com/articles/many2many/

  Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com