export Pivot Table to SSAS cube? RRS feed

  • Question

  • I have an Excel spreadsheet pivot table.

    Is there a way to export it to create a MDX or DAX cube, easily?

    -- IBM has jobs for USA employee to work oversea (India) and get their wages.

    Saturday, August 24, 2013 10:22 PM


  • Assuming that you have access to the Excel spreadsheet that was used to create the Excel PivotTable, I'd create a PowerPivot data model from that spreadsheet. http://www.microsoft.com/en-us/bi/powerpivot.aspx PowerPivot data models understand both DAX and MDX queries.

    HTH, Martin

    <a href="http://martinsbiblog.spaces.live.com" target="_blank">http://martinmason.wordpress.com</a>

    • Proposed as answer by Elvis Long Tuesday, August 27, 2013 11:12 AM
    • Marked as answer by Elvis Long Monday, September 2, 2013 1:40 AM
    Sunday, August 25, 2013 12:24 AM