V3 seniority date multiple seniority date in OTBI Issue

Summary:

We just upgraded from V1 to V3 seniority dates and tried to update existing OTBI reports with the new dates. Have no issue replacing if the report is pulling just one seniority date using the seniority rule name as the filter. However, some existing reports have multiple seniority dates pulling from work relationship subject area. To replace them with V3 dates, we added person seniority real time subject area in, pulled the seniority date field multiple times to have multiple seniority date columns. In each column, we added a case statement using different seniority rule name to pull its seniority