locked
Create a PowerPivot sheet programatically RRS feed

  • Question

  • I have been looking for a way to create a PowerPivot sheet programatically without success.  The general idea would be for a user to select the set of dims and measures from the underlying data warehouse along with any filters on the fact data and then bring that into a PowerPivot sheet for download and further analysis.  Any ideas?
    Friday, July 22, 2011 3:04 PM

Answers

  • There was no API with the original release, and I haven't heard that it is included with the Denali release.

    --

    HTH
     
    Bob
    I have been looking for a way to create a PowerPivot sheet programatically without success.  The general idea would be for a user to select the set of dims and measures from the underlying data warehouse along with any filters on the fact data and then bring that into a PowerPivot sheet for download and further analysis.  Any ideas?
    Saturday, July 23, 2011 5:41 PM