How to filter out duplicate value for multi-rows attributes in OTBI analysis
The OTBI analysis shows duplicate value for multi-rows attributes. I need a way to filter them out in analysis.
I have two multi-rows attributes and I would like to have them in OTBI analysis report.
I want to see them in one item row, not multiple rows for the same item.
I use LISTAGG function. It is working fine for only one multi-rows attribute.
But if I apply for two multi-rows attributes, the result shows duplicated values.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):