fbpx

icCube XMLA Properties

Here is the list of icCube XMLA properties along with their description.

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).

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).

icCube.mdxQueryCalcMemberCacheMax

Maximum number of calculated members being cached during the processing of a MDX query.

icCube.factsResolveMemberLruCacheSize (read-only)

Size of the LRU cache used to resolve members while processing the facts.

icCube.cleanerActive (read-only)

(Windows only) facts file cleaner running in the background.

icCube.calcMemberMaxEvaluationFrameStackSize

The maximum number of calculated member nested calls (i.e., calc-member of calc-member of ...); allows for preventing infinite loop.

icCube.resultCachePolicy

Determines when MDX requests can be cached.

icCube.defaultHierarchyAllLevelName

This property defines the default name of the hierarchy all level.

icCube.mdxEvalFastNonEmptyAxis

Activate fast processing of NON EMPTY axes (defaulted to true).

icCube.resultCacheSize

MDX request result cache size (MB).

icCube.duplicatedSolveOrderError

When set to true, an error is generated when attempting to use calculated members with ambiguous SOLVE_ORDER definition.

icCube.indexBufferSize (read-only)

Index buffer size in 32 bits integer count ( 2 ^ N ).

icCube.compactSetInSubSelect

When activated wraps each sub-select axis expression into a CompactSet function call.

icCube.loadReadingQueueSize (read-only)

Maximum number of queued tasks for LOAD (reading) request processing.

icCube.loadProcessingThreadCount (read-only)

Maximum number of threads for LOAD (processing part) request evaluation (-1 means number of cores, 0 means sequential processing).

icCube.pivotTableCellVectorFValueGviSize

This property defines the maximum number of vector items sent in the FORMATTED_VALUE of the pivot table cells (GVI).

icCube.excelFixDotMembers

When set to true, MDX queries are possibly modified on the fly to fixed wrong Excel pivot table queries.

icCube.loadProcessingQueueSize (read-only)

Maximum number of queued tasks for LOAD (processing) request processing.

icCube.maxTablePartitionCount

Maximum number of table partitions (-1 means no limit); a few number of partitions is typically expected.

icCube.factMemBufferSize (read-only)

Buffer size (byte) of in-memory facts.

icCube.factFileBufferSize (read-only)

Buffer size (byte) of fact files.

icCube.singleMdxExtraEvalQueueSize (read-only)

( deprecated : see mdxEvalConfiguration ) Maximum number of queued tasks for (single) MDX extra. request evaluation.

icCube.selectCellMaxCount

( deprecated : see mdxEvalConfiguration ) Maximum number of cell returned by a SELECT statement.

icCube.mdxQueryCacheMax

Maximum number of tuples being cached during the processing of a MDX query.

icCube.mdxEvalSetCalculatorMinSize

Minimum size of the set to activate fast set calculators in TopCount() like function.

icCube.maxBufferSizeForCachingIterator (read-only)

Maximum number of tuples being cached in MDX set iterators.

icCube.nonEmptyBehaviorSetupMode

Define how the calculated member NON EMPTY BEHAVIOR setup (MANUAL, AUTO).

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.factFileSize (read-only)

Maximum size (byte) of fact files.

icCube.loadProcessingFactsMode (read-only)

Configuration that controls how the facts are built.

icCube.drillthroughDefaultMaxRows

Maximum number of rows returned by a DRILLTHROUGH statement when its MAXROWS is not specified.

icCube.mdxEvalLambdaProcessingMode

Activate lambda processing options (defaulted to : SET_CALC | PARALLEL_AXIS).

icCube.activeLoadCount (read-only)

Maximum number of active LOAD requests.

icCube.mdxEvalMeasureVector

Activate fast processing when several [Measures] are specified on an axis (defaulted to true).

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.mdxQueryCellCacheMax

Maximum number of tuples being cached during the processing of a cell of a MDX query.

icCube.indexFileBufferSize (read-only)

Index file buffer size in 32 bits integer count ( 2 ^ N ).

icCube.singleMdxEvalQueueSize (read-only)

( deprecated : see mdxEvalConfiguration ) Maximum number of queued tasks for (single) MDX request evaluation.

icCube.loadReadingThreadCount (read-only)

Maximum number of threads for LOAD (reading part) request evaluation (-1 means number of cores, 0 means sequential processing).

icCube.factsColumnFileSize (read-only)

Facts file size (-1: unlimited size).

icCube.visualTotalsIntermediateMembers

This flag allows for controlling how not set intermediate members are handled in VisualTotals function.

icCube.loadReadingRowBatch (read-only)

Number of rows processed by each LOAD request READING task.

icCube.factsIndexFileSize (read-only)

Index file size (-1: unlimited size).

icCube.maxUnresolvedRowsCount

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.singleMdxEvalThreadCount (read-only)

( deprecated : see mdxEvalConfiguration ) Maximum number of threads for (single) MDX request evaluation (-1 means number of cores, 0 means sequential processing).

icCube.indexFileSize (read-only)

Index file size in 32 bits integer count ( 2 ^ N ).

icCube.cleanerDelay (read-only)

(Windows only) determines the delay in seconds between each run.

icCube.activeMdxRequestCount (read-only)

( deprecated : see mdxEvalConfiguration ) Maximum number of active MDX requests.

icCube.visualMode

Whether or not the axes are evaluated as if VisualTotals was used. Possible values are : VISUAL_TOTAL, NON_VISUAL_TOTAL.

icCube.factsColumnBufferSize (read-only)

Facts buffer size.

icCube.olapEngineSimultaneousRequestCount (read-only)

Maximum number of simultaneous requests within the MDX engine.

icCube.dimMemBufferSize (read-only)

Buffer size (byte) of in-memory dimension.

icCube.localeIdentifier

Language/country identifier.

icCube.toStrMaxSize

The maximum length of a string generated by the MDX .StrToXyz() function; generate an error when the size is exceeded.

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.mdxQueryCalcMemberCacheMode

Define the type of calculated member cache used during the processing of a MDX query (NONE, ALL, ON_DEMAND).

icCube.factsIndexBufferSize (read-only)

Index buffer size.

icCube.excelFixXsdLong

When set to true, cell value types are possibly considered as xsd:int instead of their native xsd:long type.

icCube.defaultFormatStringSyntax

icCube supports both Excel and JAVA FORMAT_STRING syntax : this property defines the default syntax to use.

icCube.resultCacheMode

This flag activates the MDX request result cache and its mode (OFF, MEMORY, FILE).

icCube.excelFixFilterHelperSet

When set to true, MDX queries are possibly modified on the fly to fixed wrong Excel pivot table queries.

icCube.factsColumnFileBufferSize (read-only)

Facts file buffer size.

icCube.dimensionalityCheck

When activated checks that axis and calculated members do not define a tuple with two members of the same hierarchy (as in SaaS).

icCube.defaultHierarchyAllMemberName

This property defines the default name of the hierarchy all member.