Queries on large dimensions often have large resource requirements. However, these queries typically are sparse, meaning that the number of nonempty values returned is small compared to the size of the input query. For these large but sparse queries, we suggest using the following special MDX and Report Writer functions to help Essbase more efficiently use memory and processor resources. These functions optimize retrieval performance by attempting to handle only nonempty combinations.
Leaves() MDX function
NonEmptySubset() MDX function
MDX optimization properties: NONEMPTYMEMBER and NONEMPTYTUPLE
Leaves Report Writer Command
Generation or level specification in Descendants and Idescendants Report Writer commands (when used within Link command)