Pass Performancepoint dashboard filter in Cube based report RRS feed

  • Question

  • i have cube based report in that report i have passed the performancepoint dashboard filter as member unique name for year. the report is working and functional. but when i passed the "all year" to the report the dirllthrough report links are disable on the sharepoint page. thats why i need to pass the year formula in the report. so please advise me how to pass dashboard year filter as formula in cube based report.

    Thank you.

    Saturday, June 9, 2012 7:29 AM

All replies

  • you might need to decode the year formula in case the report is SSRS


    Sunday, June 10, 2012 10:10 PM
  • Please provide more information like

    Which report are you working with PPS Analytic reports or SSRS reports?

    If SSRS how are you building your report MDX or SQL.

    Run a SQL profiler trace on Anaysis services to verify how the 'all years' parameter is passed. And report how you would like it to be.


    Monday, June 11, 2012 4:49 PM