Documentation
icCube XMLA Properties
Here is the list of icCube XMLA properties along with their description.
icCube.loadProcessingThreadCount (read-only)
Maximum number of threads for LOAD (processing part) request evaluation (-1 means number of cores, 0 means sequential processing).
When set to true, cell value types are possibly considered as xsd:int instead of their native xsd:long type.
icCube.singleMdxExtraEvalQueueSize (read-only)
( deprecated : see mdxEvalConfiguration ) Maximum number of queued tasks for (single) MDX extra. request evaluation.
The maximum length of a string generated by the MDX .StrToXyz() function; generate an error when the size is exceeded.
icCube.mdxQueryCalcMemberCacheMode
Define the type of calculated member cache used during the processing of a MDX query (NONE, ALL, ON_DEMAND)
icCube.visualTotalsIntermediateMembers
This flag allows for controlling how not set intermediate members are handled in VisualTotals function.
Maximum number of tuples being cached during the processing of a cell of a MDX query
icCube.activeLoadCount (read-only)
Maximum number of active LOAD requests.
icCube.cleanerFileCount (read-only)
(Windows only) determines the maximum number of files being deleted during each run (-1 means no limit - all files available for deletion are tried).
Whether or not the axes are evaluated as if VisualTotals was used. Possible values are : VISUAL_TOTAL, NON_VISUAL_TOTAL.
Maximum number of tuples being cached during the processing of a MDX query
icCube.defaultFormatStringSyntax
icCube supports both Excel and JAVA FORMAT_STRING syntax : this property defines the default syntax to use.
icCube.loadReadingQueueSize (read-only)
Maximum number of queued tasks for LOAD (reading) request processing.
icCube.mdxQueryCalcMemberCacheMax
Maximum number of calculated members being cached during the processing of a MDX query.
icCube.loadProcessingQueueSize (read-only)
Maximum number of queued tasks for LOAD (processing) request processing.
icCube.mdxEvalFastNonEmptyAxis
Activate fast processing of NON EMPTY axes (defaulted to true).
Determines when MDX requests can be cached.
icCube.mdxEvalUnknownMemberError
When set to true, usage of unknown MDX entities is generating an error; otherwise a NULL value is used instead.
icCube.factsIndexFileBufferSize (read-only)
Index file buffer size.
icCube.calcMemberDefinedUniqueName
When true, the unique name of the calc. measure/member is the full name used for its declaration (i.e., not internally generated).
icCube.duplicatedSolveOrderError
When set to true, an error is generated when attempting to use calculated members with ambiguous SOLVE_ORDER definition.
icCube.activeMdxRequestCount (read-only)
( deprecated : see mdxEvalConfiguration ) Maximum number of active MDX requests.
When activated checks that axis and calculated members do not define a tuple with two members of the same hierarchy (as in SaaS).
Language/country identifier.
icCube.indexFileSize (read-only)
Index file size in 32 bits integer count ( 2 ^ N ).
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.
MDX request result cache size (MB).
icCube.factsColumnFileBufferSize (read-only)
Facts file buffer size.
icCube.cleanerDelay (read-only)
(Windows only) determines the delay in seconds between each run.
icCube.excelFixFilterHelperSet
When set to true, MDX queries are possibly modified on the fly to fixed wrong Excel pivot table queries.
When activated wraps each sub-select axis expression into a CompactSet function call.
icCube.loadReadingRowBatch (read-only)
Number of rows processed by each LOAD request READING task.
icCube.factFileSize (read-only)
Maximum size (byte) of fact files.
icCube.indexFileBufferSize (read-only)
Index file buffer size in 32 bits integer count ( 2 ^ N ).
icCube.singleMdxEvalThreadCount (read-only)
( deprecated : see mdxEvalConfiguration ) Maximum number of threads for (single) MDX request evaluation (-1 means number of cores, 0 means sequential processing).
Maximum number of table partitions (-1 means no limit); a few number of partitions is typically expected.
icCube.loadProcessingFactsMode (read-only)
Configuration that controls how the facts are built.
icCube.factFileBufferSize (read-only)
Buffer size (byte) of fact files.
icCube.factsColumnBufferSize (read-only)
Facts buffer size.
Activate fast processing when several [Measures] are specified on an axis (defaulted to true).
icCube.dimMemBufferSize (read-only)
Buffer size (byte) of in-memory dimension.
icCube.indexBufferSize (read-only)
Index buffer size in 32 bits integer count ( 2 ^ N ).
icCube.drillthroughDefaultMaxRows
Maximum number of rows returned by a DRILLTHROUGH statement when its MAXROWS is not specified.
icCube.olapEngineSimultaneousRequestCount (read-only)
Maximum number of simultaneous requests within the OLAP engine.
icCube.factsIndexFileSize (read-only)
Index file size (-1: unlimited size).
icCube.factsColumnFileSize (read-only)
Facts file size (-1: unlimited size).
icCube.cleanerActive (read-only)
(Windows only) facts file cleaner running in the background.
Maximum number of unresolved rows per facts table to keep in memory for processing during the next incremental load. If that maximum amount is reached an error is generated.
icCube.singleMdxEvalQueueSize (read-only)
( deprecated : see mdxEvalConfiguration ) Maximum number of queued tasks for (single) MDX request evaluation.
icCube.mdxEvalSetCalculatorMinSize
Minimum size of the set to activate fast set calculators in TopCount() like function.
This flag activates the MDX request result cache and its mode (OFF, MEMORY, FILE).
When set to true, MDX queries are possibly modified on the fly to fixed wrong Excel pivot table queries.
icCube.singleMdxExtraEvalThreadCount (read-only)
( deprecated : see mdxEvalConfiguration ) Maximum number of threads for (single) MDX extra. request evaluation (-1 means number of cores, 0 means sequential processing).
( deprecated : see mdxEvalConfiguration ) Maximum number of cell returned by a SELECT statement.
icCube.maxBufferSizeForCachingIterator (read-only)
Maximum number of tuples being cached in OLAP set iterators.
icCube.factMemBufferSize (read-only)
Buffer size (byte) of in-memory facts.
icCube.mdxEvalLambdaProcessingMode
Activate lambda processing options (defaulted to : SET_CALC | PARALLEL_AXIS).
icCube.factsIndexBufferSize (read-only)
Index buffer size.
icCube.calcMemberMaxEvaluationFrameStackSize
The maximum number of calculated member nested calls (i.e., calc-member of calc-member of ...); allows for preventing infinite loop.
icCube.loadReadingThreadCount (read-only)
Maximum number of threads for LOAD (reading part) request evaluation (-1 means number of cores, 0 means sequential processing).