locked
Partioning! RRS feed

  • Question

  • Hi, how do you manage "partitioning" in PowerPivot, if that's possible? We have a data warehouse with hundreds of millions of rows of EPOS data partitioned by month (it stores a couple of years worth of data). Each day, we process just the most recent monthly partiton in Analysis Services.

    If we wanted to replace our traditional cube architecture and use PowerPivot workbooks accessed via Excel Services in Sharepoint 2010 instead, how can we just  refresh the last month's worth of data in a PP workbook, without refreshing the whole lot (years of data equating to hundreds of millions of rows)? Some way of appending, without refreshing the whole lot, would be really useful.


    Many thanks
    Wednesday, February 10, 2010 3:34 PM

Answers

  • Thanks, John, for that reply.
    • Marked as answer by Mardin Pena Friday, March 5, 2010 8:57 PM
    Thursday, February 11, 2010 9:57 AM

All replies

  • Hi Matt,

    PowerPivot doesn't have a concept of partitioning, as is the case with traditional Analysis Services. PowerPivot for Excel is an In Memory Business Intelligence that builds a data model in the memory space of Excel. PowerPivot for Excel is really designed more to allow the Information Worker to build models directly from heterogeneous data sets without the overhead of building an Enterprise level data model. As such, PowerPivot does not have the same rich functionality that you have using traditional Analysis Services.

    Regards,

    John Desch
    Wednesday, February 10, 2010 3:57 PM
  • Thanks, John, for that reply.
    • Marked as answer by Mardin Pena Friday, March 5, 2010 8:57 PM
    Thursday, February 11, 2010 9:57 AM