You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!