How to fix the Oracle error XOQ-01940: BaseAttribute “string” is specified on a DimensionLevel as both a UniqueKeyAttribute and a VisibleAttribute.?

AbundantCode 1 week ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorXOQ-01940: BaseAttribute “string” is specified on a DimensionLevel as both a UniqueKeyAttribute and a VisibleAttribute. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-01940: BaseAttribute “string” is specified on a DimensionLevel as both a UniqueKeyAttribute and a VisibleAttribute.

Reason for the Error XOQ-01940: BaseAttribute “string” is specified on a DimensionLevel as both a UniqueKeyAttribute and a VisibleAttribute.

Cause: A BaseAttribute on a DimensionLevel can be specified as either a UniqueKeyAttribute or a VisibleAttribute, but not both.

How to fix the Error XOQ-01940: BaseAttribute “string” is specified on a DimensionLevel as both a UniqueKeyAttribute and a VisibleAttribute. ?

You can fix this error in Oracle by following the below steps

Action: Remove either the Visible or the UniqueKey setting for the attribute.

Tags :

Leave Your Comment