Compare two fields from different Subject Areas in OTBI

Scott_Turner_

I have written an OTBI analysis containing several fields however I am having an issue when I create a field with a Case statement to compare the below fields.

Subject Area: Person Real Time:

·      "Person Address"."Region2"

·      "Person Legislative Information"."PER_PERSON_LEGISLATIVE_DFF_PAYROLL__TAX__STATE_"

Subject Area: Worker Assignment Real Time:

·      "Location"."Region 2"

When I compare "Person Address"."Region2" AND "Person Legislative Information"."PER_PERSON_LEGISLATIVE_DFF_PAYROLL__TAX__STATE_" formula works as expected and returns ‘Match’ and ‘No Match’.

However when I create a field and try to compare either "Person Address"."Region2" AND "Person Legislative Information"."PER_PERSON_LEGISLATIVE_DFF_PAYROLL__TAX__STATE_" with "Location"."Region 2" No data is returned in the fields (Home VS Work State and Work VS Payroll Tax State).

Any help would be appreciated.

Thanks

Scott

Payroll Tax State XML.txt

RichardChan

Do you have any matching dimensions between the two subject areas to enable them to connect

Scott_Turner_

Hi @RichardChan yes, I have Head Count from Worker Assignment Real Time and Person Count from Person Real Time.

Thx Scott