Hi team,

I am working on creating a profile view, for which the identifier in record is required.

As DISTINCT and usage of two tables is restricted while creating an identifier, I am using PU_FIRST and using same table and column in target and source.

I am able to make records unique, but I am facing problem when I am adding KPIs for this profile view dimension.

It looks like it is showing duplicates.

Can someone please let me know why this approach is not right and any alternative solution for the same ?