nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Filtering data in Workforce Management – Documents of Record Real Time

C Hammond

I am joining the “Workforce Management – Worker Assignment Real Time” and “Workforce “Management – Documents of Record Real Time” Subject Areas, if I add a filter to identify Workers that do not have any records in “Documents of Record” (either filtering on “Document Count = 0” or “Document Type is null”) it returns no data, even though there are some Workers that do not have any Documents of Record.

Is this expected behaviour, is there a way of filtering on this?

Documents of Record.xml

Find more posts tagged with

HCM

Analysis

Filters

OTBI

Accepted answers

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/28425/filtering-data-in-workforce-management-documents-of-record-real-time

Hi @C Hammond,

I've changed document count definition and it is now returning results for me with filter document count = 0.

Can you please check the following XML to see if it is working for you?

XML - DoR - 160326.txt

Hope this help.

Thank you.

All comments

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/28425/filtering-data-in-workforce-management-documents-of-record-real-time

Hi @C Hammond,

I've changed document count definition and it is now returning results for me with filter document count = 0.

Can you please check the following XML to see if it is working for you?

XML - DoR - 160326.txt

Hope this help.

Thank you.

C Hammond

Thank you @Bhaskar Konar - that has worked.

Bhaskar Konar

Hi @C Hammond,

Please find below the changes that I did on top of your report.

Replaced: "Workforce Management - Documents of Record Real Time"."Document of Record"."Document Count"
With: IFNULL("Workforce Management - Documents of Record Real Time"."Document of Record"."Document Count", 0)

And then added the filter on the new measure.

Thank you.