7 Replies Latest reply: Nov 20, 2012 9:21 AM by Robert Angel RSS

    Passing multiple values to FILTER...USING with Presentation Variable?

    872653
      Hi,

      We have a requirement to use a Presentation Variable in Analytics i.e. in FILTER...USING.

      There is a Dashboard Prompt which sends multiple values to a Presentation Variable.

      This Presentation Variable is used in FILTER...USING of one of the measures in the following way…
      FILTER("Measures"."SALES" USING ("Customer"."Customer Name" IN ('@{pv_custname}')) )
      The above condition is working fine if one value is selected in Dashboard Prompt but when multiple values are selected, these multiple values are treated as single value. i.e. "Customer"."Customer Name" = 'ORACLE, MICROSOFT' .


      Is it a bug? Is there any workaround for this?

      Thanks in advance.