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.
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 (
Also, there are few events that can help you to track long queries:
Hope it helps.