OTBI Analysis for Remote Workers and Onsite Associate Work Location State and Postal Code

Summary:

We currently have a large population of workers who work remote or their "Work Location" is classified as their home office. Our population of around 18,000 workers operates in 3 countries and across all 50 US States. Our workers who are "remote" have a Work Location on the assignment as "Home Office". We have a "Home Office" set up for all 3 countries we operate in, with that work location having the base address in Workforce Structures as the Corporate Office for that country.

Historically we had written BIP Reports with SQL Queries and would always code with case statements like ( CASE WHEN PAAM.LOCATION_ID IN (300000170783311 , 300000170856077, 300000640538182)