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

[Natasha DiCocco]

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

[Sayali Patil]

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

[Natasha DiCocco]

Sayali, Is this another way to limit report user from accessing to much data using an On-Demand data table. On Spotfire server side, in configuration.xml file changes the below setting 1200 Reference Link: https://docs.tibco.com/pub/spotfire_server/7.6.1/doc/html/tsas_admin_hel...

[Sayali Patil]

Hi Natasha,

 

There is an existing enhancement reported requesting this ability in Spotfire-

 

https://ideas.tibco.com/ideas/TS-I-6264