My Oracle Support Banner

Data Cube 'Date Function' for Drill-Down Dashboards Not Filtering Results Based on Date (Doc ID 2863620.1)

Last updated on FEBRUARY 20, 2024

Applies to:

Primavera Unifier Cloud Service - Version 21.12 to 22.3 [Release 21.12 to 22.3]
Primavera Unifier - Version 21.12 to [Release 21.12]
Information in this document applies to any platform.


A data cube that has been defined for reporting Business Process records is not filtering results based on the date function. The data cube has a date function to group results by month for the date the Records were created. This functionality works in the dashboard and displays records that were opened in the past yet have no closed record status (the records remain open).

The expectation is for the date function to filter the results into a table displaying the open records with a date of record from that month. Instead, the resulting table is an empty set. If the date function is removed from the dashboard, the full set of open results is displayed.

The issue can be reproduced at will with the following steps:

  1. Log into Unifier as an Admin user.
  2. Company Workspace -> Data Structure Setup -> Data Cube Definitions.
  3. Name: Open the Data Cube.
  4. The Data Elements and Function (Date Function) are shown.
  5. Go to the Project/Shell using this Dashboard.
  6. Admin Mode -> Setup -> Dashboards.
  7. Navigate to the Dashboard.
  8. On the Bar Chart associated -> click the first bar grouping -> On the Pie Chart that is displayed, click the area (Pending). A list of Pending Records is displayed.
  9. On the Bar Chart click a bar grouping. A blank table is displayed with no records.


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

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