how to use prompt to display a selected list of records?

[pikachu]

As the subject says, how do I do it? for example, I am using the following macro:

#prompt ( 'Campaign Name', 'string', '', '', '[Responses].[Campaigns].[NAME]')#

But in the list of Campaign Names that I want the user to pick, I only want NAME that has the string "RECON" in them. How do I implement it? Do I need to use a parameter map?

hope someone can help me out. thanks.

[mrcool]

Y dnt u try using like function in Query expression of [Responses].[Campaigns].[NAME]

[pikachu]

hi mrcool,

I've tried :

#prompt ( 'Campaign Name', 'string', '', '', '[Responses].[Campaigns].[NAME] like %RECON%')#

but it still doesn't filter.

Do i do this in FM or in Report Studio?

If I do this in Report Studio Data->Filters :
[Responses].[Campaigns].[NAME] like '%RECON%'

It says QE-DEF-0260 parsing error

Please help. Thanks!

[mrcool]

just in filter giv [Responses].[Campaigns].[NAME] like %RECON%'

This works

[MDXpressor]

just in filter giv [Responses].[Campaigns].[NAME] like %RECON%'

This works

If your DB is dying on the like statement, try a contains instead.