difference between prompt page and prompt in filter

[konesens]

Hello,

When I try to filter through a prompt using detail filter ([product] = ?select product?) it doesn't work (no data)but If I do it through a prompt page using a value prompt then the result is correct.

Does anyone could explain why and maybe give recommendation on prompt page vs prompt in detail filters.

Thanks

[MFGF]

What kind of package are you using - relational or dimensional?

It's possible you have a prompt info details defined in your package which control how a defined prompt works - what are you filtering on and what is being displayed in the propmpt?

MF.

[konesens]

Hi MF,

I'm using the Sales namespace within GO datawarehouse (query) sample.

I am filtering product to display associated orders.

[MFGF]

Hi,

I suspect either leading or trailing blanks in the parameter. What happens if you modify the filter to

[product] = trim(?select product?)

MF.

[konesens]

Thanks MF,
Adding the trim fix the problem but now the prompt doesn't display the drop down list , I have to type the product name.

[MFGF]

Ok - so the issue is embedded blanks. It's probably as a result of the underlying data type of the Product item.

The simple answer is to add a prompt. This has many advantages, one of which is that you have absolute control of how and where the prompt appears.

Cheers!

MF.

[konesens]

Thanks for your help ! have a good sunday.