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.