Can anyone suggest a way to limit data pulled from On-Demand data tables in an analysis file

We have a user that marks cells in order to pull data into an excel sheet for the purpose of data analysis his markings can cause the On-Demand data table query to last for hours.

I have attempted setting the configuration XML 'retrieve-timeout' unsuccessfully and have though of using a 'date range expression' to limit the data. But if anyone has done this before please advise.

Kind Regards
Natasha Di Cocco

(2) Answers