Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Compare two fields in analysis

312
Views
14
Comments
2»

Comments

  • Ruthie
    Ruthie Rank 3 - Community Apprentice

    Attached is a text file with the error.

    Thanks,

    Ruthie

  • Shakher Sharma
    Shakher Sharma Rank 4 - Community Specialist

    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
    Ruthie Rank 3 - Community Apprentice

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

  • Shakher Sharma
    Shakher Sharma Rank 4 - Community Specialist

    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.