Natasha DiCocco Posted February 6, 2019 Share Posted February 6, 2019 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 More sharing options...
Sayali Patil Posted February 8, 2019 Share Posted February 8, 2019 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 More sharing options...
Natasha DiCocco Posted February 8, 2019 Author Share Posted February 8, 2019 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... Link to comment Share on other sites More sharing options...
Sayali Patil Posted February 8, 2019 Share Posted February 8, 2019 Hi Natasha, There is an existing enhancement reported requesting this ability in Spotfire- https://ideas.tibco.com/ideas/TS-I-6264 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now