4 Replies Latest reply on Jun 21, 2011 7:26 AM by Ashley Tsang

    Transforming a Cube Data Structure to Relational

    Santiago Restrepo

      I am pulling data from a cube using "Microsoft Analysis Services". The issue is that the cube only has one fact (Value), so it is not very  flexible.


      Ideally, I would like to convert the data structure in Tableau, to make it look like Relational  Table (have multiple facts).

      Please look at the attached packaged workbook for more details.


      I could probably do it using an "if" calculation, but connecting to "Microsoft Analysis Services" does not allow me to do calculations using dimensions (and performance could also suffer).


      Is there a way to do this?