Database Error Messages

Release
toggle
  • 23ai
  • 21c
Updated
Jun 24, 2024

OCI-18502

cannot enable query transform because fact source is joined to distinct members of analytic view dimension "string"

Cause

An attempt was made to enable query transform with a REFERENCES DISTINCT clause in which the fact and dimension tables did not match.


Action

Match the source of the dimension to the source of the fact when enabling an analytic view for query transform.