none
how to apply multiple named set filter RRS feed

  • Question

  • how to apply multiple named set filter ?

    I have two name set on cube. 

    Good products (contains some detail products)

    bad  products (contains some detail products)

    i wnat to have a filter containt two selected options .one is Good products one is bad products. so what do to ?

    thanks for reply.

    thanks in advance.


    • Edited by 曾新文 Friday, July 6, 2012 3:06 AM
    Friday, July 6, 2012 3:04 AM

Answers

All replies

  • we can referen with this article

    http://www.tcscblog.com/2010/11/24/performancepoint-dashboards-using-named-sets-as-a-filter/

    the main soulation is that

    set up a table to restore the name sets .

    when filter conection to the report by using display value not uniqune name.

    • Proposed as answer by Dan English Wednesday, July 11, 2012 2:16 AM
    • Marked as answer by 曾新文 Wednesday, July 11, 2012 7:39 AM
    Friday, July 6, 2012 7:08 AM
  • That would be one option, another would bet to setup a tabular data source with the values if the named sets already exist in the multidimensional source.  You could create an Excel file or a SQL database view that included the text name values of the sets as well and then simply reference that in the filter setup.

    Dan English's BI Blog

    Wednesday, July 11, 2012 2:16 AM
  • Yes ,I made a test against the two workaround。

    Wednesday, July 11, 2012 7:39 AM