DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 | DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 |
DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 | DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 |
DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 | DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 |
DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 | DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 |
DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 | DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 |
DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 | DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 |
DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 | DisableSaveToPhotos
Booltrue/false CMI_NO_ERROR No error occurred CMI_REPORT_IS_XDA The report type is XDA. XDA reports are not supported for the purposes of dynamic sourcing CMI_REPORT_LIMIT_ON_CUBE_FOUND Cube cannot be reused as there is a report limit on it. Report limits are not supported on the cube side CMI_CG_OR_CONSOLIDATION There is a custom group or a consolidation on the template. Custom groups and consolidation are not supported for the purposes of dynamic sourcing. CMI_ALL_METRICS_REMOVED_FROM_CUBE The cube originally had some metrics, but due to various reasons all of them were considered unusable for the purpose of dynamic sourcing. This cube cannot be used for any reports that have metrics and it cannot be used for any reports that do not have metrics either because the original metrics on the cube acted as a filter and might have filtered out some of the rows that are needed for the report. So this cube cannot be used for any report for the purposes of dynamic sourcing, and it’s not added to the cube index CMI_VLDB_DOWNWARD_OJ_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the downward outer join VLDB setting enabled, nor is the “Allow dynamic caching even if outer join properties are not set” project setting enabled. CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Lookup Elements" VLDB setting enabled (3rd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled CMI_VLDB_OUTER_TO_LOOKUP_PROBLEM This cube cannot be used for the purposes of dynamic sourcing, because neither is the "Preserve All Final Pass Results Elements" VLDB setting enabled (2nd option needed), nor is the “Allow Dynamic Sourcing even if outer join properties are not set” project setting enabled. CMI_UNEXPECTED_REPORT_TYPE Report type is not supported. The type may be a datamart, XDA or Element browsing report, for example. CMI_CUBES_FOR_AD_HOC_DISABLED_MASTERSWITCH Dynamic sourcing is disabled for the current project. CMI_CUBES_FOR_AD_HOC_DISABLED_FOR_REPORT Dynamic sourcing is disabled for the current report. CMI_CSI_OR_ELEMENT_BROWSING Report is already a cube subset report or is used for element browsing. Neither of those requests are supported with dynamic sourcing. CMI_INCOMPLETE_HIERARCHY_DANGEROUS_ATTRIBUTE The report or cube contains a attribute that has been set with a VLDB setting that could result in NULLs in lookup or fact tables. CMI_METRIC_NOT_OJ This cube cannot be used for the purposes of dynamic sourcing, because there is a metric that is not outer join type and the “Allow Dynamic Sourcing even if outer join properties are not set” project setting is not enabled. CMI_METRIC_WITH_TRANSFORMATION Transformation on metric is not supported for dynamic sourcing CMI_METRIC_NOT_LEAF_OR_BRANCH Metric is neither a leaf or branch metric (unexpected type). CMI_METRIC_WITH_CONDITIONALITY_IN_CUBE Conditional metrics are not supported on the cube side for dynamic sourcing CMI_DIMMETRIC_BRANCH_IN_CUBE DimMetricBranches are not supported on cube side CMI_UNSUPPORTED_METRIC_TYPE An unexpected metric type was found CMI_NONAGGREGATION_IN_METRIC Nonaggregation in a metric is not supported CMI_METRIC_AND_TEMPLATE_LVL_NOT_MATCHING_IN_CUBE Level metrics are not supported in cube CMI_FACT_ENTRY_LVL_ERROR There is a problem with the fact entry level. Fact extensions, degradations including implicit ones(with cross-joins) are not supported CMI_METRIC_FITLER_KEY_NOT_IN_TEMPLATE An attribute form from the metric filter key is not on the template. Related to CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE CMI_METRIC_GROUP_BY_KEY_NOT_IN_TEMPLATE An attribute from the metric group by is missing from the report template. CMI_AGG_METRIC_BRANCH_WITH_ZERO_CHECKING Aggregate metric branch has been found with zero checking on CMI_METRIC_NOT_SAFE The metric or one of its constituent metrics is marked as unsafe for dynamic sourcing through the 'Metric Validation' VLDB property. CMI_OLD_OLAP_FUNCTION_IN_METRIC Old OLAP function behavior is not supported. To fix the issue enable the 9.0 and later option for 'OLAP function support' VLDB property for the project. CMI_BAD_OR_IN_FILTER An OR node in a filter has children that are based on different attribute forms and is not supported CMI_ANDNOT_OR_ORNOT_IN_FILTER ANDNOT and ORNOT operators in filters are not supported for dynamic sourcing CMI_UNSUPPORTED_FILTER_NODE Unsupported filter node (e.g. Metric Qualification) CMI_UNSUPPORTED_FUNCTION_IN_FILTER Unsupported function in filter CMI_UNSUPPORTED_EXPR_TYPE_IN_FILTER Unsupported expression type in filter CMI_FILTER_UNIT_ROOT_NODE_NOT_SUPPORTED Report as a filter is not supported for dynamic sourcing CMI_FILTER_PRED_NODE_NOT_SUPPORTED Metric qualification is not supported for dynamic sourcing CMI_FILTER_TABLE_NODE_NOT_SUPPORTED Subqueries are not supported. Usually this is relationship qualification CMI_FILTER_METRIC_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_METRIC_EXPR_NODE_NOT_SUPPORTED Metric qualification is not supported CMI_FILTER_RELATIONSHIP_NODE_NOT_SUPPORTED Relationship qualifications are not supported CMI_FILTER_FACT_NODE_NOT_SUPPORTED Filtering on facts is not supported CMI_PERFORM_OR_FAILED Error occurred when trying to merge two attribute form qualification based on the same attribute form. CMI_DB_ONLY_FUNCTION_IN_FILTER Passthrough functions (e.g. ApplySimple) are not supported CMI_INVALID_BETWEEN_IN_FILTER The first argument to between should be less than or equal to the second argument. CMI_STRING_COMPARISON_NOT_ALLOWED String comparison was disabled with the VLDB setting on the attribute CMI_INCOMPATIBLE_DATA_TYPES_IN_FILTER Incompatible datatypes for the same attribute form in the filter were found. CMI_FILTERS_CANNOT_ENSURE_ALL_DATA_NEEDED_IS_IN_CUBE The cube cannot be hit, because we cannot guarantee that the cube filter did not filter out some data that is to be needed for the report. CMI_ZERO_METRICS_NEEDED If report has no metrics on the template, then the only cube that can mach must have no metrics as well. CMI_SECURITY_FILTER_KEY_ATTRIBUTE_UNAVAILABLE Attribute from the security filter key is missing in the cube CMI_SECURITY_FILTER_LEVEL_ATTRIBUTE_UNAVAILABLE Attribute from the security filter level (top or bottom) is missing in the cube CMI_DIFFERENT_DB_ROLES DB Roles for the report and the cube do not match CMI_FULL_OUTER_JOIN_NOT_SUPPORTED Full outer join has been disabled with VLDB setting. Some databases don’t support full outer join. This creates problem sometimes and if this is the case the engine will not use the cube. CMI_GROUP_BY_ATTRIBUTE_UNAVAILABLE An attribute from the group by key of the report metric attribute is not available on the cube CMI_FILTER_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filter key of the report metric attribute is not available on the cube CMI_FILTERING_KEY_ATTRIBUTE_UNAVAILABLE An attribute from the filtering key of the report metric attribute is not available on the cube CMI_REPORT_TEMPLATE_ATTRIBUTE_FORM_MISSING_FROM_CUBE_TEMPLATE Report template attribute is not available in the cube template CMI_NO_GOOD_CANDIDATE_METRICS_FOUND The engine did not find an appropriate metric in the cube for the current report metric CMI_METRIC_CROSS_JOINED_NO_GROUP_BY Cross joins are not supported CMI_FILTER_NOT_RESTRICTIVE_ENOUGH The metric cannot be used because the engine cannot guarantee that the filter of the cube metric did not filter out some data that is to be needed for the report metric CMI_DIM_METRIC_LEAF_EXPECTED Expected a dimensional metric type for the metric, found something else CMI_AGG_METRIC_LEAF_EXPECTED Expected a leaf class type for a aggregatable metric, found something else CMI_NON_AGG_FUNCTION_FOUND Non aggregatable functions are not supported in dynamic sourcing CMI_DIFFERENT_AGG_TABLE_HIT The cube metric and the report metric get their data from different tables in the warehouse CMI_COUNT_DISTINCT_FOUND Count with distinct parameter set to true is not supported CMI_NONAGGREGATABLE_METRIC Non Aggregatable metrics are not supported CMI_FUNCTION_EXPECTED Something else was found where a function was expected CMI_NULL_CHECKING_FOR_ANAL_ENGINE_MISMATCH The value for the NULL checking for the analytical engine is different in the report and the cube CMI_CUBE_TEMPLATE_MISSING_FILTER_ATTRIBUTE_FORM All attributes forms used in the report filter must be available in the cube CMI_FACT_ENTRY_LVL_GREATER_THAN_A_FILTER_LEVEL The fact entry level is incompatible with one or many filter levels. For example, the filter level contains an attribute that is not found/compatible in the fact entry level CMI_DISTINCT_FOUND_ON_AGGREGATION_FUNCTIONThe count distinct parameter is found on the aggregation function and the level of the cube is not exactly the same as the report metric levelCMI_JOINT_PARENT_OR_JOINT_CHILD_OR_MANY_TO_MANY_NOT_SUPPORTEDJoint parent and joint child relationships are not supported. If possible remove one of the children that have a joint parent or one of the parents that have a joint child. Many to Many reklationshios are not supported either, one of the attributes in a many to many relationship may need to be removed to make it eligible for Dynamic Sourcing. CMI_METRICS_WITH_NESTED_AGGREGATION_NOT_SUPPORTED Nested aggregation is not supported for dynamic sourcing. CMI_UNSUPPORTED_ELEMENT_IN_FILTER Some unsupported element has been used in a filter CMI_UNSATISFIABLE_CONDITION_IN_FILTER An unsatisfiable condition has been introduced in the filter CMI_IF_NO_METRIC_REPORT_AND_CUBE_LOWEST_LVL_MUST_BE_THE_SAME If the report contains no metrics, it can only hit cube that is exactly the same level as the report CMI_NON_HDA_USER_CANNOT_USE_HDA_CUBE The current user does not have the Use Heteregeneous Data Access (HDA) reports privilege, so it cannot use cubes that use the HDA feature. CMI_DISTINGUISH_DUPLICATED_ROWS_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for the "Distinguish Duplicated Rows for the Analytical Engine" setting do not match CMI_VLDB_SETTING_MISMATCH_FOR_CUBE_AND_REPORT The current report cannot use the current cube, because the values for a VLDB setting that can change the report results do not match CMI_METRIC_BREAK_BY_NOT_ON_CUBE_TEMPLATEThe break by of this metric is not on the cube template CMI_DB_ONLY_FUNCTION_IN_METRIC_FORMULAThe report cannot use dynamic sourcing because there is a database only function in the metric formula CMI_DIFFERENT_METRIC_FORMULAThe metric cannot be used because the metric formulas are different CMI_FACT_NOT_SUPPORTED_AT_REQUIRED_CUBE_LEVELA fact is used in the report that has an entry level higher than the level of the recommended cube. CMI_USER_LOCALE_NOT_SUPPORTED_IN_CUBECube is not available in the user locale. Microsoft SQL Database 32-bit Microsoft SQL Server 2008 SP3 Native Client ODBC Driver Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 32-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol Certified Microsoft SQL Database 64-bit Strategy 7.1 ODBC Driver for SQL Server Wire Protocol CertifiedLanguageSettingWestern European (ISO 8859-15)111Japanese17Korean38Chinese (Simplified)113Chinese (Traditional)2026Unicode (UTF8)106 |
