The 60 Character Restriction for BW Data Models

[former_member93896]

Update:

Good news, with SAP NetWeaver BW 7.4, there is now a standard solution available and the old limitations for key and text length are not valid anymore. Please see my blog for more details.

Hello Friends,

The topic has been mentioned many times. I'm NOT providing any new solution here. This blog is merely aggregating existing pieces of information in a single place.

SAP Library

Here are links to the documentation that describe the 60 character limitation for characteristic values.

InfoObject - General
http://help.sap.com/saphelp_nw04/helpdata/en/b7/f470375fbf307ee10000009b38f8cf/frameset.htm

InfoObject - Master Data/Texts
http://help.sap.com/saphelp_nw04/helpdata/en/71/f470375fbf307ee10000009b38f8cf/frameset.htm

InfoObject - Compounding
http://help.sap.com/saphelp_nw04/helpdata/en/ff/f470375fbf307ee10000009b38f8cf/frameset.htm

Blog

Various other blogs have dealt with this topic as well and given some nice solutions.

Long texts in SAP BW: Modeling
Long texts in SAP BW: Modeling

Long texts in SAP BW: Modeling - Follow Up
Long texts in SAP BW: Modeling – Follow Up

Long Texts in SAP BW: Displaying in BEx Analyzer. Introduction to Excel Workbooks Formatting. Part I.
Long Texts in SAP BW: Displaying in BEx Analyzer. Introduction to Excel Workbooks Formatting. Part I...

Long Texts in SAP BW: Displaying in BEx Analyzer. Introduction to Excel Workbooks Formatting. Part II.
Long Texts in SAP BW: Displaying in BEx Analyzer. Introduction to Excel Workbooks Formatting. Part I...

Another solution is to embed the comments directly into the analysis item using a web item modification:

BEx Web Interface - Enhancement
http://help.sap.com/saphelp_nw70/helpdata/en/47/a7f99310971503e10000000a42189c/frameset.htm

Forum

If you want to read up on the discussions, please see the following forum threads.

Is there any way to load more than 60 characters in to one InfoObject
is there any why to load more than 60 characters  in to One info object

Field with more than 60 characters
Field with more than 60 characters

Compounding InfoObject need longer than 60 Characters Key
Compounding Infoobject need longer than 60 Characters Key

InfoObject with more than 60 digits
Info Object with more than 60 digits

How-To overcome the 60 Byte restriction for InfoObjects/Reporting?
How-To overcome the 60 Byte restriction for InfoObjects/Reporting ?

Incoming data with more than 60 chars
incoming data with more than 60 chars

Pulling Free text into BW
Pulling Free text into BW

Increasing the length of InfoObject from 60 to 240 characters
Re: Increasing the length of Infoobject from 60 to 240 characters

BI InfoObject length
BI infoobject length

Loading long texts (> 60) into BI 7 with Z-tables?
Loading long texts (> 60) into BI 7 with Z-tables?

Bringing in more than 60 characters into BW
Bringing in more than 60 characters into BW

Long - more than 60-character - texts in BI 7.0
Long - more than 60-character - texts in BI 7.0

Text longer than 60 display in Web (BI 7.0)
Text longer than 60 display in Web (BI 7.0)

Outlook

There is always hope that SAP will overcome this restriction in a future BW release 😉

We did it! See here.

Best,
Marc Bernard
@marcfbe