Database Error Messages

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

XOQ-02529

The base attribute "string" of dimension "string" cannot be given an NVL expression because it is indexed.

Cause

An NVL expression was specified for a base attribute that is indexed. An attribute is indexed if it is explicitly marked as indexed by the user, or if it is a unique key attribute, or if the populate lineage flag is set.


Action

Remove the NVL expression or change the attribute so that it is not indexed, is not a unique key, and does not have the populate lineage flag set.