none
Tabular

    Question

  • Dose analysis services have to be in a tabular format to use Power Pivot?
    Saturday, August 24, 2013 5:47 PM

Answers

  • As Olaf helper says, Power Pivot (Desktop/Client version) has an in-memory engine built into it. you don't need Analysis services for that.

    Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )

    • Marked as answer by dbSlave65 Sunday, August 25, 2013 5:21 PM
    Sunday, August 25, 2013 5:07 PM
    Answerer

All replies

  • If you want to "upgrade" power pivot model to analysis services, then yes - it has to a tabular model.


    Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )

    Saturday, August 24, 2013 6:48 PM
    Answerer
  • Ok, I should rephrase my question. When Power Pivot runs is it running using analysis services engine or the memory on the client machine. Thank you for answering my first question.
    Saturday, August 24, 2013 8:29 PM
  • Hello,

    PowerPivot is already the in-memory engine running on client side, you don't any SSAS server for it.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Sunday, August 25, 2013 5:53 AM
    Answerer
  • As Olaf helper says, Power Pivot (Desktop/Client version) has an in-memory engine built into it. you don't need Analysis services for that.

    Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )

    • Marked as answer by dbSlave65 Sunday, August 25, 2013 5:21 PM
    Sunday, August 25, 2013 5:07 PM
    Answerer