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
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.
Hi MF,
I'm using the Sales namespace within GO datawarehouse (query) sample.
I am filtering product to display associated orders.
Hi,
I suspect either leading or trailing blanks in the parameter. What happens if you modify the filter to
[product] = trim(?select product?)
MF.
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.
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.
Thanks for your help ! have a good sunday.