How will changes to the QUERYRESULTLIMIT and QRYGOVEXECTIME affect the system's performance?
In our Essbase Cloud-based system, these parameters are currently set to 1 million cells and 30 seconds, respectively. When these limits are insufficient, which happens frequently, users create macros that run queries in a "rapid fire" mode. They break down the queries into smaller chunks that retrieve less than 1 million cells or take less than 30 seconds to execute. As a result, they obtain the required amount of data, but it adds extra effort to consolidate these chunks.
What will happen to the system if we increase the limits to, say, 2 million cells and 300 seconds? Will it take less time and resources to run one 2-million-cell query compared to two 1-million-cell queries, or to run ten 30-second queries instead of one 300-second query?