Symptom
You have added an KUT field in data source which is of String data type and it shows incorrect behavior in the report.
Environment
SAP Cloud for Customer
Reproducing the Issue
Open the report from Design Data Source
In your KUT field you have data as :
A
A,B
B,A
A,B,C
Your requirement is to show all A,B, C together
Or
You want "A,B" and "B,A" should have count as 1.
They should be considered as same.
Cause
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.
Resolution
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.
Keywords
KBA , kut field in report , string data type field in report , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To