Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Obtain "People Group" Field through OTBI

Submitted
55
Views
3
Comments
Atul Agarwal
Atul Agarwal Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

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

Tagged:
2
Up
2 votes

Submitted · Last Updated

Comments

  • Matthew Voss
    Matthew Voss Rank 3 - Community Apprentice

    I've heard rumors that the people group is going away, so I'm not sure what traction you will get on this. Our people group is separated by ":", so I've used some functions to separate it out.

     

    SUBSTRING("Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."People Group" FROM 0 FOR LOCATE(':',"Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."People Group")-1)

  • Rajeev Nayan
    Rajeev Nayan Rank 1 - Community Starter

    This will Provide the output for first segment. How can we get the value of other segments?

  • Andrew_Schmitz
    Andrew_Schmitz Rank 5 - Community Champion

    I would like to request People Group be added to other Subject Areas. The only one it is currently in is: "Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."People Group"


    If we ever have a requirement to report on People Group and other HCM data you will always need to add the Worker Assignment Real Time Subject Area.