KB39303: "CMI_METRIC_FILTER_KEY_NOT_IN_TEMPLATE" error message appears when publishing an intelligent cube available for dynamic sourcing

SYMPTOM:
When publishing an Intelligent Cube available for dynamic sourcing with Parse Log enabled, the following entries are displayed:

Dynamic Sourcing Logs:

Cube Parse Log:

Intelligent Cube is ineligible for Dynamic Sourcing

CMI_ALL_METRICS_REMOVED_FROM_CUBE

The following metric(s) will not be available for dynamic sourcing

Failed Parsing metric with name: Profit

Error code: CMI_METRIC_FILTER_KEY_NOT_IN_TEMPLATE



_______________________________________________________________



Error code legend:

CMI_ALL_METRICS_REMOVED_FROM_CUBE - The Intelligent Cube included metrics, but the metrics were later removed or no longer enable dynamic sourcing. This Intelligent Cube cannot be used for dynamic sourcing

CMI_METRIC_FILTER_KEY_NOT_IN_TEMPLATE - Dynamic sourcing cannot be used because an attribute form is used in a conditional metric included on the report or the report filter, and the attribute form is not included in the Intelligent Cube.

 

STEPS TO REPRODUCE: 
Follow these steps to reproduce the issue in Strategy Tutorial project:

1. Create an Intelligent Cube and allow for dynamic sourcing.
2. Add 'Region' attribute and 'Profit' metric on the template.
3. Add any other attribute/attribute form to the report filter (not including it on the template).

 
CAUSE:
Not all attributes/attribute forms used in the Intelligent Cube filter are included in the Intelligent Cube template.
 
ACTION:
All attributes/attribute forms used in the Intelligent Cube filter should also be included in the Intelligent Cube template.
 
For more information on dynamic sourcing best practices please check:

• KB36667: Best practices for Dynamic Sourcing in MicroStrategy 9.x