MDX Documentation

icCube MDX Errors

Here is the list of icCube MDX errors along with their description.

OLAP_NOT_AUTHORIZED (0x56c75d6e)

Raised when the evaluation of a MDX statement is not authorized.

OLAP_MDX_STATEMENT_UNEXPECTED (0xfbe1a8dd)

Raised when the evaluation of a MDX statement is not allowed in a given context.

OLAP_SELECT_EVAL_UNEXPECTED_ERROR (0x3d5b603c)

Raised when an internal error occurred during the processing of a SELECT statement.

OLAP_UNARY_OPERATOR_SYNTAX_ERROR (0x80375600)

Raised while attempting to use an operator with a non supported type (e.g., -TRUE).

OLAP_BINARY_OPERATOR_SYNTAX_ERROR (0xa9fc7816)

Raised while attempting to use an operator with a non supported type (e.g., 42 AND "hello").

OLAP_RANGE_OPERATOR_MEMBER_LEVEL_MISMATCH (0x37823bb2)

Raised when creating a range between members of different levels.

OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH (0xba1de074)

Raised when passing an argument of non expected type to the function.

OLAP_FUNCTION_ARGUMENT_MISSING (0xbc53ac78)

Raised when an expected function argument is missing.

OLAP_FUNCTION_ARGUMENT_NULL (0x6eb5ff27)

Raised when an expected non-null function argument is null or has been evaluated to null.

OLAP_FUNCTION_UNEXPECTED_ARGUMENT_COUNT (0x2c2abe1)

Raised when using more (or less) arguments then the function is expecting.

OLAP_FUNCTION_UNEXPECTED_ARGUMENT_COUNT_X (0x1f2b30ad)

Raised when using more (or less) arguments then the function is expecting.

OLAP_FUNCTION_EXPECT_MEMBERS_AT_SAME_LEVEL (0x4b4c3b78)

Raised when a set of member of different levels is passed as parameter.

OLAP_FUNCTION_DIMENSION_WITH_NO_HIERARCHY (0x8dcd3879)

It is more likely that current permissions have disabled access to all the hierarchies.

OLAP_FUNCTION_DIMENSION_WITH_MORE_THAN_ONE_HIERARCHY (0xe99f9503)

MDX names must contain the hierarchy name when the dimension is containing more than one hierarchy.

OLAP_CONST_FUNCTION_CALC_MEMBER_USAGE (0xafa07cc7)

Raised when a const function is accessing a calculated member.

OLAP_CONST_FUNCTION_NAMED_SET_USAGE (0x86b1e7a)

Raised when a const function is accessing a named set.

OLAP_CONST_FUNCTION_AS_NAMED_SET_USAGE (0x69a46a44)

Raised when a const function is accessing a named set (i.e., AS notation).

OLAP_USER_JAVA_FUNCTION_EVALUATION_GENERAL (0x3155d3c5)

Raised by a user defined function (i.e., plugin).

OLAP_CUBE_UNKNOWN (0x62d1e998)

Raised when attempting to use an unknown cube.

OLAP_CUBE_UNKNOWN_SET (0xd880a8e2)

Raised when attempting to use an unknown cube specified in a create set statement.

OLAP_CUBE_DYNAMIC_SET (0xb7eec8e8)

Raised when attempting to use a cube other than default in a dynamic set.

OLAP_DUPLICATED_NAMED_SET (0xe752c7d7)

Raised when declaring more than one named set with the same name.

OLAP_DUPLICATED_FUNCTION (0x95378892)

Raised when declaring more than one function with the same name.

OLAP_DUPLICATED_CALC_MEMBER (0x8133d496)

Raised when declaring more than one calculated member with the same name.

OLAP_CALC_MEMBER_STACK_OVERFLOW (0xf01878f6)

Raised when the evaluation of a calculated member/measure recurses too deeply (see icCube.calcMemberMaxEvaluationFrameStackSize XMLA property).

OLAP_FUNCTION_STACK_OVERFLOW (0xd37fee9)

Raised when the evaluation of a declared function (i.e., WITH FUNCTION) recurses too deeply (see icCube.functionMaxEvaluationFrameStackSize XMLA property).

OLAP_CALC_MEMBER_TYPE_MISMATCH (0x1116627b)

Raised when the evaluation of a calculated member has generated a value non expected by the [Measures] dimension (i.e., scalar value).

OLAP_CALC_MEMBER_MISSING_ENTITY (0xeb9799e)

Raised when attempting to register a calculated member (or measure) into an unknown entity (e.g., member, level, ...).

OLAP_CALC_MEMBER_ORPHAN (0xd68ec095)

Raised when attempting to register a calculated member into a level (depth > 0) without specifying any parent.

OLAP_CALC_MEMBER_LAST_LEVEL (0xd5cdd27d)

Raised when attempting to register a calculated member (or measure) into a member of the last level.

OLAP_CALC_MEMBER_ANCHOR_TYPE (0x6a8e559a)

Raised when attempting to register a calculated member (or measure) into an entity of unexpected type.

OLAP_CELL_FORMATTER_CREATION_ERROR (0xdf335e48)

Raised when the creation of a FORMAT_STRING formatter has generated an error.

OLAP_SLICER_AGGREGATION_MEASURES (0xf35f5e3d)

Raised when the slicer contains more than one Measures member as aggregating the values would make no sense.

OLAP_SLICER_AGGREGATION_CALC_MEMBERS (0xbe434eb3)

Raised when the slicer is defined as a set and contains calculated members.

OLAP_SLICER_SET_COMPLETION_UNSUPPORTED (0x588d9ed1)

Raised when the shape of the slicer set is not supported.

OLAP_SLICER_SET_CURRENT_MEMBER (0xa7066db1)

Raised when attempting to get the current member from the slicer when the slicer contains a set.

OLAP_SLICER_SET_REDUNDANT_TUPLE (0xcff82ad1)

Raised when defining duplicated tuples in the slicer as set.

OLAP_SLICER_NULL_EVAL (0xc4421623)

Raised when the slicer has been evaluated to a NULL member or an empty set.

OLAP_SLICER_AXIS_MULTIPLE_HIERARCHY (0x8e131618)

Raised when a hierarchy is used both in the slicer and in one axis.

OLAP_MDX_ERROR_FUNCTION (0xcbacc669)

Raised by the MDX function .Error() function.

OLAP_AXIS_SELECT_SEQUENCE_ERROR (0xc9d39912)

Raised when an invalid axis sequence is used (i.e., not 0, 1, ... or COLUMNS, ROWS, ...)

OLAP_AXIS_SELECT_MULTIPLE_HIERARCHY (0xd2d2b7da)

Raised when the same hierarchy is selected in more than one axis.

OLAP_MDX_AXIS_FUNCTION_MISSING_AXIS (0x667c6f57)

Raised when referencing (using the Axis() function) an axis not evaluated yet.

OLAP_CONSTRAINED_VIOLATED (0xce5eef)

Raised when evaluating a MDX function using the CONSTRAINED flag has failed.

OLAP_CELL_PROPERTY_UNKNOWN (0x157cc216)

Raised when referencing a non-existing CELL property.

OLAP_CELL_PROPERTY_UNKNOWN_X (0x70b88995)

Raised when referencing a non-existing CELL property.

OLAP_CELL_PROPERTY_READ_ONLY (0xaffd1dd4)

Raised when attempting to set a value to a read-only property (e.g., ORDINAL = 42).

OLAP_MEMBER_PROPERTY_UNKNOWN (0xd8120c93)

Raised when referencing a non-existing MEMBER property.

OLAP_MEMBER_PROPERTY_UNKNOWN_X (0x4a90c742)

Raised when referencing a non-existing MEMBER property.

OLAP_MEMBER_PROPERTY_CONTEXT_SENSITIVE (0x6c0e12b1)

Description not available yet.

OLAP_MEMBER_PROPERTY_NOT_CONTEXT_SENSITIVE (0x7267c7d1)

Description not available yet.

OLAP_MEMBER_PROPERTY_UNKNOWN_CONTEXT (0x3864d477)

Description not available yet.

OLAP_MEMBER_PROPERTY_CONTEXT_TYPE_MISMATCH (0xd4239e9e)

Description not available yet.

OLAP_PROPERTY_NOT_FOUND (0xdc141477)

Raised when requesting a non-existing property using the .Properties() function.

OLAP_FUNCTION_AS_PARAMETER_DUPLICATED (0xc998f690)

Raised when using duplicated names within the function declaration of the arguments AS named sets.

OLAP_UNKNOWN_MEASURE (0xa022e12b)

Raised when referencing a [Measures] that does not exist within the cube.

OLAP_UNKNOWN_DIMENSION_HIERARCHY (0xf291cb7d)

Raised when referencing a dimension and/or hierarchy that does not exist within the cube.

OLAP_UNKNOWN_ENTITY (0x4455f93d)

Raised when referencing an entity that does not exist within the cube (see icCube.mdxEvalUnknownMemberError XMLA property).

OLAP_AGGREGATE_MULTI_TYPE (0x11b30bec)

Raised when attempting to aggregate values with different aggregation operator.

OLAP_TO_STR_MAX_SIZE (0xf6d9918a)

Raised when generating a string that exceeds the maximum authorized size (see icCube.toStrMaxSize XMLA property).

OLAP_MDX_FUNCTION_USAGE (0x8a01c66e)

Raised when attempting to use a non authorized function (e.g., CONSTRAINED context).

OLAP_MDX_FUNCTION_UNRESOLVED (0x1ecb28a)

Raised when attempting to use a non existing function.

OLAP_EXTRACT_MISSING_HIERARCHY (0x1ebc7329)

Raised when extracting (i.e., .Extract() function) members from missing hierarchies.

OLAP_INVALID_TUPLE_DIMENSIONALITY (0xce3b70b5)

Raised when attempting to use tuple with different dimensionality (e.g., when creating a set).

OLAP_DUPLICATED_SOLVE_ORDER (0xcea05c6b)

Raised when specifying several calculated members with the same SOLVE_ORDER leading to non predictable results (see icCube.duplicatedSolveOrderError XMLA property).

OLAP_CALC_MEMBER_OVERWRITE_MEMBER (0x9bbe9510)

Raised when defining a calculated member with the same unique name as an existing member.

OLAP_MDX_EXPRESSION_EXPECTED (0x71a5e23f)

Raised when an empty/null string expression is used (e.g., .StrToXyz() functions).

OLAP_MDX_IDENTIFIER_ERROR (0xd0783c3)

Raised when specifying an invalid identifier as string parameter (e.g., .Dimensions() function).

OLAP_CROSSJOIN_TYPE_MISMATCH (0x6fea53ff)

Raised when attempting to crossjoin non-set entities.

OLAP_INVALID_DISTANCE_VALUE (0xf239e9b2)

Raised when using a distance (i.e., relative level depth) value being out of range.

OLAP_DIFFERENT_HIERARCHIES (0xa403e60a)

Raised when using members of different hierarchies (e.g., periods like function).

OLAP_OUT_OF_RANGE (0x7fc3bf54)

Raised when an argument is out of range.

OLAP_DRILLDOWN_INVALID_HIERARCHY (0xd223e8d4)

Raised when attempting to drilldown members with an invalid hierarchy.

OLAP_TIME_MISSING_DEFAULT_HIERARCHY (0xc14753b8)

Raised when attempting to use the default time hierarchy and no default time dimension has been defined in the cube.

OLAP_TIME_MISSING_DEFAULT_HIERARCHY_X (0xc7346f1b)

Raised when attempting to use the default time dimension and no default time dimension has been defined in the cube.

OLAP_TIME_MISSING_DEFAULT_MEMBER (0x85001b1f)

Raised when referencing a non-existing default member from a time hierarchy.

OLAP_TIME_MISSING_CURRENT_MEMBER (0x6598ca22)

Raised when referencing a non-existing current member from a time hierarchy.

OLAP_TIME_MISSING_LEVEL (0xfc6d77d0)

Raised when referencing a missing level from a time hierarchy.

OLAP_UNEXPECTED_SET_COUNT (0x100290a)

Raised when a function (e.g., crossjoin, union) call does not defined enough sets.

OLAP_AGGREGATION_NOT_SUPPORTED_FOR_TYPE (0x623edaf5)

Raised when trying to aggregate types which do not implement an aggregation method (e.g. strings)

OLAP_NO_AGGREGATION_FOR_COLUMN_TYPE (0x9fd16173)

The description is not available.

OLAP_INVALID_SOLVE_ORDER (0xacb7d3dc)

Raised when a calculated member SOLVE_ORDER property value is an invalid MDX expression (e.g., boolean value expression)

OLAP_PROPERTY_TYPE_MISMATCH (0x3b4ef5f5)

Raised when the processing of a property generates a value with the wrong type.

OLAP_TYPE_MISMATCH (0xfbbc25a8)

Raised when the processing generates a value with the wrong type.

OLAP_DESCENDANTS_INVALID_LEVEL (0xc6a89f8c)

Raised in the Descendants() method for not matching hierarchies between member and level.

OLAP_NAMED_SET_NOT_IN_SCOPE (0xe6bd7215)

Raised when attempting to access a named set (e.g., with current/currentMember) that is not in the visible scope.

OLAP_CURRENT_ITERATED_TUPLE_USAGE (0x424f3013)

Raised when the current iterated tuple is used in a context that forbids its usage.

OLAP_UPDATE_CUBE_MANDATORY_MEASURE (0x8fb9c7ed)

Raised when no measure is specified in an 'UPDATE CUBE' instruction.

OLAP_UPDATE_CUBE_MEASURE_AGGREGATION_NOT_SUPPORTED (0x255a292f)

Raised when a measure with aggregation type different from SUM is used in a 'UPDATE CUBE' instruction.

OLAP_UPDATE_CUBE_CALC_MEMBERS_NOT_SUPPORTED (0x9b8b4c68)

Raised when a 'UPDATE CUBE' instruction is applied to a calculated members.

OLAP_UPDATE_CUBE_INVALID_TUPLE (0x7225df47)

Raised when a 'UPDATE CUBE' instruction is applied to an empty or invalid tuple.

OLAP_MISSING_ROLLUP_HIERARCHY (0x6a88b141)

Raised when attempting to rollup a measure according in a cube without specified rollup hierarchy (e.g. no default time dimension for an OPEN measure).

OLAP_AGGREGATE_TYPE_NOT_SUPPORTED (0xfcbe21f1)

Aggregate function : raised when using unsupported aggregation type.

OLAP_SLICER_AGGREGATE_TYPE_NOT_SUPPORTED (0x30631278)

Slicer : raised when using unsupported aggregation type.

OLAP_SCHEMA_MISSING (0xc3cbc9c)

Raised when a schema is not specified to an operation requiring a schema.

OLAP_FACTLESS_CUBE_EVAL_TUPLE (0x5b65fdc)

Raised when an expression is attempting to evaluated a tuple and no fact (i.e., cube) is available.

OLAP_PIVOT_TABLE_AXIS_COUNT_ERROR (0x359411dc)

Raised when a non supported number of axes is specified in the MDX query.

OLAP_GVI_RESULT_SET_SERIALIZATION_ERROR (0xfecebcff)

Raised while serializing into JSON the result of an MDX SELECT (more likely an internal error).

OLAP_DRILLTHROUGH_INVALID_MAXROWS (0x7a0a9e40)

Raised when an invalid DRILLTHROUGH MAXROWS value is used (note that a positive value is expected).

OLAP_DRILLTHROUGH_UNKNOWN_RETURN_FUNCTION (0xf4e52b4)

Raised when an unknown DRILLTHROUGH RETURN function is specified (e.g., identifier, Name(), UniqueName(), Key(), etc...).

OLAP_DRILLTHROUGH_FUNCTION_UNEXPECTED_ARGUMENT_COUNT (0x55fc0e6a)

Raised when an unexpected number of arguments is passed to a DRILLTHROUGH RETURN instruction.

OLAP_DRILLTHROUGH_FUNCTION_DIM_ARGUMENT_TYPE_MISMATCH (0x3a535547)

Raised when an function used in a DRILLTHROUGH RETURN instruction received as first argument a non-dimension entity.

OLAP_DRILLTHROUGH_KEY_PART_TYPE_MISMATCH (0xbc7fb2f8)

Raised when a non numerical value is passed to the DRILLTHROUGH RETURN instruction Key().

OLAP_DRILLTHROUGH_KEY_PART_INVALID_VALUE (0xb6b456d2)

Raised when a invalid numerical value is passed to the DRILLTHROUGH RETURN instruction Key().

OLAP_DRILLTHROUGH_DIM_ATTRIBUTE_TYPE_MISMATCH (0x38cd68c)

Raised when the attribute specified in a DRILLTHROUGH instruction is not a dimension.

OLAP_PERSPECTIVE_EVAL_UNEXPECTED_RESULT (0xc326cd3)

Raised the evaluation of a perspective expression is not a non-scalar MDX entity (actual:%s)

OLAP_WRITE_BACK_NOT_AVAILABLE (0x2a5efb12)

Raised when attempting to use write-back when not licensed.

OLAP_WRITE_BACK_CUBE_READ_ONLY (0x6579f124)

Raised when attempting to update values of a read-only cube.

OLAP_SET_FORMULA_INFINITE_LOOP (0xcc434e13)

Raised when the evaluation of a set is entering an infinite loop.

OLAP_CREATE_CALC_MEASURE_MISSING_CUBE (0x7e6fb991)

Raised when the declaration of a calculated measure does not specify any cube.

OLAP_CURRENT_CELL_VALUE_CONTEXT_ERROR (0xc60b7c0f)

Raised when the function CurrentCellValue() is used outside the context of a cell property evaluation.

OLAP_PLUGIN_GENERIC_ERROR (0xe9e6ea45)

Unspecified error raised by a plugin function

OLAP_RGB_INVALID_VALUE (0x220df22f)

Raised when using an invalid RGB value.

icCube OLAP version: 2.5.1 13-May-2012 02:21:10 GMT