SAP Knowledge Base Article - Public

3001834 - Custom analytical query - No data to display

Symptom

You have created a custom CDS view query, based on an analytical cube scenario and noticed an issue when a specific user executes the custom analytical query:

No data to display. There is nothing to display as there is no data on the rows axis or columns axis.

You are able to see additional errors displayed at the bottom of the screen:

Error reading the data of InfoProvider
e 2254543"
please refer to the "SAP Note 2254543"Length of input string(11) is longer than defined(5):
Database returned the SQL code 359. Error text: string is too long: Length of input string(11) is longer than defined(4):

"Image/data in this document is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

Environment

SAP S/4HANA Cloud Public Edition.

Cause

The custom view created doesn't provide proper parameter value for the cube view used in this analytical cube scenario.

Let's say you are using cube view I_SalesOrderItemCube parameters including both P_ExchangeRateType and P_DisplayCurrency.

In the app "Custom CDS View Details", the value of P_ExchangeRateType and P_DisplayCurrency of I_SalesOrderItemCube are System User:

Capture.JPG

Let's say the user for whom the issue is raised is CB9980001830. In the app "Maintain Business Users", the first name of CB9980001830 is CONSULTANT6. So when user CB9980001830 runs the query, CONSULTANT6 will be assigned to the parameters, that results in the SQL error "Database returned the SQL code 359. Error text: string is too long: Length of input string(11) is longer than ..." .

Capture1.JPG

Resolution

Consider changing the value type for the parameters of the cube view.

See Also

2657021 - Creating Custom CDS Views for Analytical Scenarios

Keywords

custom analytical query, P_ExchangeRateType, P_DisplayCurrency, Exchange Rate Type, Display Currency, Parameter Type, Value Type, Value, SQL code 359, 359, Custom CDS View Details, parameters, F1866A , KBA , SD-ANA , Analytics , SD-ANA-2CL , Analytics (Public Cloud) , How To

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions