SYMPTOM
In Strategy 10.x, when running a report that has a non-aggregatable metric, users may notice that in certain cases the following error message is seen:
Error: SQLEngine got an Exception from DFC: [DFCENGINE] Engine Logic: Non-Aggregation Metric dimensionality error. None of the table keys in PseudoTable [LHS = table1, RHS = table2]'s LHS table are children of Non-aggregation dimensionality: Attribute1 Error in Process method of Component: SQLEngineServer, Project Strategy Tutorial, Job 1472, Error Code= -2147212800.



CAUSE
The error occurs because there is an indirect many-many relationship between the attribute in the level dimensionality and the attribute that is the level of the fact table, in this case Month of Year and Quarter respectively.
The metric in the above example will calculate the revenue for the first Month of Year in the lookup table for Month of Year from the Quarter level fact table. But there is no direct relationship between Quarter and Month of Year so there is no proper way to relate the elements of Quarter in the fact table with the beginning month of year from the lookup table. Thus the metric calculation should not be expected to return meaningful data given the relationship between these 2 attributes, and the exception is thrown indicating that there is no direct join path through parent-child relationships from the fact table up to the non-aggregation dimensionality attribute.