SAP Knowledge Base Article - Public

3285747 - Data incorrect displayed in data source for extension field created as String Type

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

Product

SAP Cloud for Customer add-ins all versions