This discussion is archived
7 Replies Latest reply: Nov 20, 2012 7:21 AM by Robert Angel RSS

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

872653 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points