[nQSError: 14020] None of the fact tables are compatible with the query request

[nQSError: 14020] None of the fact tables are compatible with the query request 

Recently, I ran into this issue. lets see what the reason behind this: 

Scenario: 

  I have "Demo2" BMM Layer created from BISample Schema: Here is the BMM layer 

I have a Product Hierarchy created. Now I am providing the content level for the Logical Table Source.

In the above pic, I have selected the Bottom most level 'Product Name' as aggregation content. And for the Fact, I have selected the topmost level 'Product total' as its aggregation content.

 Now after saving the RPD &the report in dashboard throws error: 

Here, we are getting the error: 

[nQSError: 14020] None of the fact tables are compatible with the query request . 

The issue was at the Aggregation Content Level.The Correct Settings are (for the issue mentioned above)  

 Now in the Dashboard :

The drill down too works now.

 The issue was with choosing inappropriate content level for aggregation. Even for the corresponding dimensions we have to choose the content level at the lowest level of the hierarchy. 

This is applicable for both Conformed & Non-Conformed Dimensions.