SAP Knowledge Base Article - Public

2634621 - Allow extended text lengths during Analytics Data Integration

Symptom

You want to extract Report or Data Source data thru Odata API or Exposure (ODP extraction) and you noticed the following: for those fields which contain longer text or descriptions, the data comes up in the Odata query results or BW extraction is limited or truncated to 60 characters per field.

Environment

SAP Hybris C4C

SAP Business by Design

Reproducing the Issue

When using OData API:

We are using an OData call to pull out a report related to your Outbound Shipments, unfortunately one or more of the fields you need to retrieve is greater than 60 characters. By default fields are truncated to 60 characters also when you pull out report data via Odata.

e.g. https://myxxxxxx.sapbydesign.com/sap/byd/odata/scm_outboundlogistics_anaytics.svc/ReportNameQueryResults?$inlinecount=allpages

When using ODP extraction:

You are trying to extract the content Notes using data source Opportunity Notes and the content of Notes gets truncated in BW system. Even if you have defined the field to show 1024 characters thru of Extended Text functionality, the BW extractor shows the corresponding field with only 60 characters or truncated up to 60 characters.

 e.g. The Notes field available in the characteristics list for Opportunity Notes (ID: CODOPPNOTESB) data source.

Cause

By default, the length restriction per report field is set to 60 characters, this applies to the Report Viewing and whenever you pull out the report data via Odata API or ODP.

Resolution

However you have the option to extend the visualization of content longer than 60 lenghts to 1024 characters instead.

It is currently working and available to Analysis Pattern and ODP.

How to allow extended text lengths during Analytics Data Integration in Cloud for Customer systems for ODP:

  1. Go to Business Configuration
  2. Go to Implementation Topics
  3. Click on Edit Project Scope
  4. Jump to step 4 - Questions
  5. Navigate thru the following path: Communication and Information Exchange > Integration with External Applications and Solutions > Integration with Central Analytics 
  6. Check the box: Do you want to view text fields upto 1024 characters when making analytics data available to an SAP NetWeaver BW system?

  Screenshot attached;

How to allow extended text lengths during Analytics Data Integration in Business by Design systems for ODP:

  1. Go to Business Configuration
  2. Go to Implementation Topics
  3. Click on Edit Project Scope
  4. Jump to step 4 - Questions
  5. Navigate thru the following path: Communication and Information Exchange > Business Process Management > Integration with SAP ERP for Subsidiaries >
  6. Check the box: Do you want to view text fields upto 1024 characters when making analytics data available to an SAP NetWeaver BW system?

  Screenshot attached;

For Odata API, even you have set the Extended Text in the front end, the Odata data fetched will still show fields with 60 characters maximum.

We will have to implement extended text in our coding for Odata but it is currently under discussion to get this implemented in future releases.

 

See Also

How to switch on the Extended Text functionality: 2586974 - Values Length Restriction in Reports

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer all versions

Attachments

ODP_BC-1024.jpg
ODP_BC-1024 for byD.jpg