Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Pratheep88May 7 2015 — edited May 8 2015

Hi All,

Please help me understand this... I've one dimension and fact table. Product and Fact respectively.

I've used one column from dimension and one from fact but I'm getting the following error.. I'm getting the error more often.

[nQSError: 14020] None of the fact tables are compatible with the query request PRODUCTS.PROD_NAME. (HY000)

Capture.PNG

I want to know real reason for that. Please help understand that.

PFA

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details