2634621 - Allow extended text lengths during Analytics Data Integration

You want to extract Report or Data Source data through the Odata API or Exposure to BW (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.

• SAP Cloud for Customer
• SAP Business ByDesign

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 through the 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.

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.

However you have the option to extend the visualization of content longer than 60 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 the Business Configuration work center.
2. Go to the Implementation Projects view.
3. Click on Edit Project Scope.
4. Jump to step 4 - Questions.
5. Navigate as follows: 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 up to 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 ByDesign 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 as follows: Communication and Information Exchange > Business Process Management > Integration with SAP ERP for Subsidiaries >
6. Check the box: Do you want to view text fields up to 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.

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

60 characters, report, truncated, description cut off, odata, open data protocol, bw, odp, sac, integration, postman, extended text, business analytics, reporting , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions