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 AI and Analytics

Child Item

Compare two fields in analysis

Ruthie

Summary

How to compare two fields within an analysis

Content

How do I compare two fields in an analysis. I need "Workforce Management - Person Real Time"."Person Legislative Information"."Country" equal to "Legal Employer"."Legislation"

Thank you

Find more posts tagged with

Comments

Ruthie

Attached is a text file with the error.

Thanks,

Ruthie

Shakher Sharma

Sorry, I am unable to see the text file.

Can you please go to Advanced tab of analysis and copy & paste text in SQL Issued text box? It will allow me to duplicate your analysis to debug this issue.

Ruthie

Ooops selected the upload image instead of Attach file. Lets try this again!

Shakher Sharma

Hi Ruth,

I believe the problem is that you are not filtering last clause. For example, following line is actually a filter as it is looking for PERSON_TYPE = 300000000120758.

(DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Worker"."Person Type") = 300000000120758)

Similarly, following line is a VALID filter as well as it is looking for ASSIGNMENT STATUS in (1, 4001....)

AND (DESCRIPTOR_IDOF("Compensation - Salary Details Real Time"."Worker"."Assignment Status") IN (1, 4001, 2001, 2))

However, the last line is not a filter. It is just a decode statement to return TRUE and FALSE. It doesn't say which value(s) you are interested in as it has no EQUAL TO or IN clause at it's end. Please look at might last image attachment. I have specifically pointed it out:

AND (CASE WHEN "- Person Real Time"."Person Legislative Information"."Country" = "- Worker Assignment Real Time"."Legal Employer"."Legislation" THEN 'True' ELSE 'False' END )

Above statement should have ='True' , or ='False' at it's end to make it a valid filter.

Please add filters one by one and test it.

New Announcements

Upcoming Events

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion CX Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…