locked
Export SSRS Report from PPS problem RRS feed

  • Question

  • 1. An SSRS report against SSAS, from a Reporting Services Integrated mode (2008R2) instance, having two parameters (the # of parameters doesn't matter, but there must be at least one).  The report data source is SSAS.

    2. A new Report object is created in PerformancePoint Dashboard Designer, pointing to the report created in step #1

    3. The Report is added to a PerformancePoint dashboard using Dashboard Designer

    4. The Dashboard has paramters that match the report, and the filters are connected to the report

    5. After the report is published, it behaves as expected--renders fine and the filters work fine

    6. When the report is exported to Excel using the command on the PerformancePoint web part's drop-down menu, the report ALWAYS renders with the data that would be correct if *no* parameters were passed in by the PerformancePoint filters.  So, for example, the report always displays numbers for "ALL", even after the filter is changed to "North America".

    #1 - #5 are all as expected.  #6 is unexpected.  It "feels" like when exporting the SSRS report type, PPS re-runs the report but doesn't pass in parameters to SSRS. 

    Note: Step #6 in SharePoint 2007 with PerformancePoint worked fine--it is broken in 2010.

    I have tested in three different SharePoint 2010 farms with the same result each time.

    Anyone else having this problem...or doing the same thing and having no problems?

    Here's a screen grab to illustrate the problem:

    http://www.robkerr.com/pics/ExportPPSSSRSWebPartToExcelProblem.png

     

    Sunday, March 6, 2011 12:00 AM

Answers

  • Hello Rob,

    This issue has been reported to our Product Group.  It will be fixed in an Upcoming PerformancePoint 2010 Cumulative Updated scheduled this summer. 

    Thanks
    Heidi Tr - MSFT

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, March 7, 2011 7:43 PM

All replies

  • Hello Rob,

    This issue has been reported to our Product Group.  It will be fixed in an Upcoming PerformancePoint 2010 Cumulative Updated scheduled this summer. 

    Thanks
    Heidi Tr - MSFT

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, March 7, 2011 7:43 PM
  • Hi,

    So, is there an update for this?

    All i can find is new ipad support....

    Thanks,

    Sagie

    Sunday, July 29, 2012 9:41 AM