none
Filter and Scorecards RRS feed

  • Question

  •  

    My problem is about link the filters with report (Excel Services).

     

    I create a filter with MDX Code to show me members that I want and I want that if I select member A, I want report A to display, and if I select member B, i want report B to display. (In the same zone of dashboard)

     

    Could u help me?

     

    Thanks!

    Wednesday, January 23, 2008 11:35 AM

Answers

  • The PPS dashboard filters are set up to pass the member to a single report view in Excel Services. Can you create one report and than pass the member into it and display the member appropriate view?  If not, I think you would have to create a custom report view that allowed you to control which report was rendering based off of which filter.

    Thanks,

    Alyson

     

    Wednesday, January 23, 2008 3:29 PM
  • Drag and drop the the reports to the same zone in the dashboard.

    Link the filter to each of the reports using Display condition.

    for the link for report A check in member A

    and member B for report B

     

    This should work

     

    Friday, January 25, 2008 9:39 AM

All replies

  • The PPS dashboard filters are set up to pass the member to a single report view in Excel Services. Can you create one report and than pass the member into it and display the member appropriate view?  If not, I think you would have to create a custom report view that allowed you to control which report was rendering based off of which filter.

    Thanks,

    Alyson

     

    Wednesday, January 23, 2008 3:29 PM
  • Drag and drop the the reports to the same zone in the dashboard.

    Link the filter to each of the reports using Display condition.

    for the link for report A check in member A

    and member B for report B

     

    This should work

     

    Friday, January 25, 2008 9:39 AM