Obtain "People Group" Field through OTBI

Atul Agarwal

Organization Name

Bayt Altawazun

Description

We have Enabled some People Group Segments like Medical Insurance Class, Housing Allowance, Transport Allowance Fields in PPG. Now we have a requirement to fetch these values in OTBI report. But I am unable to achieve it.

 SELECT
"Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."People Group"
"Workforce Management - Worker Assignment Real Time"."Worker"."Person Number"
FROM "Workforce Management - Worker Assignment Real Time"

Output is :

Person Number	People Group
989898	2 Basic Salary-A1-200-1 Basic Salary-10% of Basic Salary-120--140--160--180-200--300-400-220-130-12

 

Here we are not able to get the field names so it is difficult to understand the segments. We need to display segments here for better understanding

Use Case and Business Need

1) Ease of Reporting

2) Client wants to have ad Hoc filters on such data, which is not possible in BIP reports. Example if Nationality is not a column in OTBI but by creating extra filters at run time we can fetch results based on Nationality also.

This feature is missing in OTBI, so we are looking to fetch these values in BIP report

Original Idea Number: 1b512717a1