Get Free Trial
Get Free Trial

Can we put a cap or time limit on the query

Bill Hamill asked on July 29, 2019

We have a very large cube and we’re using your UI to allow the user to configure pivot table quite flexibly. We find that it’s possible to configure very long running and impractical queries (maybe accidentally). Is there a way to put a cap (e.g., maximum number of rows to return) or time limit on the query? Thanks for your help.

1 answer

Public
Ian Sadovy Flexmonster August 1, 2019

Hello Bill,
 
Thank you for the question.
Currently, there is no option to somehow load partial response or limit the query by time.
As a workaround, you can create a button for the user to stop loading the long report (clear() or setReport()).
Also, there are few events that can help you to track long queries: runningquery , querycomplete , queryerror
 
Hope it helps.
 
Regards,
Ian

Please login or Register to Submit Answer