Text box prompt and slicer set

[Corrigon]

Hi gurus, I am writing a report based on a cube.

I need to slice a report by a large number of members (50+)of the Item hierarchy. The user wants to be able to copy and paste a list of Item Codes from MS Excel into the prompt, and have the resulting crosstab only return the values for the Items selected.

I think this is possible using a mandatory Multi-Line Text Box Prompt to populate a slicer set expression within a prompt macro, similar to this:

#promptmany('Products', 'memberuniquename','', 'set(','',')')#

Copying and pasting into the Mulit-Line text prompt works fine. However, when I run the report, I get a parsing error:

QE-DEF-0261 QFWP - Parsing text: set(PRODUCT-NUM-1;PRODUCT-NUM-2;PRODUCT-NUM-3...) etc.

It looks to my inexperienced eye like I need to use the #sb macro to add square brackets to each of the prompted Items and get rid of the semi-colons, but I'm not sure where to put it in the expression. Or am I going about this completely the wrong way?

Can anyone suggest a solution to this problem?

Thanks in advance,
Dave