How to delete duplicated records in OTBI Analysis

Content

Hello experts,

I have just created a custom OTBI Anaysis by using Compensation - Workforce Compensation Real Time subject area only.

However, the analysis returns duplicated records for the same employee and information is equal in all columns.

For example, if for a specific employee I expect to have two records; the analysis will generate eight records; but the values are equal.

The question is: how can I delete duplicated records from OTBI Analysis?

Thanks in advance for your time!

Kind Regards,

Valerio