MicroStrategy ONE
Prompt Complexity
Each attribute element or hierarchy prompt requires an element request to be executed by Intelligence Server. The number of prompts used and the number of elements returned from the prompts determine how much load is placed on Intelligence Server. Report designers should take this into account when designing prompted reports.
In addition to limiting the number of elements returned from element requests (as described in Results Processing), you should make sure your element caches are being used effectively. For information on managing element caches, including instructions, see Element Caches.