Oracle Communities

Oracle Analytics and AI

Child Item

Gain and Loss From and To column is creating two rows for the same record

Hi,

We found that in Gain and Loss Subject area, if we try to create a dashboard on BU Mobility 'From Business Unit Name' and 'To Business Unit Name' creating two different rows instead of single row.

Person Number|From Business Unit Name|To Business Unit Name

101|ABC|~No Value~

101|~No Value~|XYZ

We tried different functions which is available in FDI but no luck.Could anybody suggest how can we achieve this in single row.

Thanks.

Find more posts tagged with

FAW

Fusion Data Intelligence FDI

Accepted answers

KeerthanaBaskaran

Hi,

I'm able to achieve this by creating a dataset with two separate logics and joined with person number,Date,Action code, Reason code.

Below is the query i used for it.

select "HCM - Workforce Gains and Losses"."Time"."Date", "HCM - Workforce Gains and Losses"."Basic Information"."Person Number", "HCM - Workforce Gains and Losses"."To Business Unit"."To Business Unit Name", "HCM - Workforce Gains and Losses"."HR Action"."Action Name", "HCM - Workforce Gains and Losses"."HR Action Reason"."Action Reason" from "HCM - Workforce Gains and Losses" where "HCM - Workforce Gains and Losses"."HR Action"."Action Name" IN('Global Transfer') AND "HCM - Workforce Gains and Losses"."To Business Unit"."To Business Unit Name" <> '~No Value~'

Thanks,

Keerthana

All comments

Raghavendra Raghunath-Oracle

Hi @KeerthanaBaskaran can you add the following attributes to your query and provide the results

Time.Date
HR Action.Action Type
HR Action.Action Name

Thanks

Raghu

KeerthanaBaskaran

Hi @Raghavendra Raghunath-Oracle,

Please find the result for one of the employee (data is hidden for privacy purpose). We need basically one row for one employee to track the global transfer cases.

TestData.xlsx

@Ayoub Afrass_1 - Please feel free to add your comments for our need.

Thanks,

Keerthana.

Raghavendra Raghunath-Oracle

Hi @KeerthanaBaskaran These changes i.e. From and To are tracked at the Assignment grain. Please add Assignment Number to your query. It will show different values in both records. Any changes that happens on same assignment will appear in a single row.

Thanks

Raghu

KeerthanaBaskaran

Hi @Raghavendra Raghunath-Oracle ,

Thanks for your reply. But we want to track based on person level irrespective of assignments.

KeerthanaBaskaran

Hi,

I'm able to achieve this by creating a dataset with two separate logics and joined with person number,Date,Action code, Reason code.

Below is the query i used for it.

Thanks,

Keerthana

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/75466#Comment_75466

It'll be very helpful for the community.

Thanks for sharing, @KeerthanaBaskaran!