locked
PPS Report MDX statement RRS feed

  • Question

  •  

    it's possible to programatically change the MDX statement that underlies a given Performance Point report?
    Thursday, May 22, 2008 8:06 PM

Answers

  • Hi,

     

    I would first experiment with the use of filters within the dashboard itself to test the desired behaviour of the reports embedded within it - do you have to have a separate page or can you simply use the filters that are naturally supported by dashboards?

     

    I have not yet tried to pass parameters to a dashboard page from a separate custom page as you are looking to do. Although it may not be of too much use have a look at this post from the PPS team regarding interaction with dashboard filters for exporting PowerPoint decks or Excel spreadsheets from a deployed dashboard. The sample code may spark a few ideas.

     

    BTW - here's a link that pretty much contains all the PPS team blog code samples, again there may be some useful thought-proviking code contained in one of them http://blogs.msdn.com/performancepoint/search.aspx?q=code&p=1

     

    Cheers,

    Nick

    Saturday, May 24, 2008 12:36 AM

All replies

  • I assume you're talking about Analytic Chart and Grid reports is this correct? Can you give an example of what kind of behaviour you're trying to achieve?

     

    Cheers,

    Nick

     

    Thursday, May 22, 2008 9:07 PM
  • We are trying to set up a parameter in .net environment that will actually drive all the reports in PPS dashboard. So basically we will have a page where we can select time period and products using parameter, once we click apply it will take us to a PPS dashboard where all the reports are pre-filtered with our previous selection. I’m not sure if this is possible or not?

    Thanks for your help Nick.

     

    Friday, May 23, 2008 5:36 PM
  • Hi,

     

    I would first experiment with the use of filters within the dashboard itself to test the desired behaviour of the reports embedded within it - do you have to have a separate page or can you simply use the filters that are naturally supported by dashboards?

     

    I have not yet tried to pass parameters to a dashboard page from a separate custom page as you are looking to do. Although it may not be of too much use have a look at this post from the PPS team regarding interaction with dashboard filters for exporting PowerPoint decks or Excel spreadsheets from a deployed dashboard. The sample code may spark a few ideas.

     

    BTW - here's a link that pretty much contains all the PPS team blog code samples, again there may be some useful thought-proviking code contained in one of them http://blogs.msdn.com/performancepoint/search.aspx?q=code&p=1

     

    Cheers,

    Nick

    Saturday, May 24, 2008 12:36 AM