How to fix the Oracle error XOQ-01434: Time dimension must have EndDate and TimeSpan attributes.?

In this post, you’ll learn more about the Oracle ErrorXOQ-01434: Time dimension must have EndDate and TimeSpan attributes. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-01434: Time dimension must have EndDate and TimeSpan attributes.

Reason for the Error XOQ-01434: Time dimension must have EndDate and TimeSpan attributes.

Cause: A time dimension did not have an EndDate or a TimeSpan attribute.

How to fix the Error XOQ-01434: Time dimension must have EndDate and TimeSpan attributes. ?

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

Action: Create an EndDate and a TimeSpan attribute using the OLAP Metadata API, and add them to the time dimension using the appropriate functions. If the time dimension already has an EndDate and a TimeSpan attribute, then ensure that they have been added to the time dimension. If the time dimension is read from the OLAP Catalog, then define the EndDate and TimeSpan attributes in the catalog.