icCube XMLA Properties
Here is the list of icCube XMLA properties along with their description.
icCube.olapEngineSimultaneousRequestCount (read-only)
Maximum number of simultaneous requests within the OLAP engine.
icCube.activeMdxRequestCount (read-only)
Maximum number of active MDX requests.
icCube.singleMdxEvalThreadCount (read-only)
Maximum number of threads for (single) MDX request evaluation (-1 means number of cores, 0 means sequential processing).
icCube.singleMdxEvalQueueSize (read-only)
Maximum number of queued tasks for (single) MDX request evaluation.
icCube.maxBufferSizeForCachingIterator (read-only)
Maximum number of tuples being cached in OLAP set iterators.
icCube.duplicatedSolveOrderError
When set to true, an error is generated when attempting to use calculated members with ambiguous SOLVE_ORDER definition.
When set to true, MDX queries are possibly modified on the fly to fixed wrong Excel pivot table queries.
icCube.excelFixFilterHelperSet
When set to true, MDX queries are possibly modified on the fly to fixed wrong Excel pivot table queries.
icCube.calcMemberMaxEvaluationFrameStackSize
The maximum number of calculated member nested calls (i.e., calc-member of calc-member of ...); allows for preventing infinite loop.
icCube.functionMaxEvaluationFrameStackSize
The maximum number of function (i.e., WITH FUNCTION) nested calls (i.e., f() calling g() calling h() calling ...); allows for preventing infinite loop.
icCube.mdxEvalUnknownMemberError
When set to true, usage of unknown MDX entities is generating an error; otherwise a NULL value is used instead.
The maximum length of a string generated by the MDX .StrToXyz() function; generate an error when the size is exceeded.
Language/country identifier.
Whether or not the axes are evaluated as if VisualTotals was used. Possible values are : VISUAL_TOTAL, NON_VISUAL_TOTAL.
icCube.visualTotalsIntermediateMembers
This flag allows for controlling how not set intermediate members are handled in VisualTotals function.
This flag activates a tuple evaluation cache for each MDX request.
icCube.requestCacheAssertConsistency
Allows for troubleshooting cache behavior; do not activate in production as the potential speed benefit of the cache will be lost.
Sort of type of cache (ALL, CALC_MEMBER_ONLY)
Maximum number of tuples cached during the processing of an MDX request.
icCube.drillthroughDefaultMaxRows
Maximum number of rows returned by a DRILLTHROUGH statement when its MAXROWS is not specified.
When activated wraps each sub-select axis expression into a CompactSet function call.