Hi all,
Value propmt is taking more than 10min to display values.
what should I do ?
Thanks,
Rajesh.
Check associated prompt query. It is probably extremely slow for whatever reason. And with the scarce information you provide we have no clue
There are properties in FM to control prompt behavior. Look in the user guide.
Changing to a type in prompt instead of a value prompt might work for your case?
Are you filtering on a column in a fact table that is very large? Is there a smaller dimension table containing these values? If so perhaps the display item reference and use item reference properties might help you.
As Blom mentioned, more information in your posts will likely give you better responses.