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:
Quote
#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:
QuoteQE-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