My Oracle Support Banner

Data Cube – Filtering Data Elements By Date Does Not Work In Data Cubes (Doc ID 2679591.1)

Last updated on JUNE 19, 2020

Applies to:

Primavera Unifier - Version 19.12.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 19.12.1.0 version, Unifier User Mode

ACTUAL BEHAVIOR
---------------
When defining a Date filter in the Query tab of a Data Cube Definition, no data elements are returned in the dashboards. Filters work when the data type is different than Date. Tried to select different values for “Date Format” in the User Preferences/ Region Format, but the issue remained.

EXPECTED BEHAVIOR
-----------------------
The dashboard should show all records that have the date greater than 01-JAN-2019.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create correct dashboards

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.