You have added an KUT field in data source which is of String data type and it shows incorrect behavior in the report.
Cloud for Customer
Reproducing the Issue
Open the report from Design Data Source
In your KUT field you have data as :
Your requirement is to show all A,B, C together
You want "A,B" and "B,A" should have count as 1.
They should be considered as same.
The order in which the data are selected, is the order in which the it is stored in the hana database, which is stored as a string.
Since the string “A,B” is different from “B,A”, the data retrieved is aggregated with respect to the string.
This is the current behavior and is not a BUG. The analytics framework display the data retrieved from the FSI view of the hana database, as it is.
KBA , kut field in report , string data type field in report , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To