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:

Symptoms

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).

EXPECTED BEHAVIOR
----------------------
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.

STEPS
-----------------------
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.

Cause

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