Jump to content

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

Natasha DiCocco

Recommended Posts

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

Link to comment
Share on other sites

Hello Natasha,

The best way to limit data would be to use a date range expression as you said. These date range parameters can be inputs to the on-demand query and limit the amount of data that is fetched.


Alternatively if you want to retrieve only the Top N rows evertime the on-demand query is fired then edit the information link SQL to add the keyword for the same.


eg: For sql server - select Top 10 from emp where empno > 10


For Oracle - select * from emp where empno> 10 and rownum < 100

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...