If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Substitute macro works only for the first finding

Started by pricter, 14 Nov 2011 10:05:45 AM

Previous topic - Next topic

pricter

Hi to all

I used the "substitute" macro to replace the cube that I use
for example

#
substitute
(
'Great Outdoor Sales 2',
'great_outdoor_sales_en',

promptmany('IMSP', 'memberuniquename', '[Great Outdoor Sales 2].[Products].[Products].[Product line]->:[PC].[@MEMBER].[991]', 'set(', '', ')')
)
#
The report works fine if I make a selection in the tree prompt but when I make two selections the "substitute" macro replaces only the first search string but not the second.

How should write the macro in order to substitute all the search strings and not only the first one?