We are currently on 8.2.02M and working on a new page within Page Designer. This page has four multi-select filters that are linked to four charts within the page. Each of the charts have drilldowns that pass these four filters down to the next level. When the filters are _FOC_NULL ("All Values") or a single value, everything works as expected. If the user selects multiple values for a filter, the drilldown becomes broken when trying to pass these multiple values (ex. LOCATION='STRING1' OR 'STRING2' OR 'STRING3'). Has anyone else ran into this issue or know a simple solution on how to pass multi-select parameters through drilldowns? Any help would be greatly appreciated.

This message has been edited. Last edited by: mk_ia_usr,

Can you show us the WHERE tests in one of the charts? It sounds like you have a single select where test. A single select where would look something like this:

  
WHERE VENDOR EQ &VENDOR.(<0000000008,0000000008>, <0000000020,0000000020> |FORMAT=A12V).VENDOR:.QUOTEDSTRING;

And a multi select would look like this:

  
WHERE VENDOR EQ &VENDOR.(OR(<0000000008,0000000008>, <0000000020,0000000020> |FORMAT=A12V)).VENDOR:.;

You may have to add ".QUOTEDSTRING" after you parameter's name in the drill down call such as this

     FOCEXEC=IBFS:/WFC/Repository/Folder/fexName.fex ( \
       PARAM1=&PARAM1.QUOTEDSTRING \
       PARAM2=&PARAM2.QUOTEDSTRING ),
     TARGET='_blank',

quote:

Originally posted by MartinY:
You may have to add ".QUOTEDSTRING" after you parameter's name in the drill down call such as this

     FOCEXEC=IBFS:/WFC/Repository/Folder/fexName.fex ( \
       PARAM1=&PARAM1.QUOTEDSTRING \
       PARAM2=&PARAM2.QUOTEDSTRING ),
     TARGET='_blank',

Martin, this worked perfectly. Once I updated the drilldowns to use .QUOTEDSTRING, the multi-select parameters from the Page Designer page, were passed correctly all the way through the drill down. Thank you!!

Babak - For the record, I did have a multi-select WHERE statement within the chart. Thank you for the response.
WHERE ITEM EQ &ITEM_.(OR(FIND ITEM IN TABLE |FORMAT=A100V)).Item:.;

Our pleasure to have been able to help.

Please edit your first post, then into the subject add [SOLVED] at the beginning.