Filter for both SSAS and non-SSAS web parts RRS feed

  • Question

  • I have written a custom "geography" filter web part, which I can connect to another web part, such as a list view web part, and have the list filtered by the value passed (such as "East", "West", etc.)

    I have also written another "geography" filter web part that works with an Excel Services web part connected to a SQL Server Analysis Services (SSAS) cube.  It is similar to the previously mentioned "geography" filter web part, except that is passes the value as a MDX filter.

    These two filters work independently, but I want to have both the list view and Excel Services web parts on the same page, with one single filter web part connected to both of them.  But the filter needs to pass different things to each type of connection (simple string for the list view, MDX for the Excel Services web part).

    Is there a way to write the filter so it can pass the appropriate type of filter value to each web part?
    Saturday, May 2, 2009 1:29 AM