cancel
Showing results for 
Search instead for 
Did you mean: 

Object length issue in sap bi

former_member976
Active Contributor
0 Kudos

HI Experts,

I am extracting data form MY_SQL to SAP BI but source side one object length was 250 (long text) how to bring these object to sap bi?

as my understanding BI system allows only upto 60 length. STXT-20,MDTXT-40,LGTXT-60.

Thanks,

Phani.

Accepted Solutions (0)

Answers (7)

Answers (7)

former_member182516
Active Contributor
0 Kudos

Hi Kodanda pani,

As you are aware that BW IO accepts only 60 CHARs length.

You need to create 5 IOs of type CHAR with length 60.

in the transformations map the source field to all the 5 IOs.

Write a field level routine for all the 5 IOs

Routine:

IO1: RESULT = SOURCE_FIELDS-<FIELD NAME>+0(60).

IO2: RESULT = SOURCE_FIELDS-<FIELD NAME>+60(120).

IO3: RESULT = SOURCE_FIELDS-<FIELD NAME>+120(180).

IO4: RESULT = SOURCE_FIELDS-<FIELD NAME>+180(240).

IO5: RESULT = SOURCE_FIELDS-<FIELD NAME>+240(300).

Your Source data is of length 250 - 4 IOs can capture only 240 Char's long that the reason we had create 5 IOs.

In reporting you can use CONCATENATE function to display the value in single column.

Regards

KP

chanda
Contributor
0 Kudos

Hi Phani,

may i know how to split the data coming from flat file . where should we be keeping the code ?

Thanks & Regards,

Sudhir.

ravi_chandra3
Active Contributor
0 Kudos

Hi

Collect those long description data in 5 different IO and then concatenate all those data into one using VB Macro at Analyzer level.

MGrob
Active Contributor
0 Kudos

Hi

60 char is the limit. You need to split the text onto 5 different infoobjects and cut of each 60 characters into each object. It's the only way to store those long texts..

hope that helps

Martin

RamanKorrapati
Active Contributor
0 Kudos

Hi Pani,

Yes, bw side info object max length is 60 only. as per your requirement also you have a solution. you may need to use 4 or 5 info object which can be each length 60 or 50 and all 4 objects need to group them as one. there are very well maintained docs are available on google.

Search on google with term " Long text in sap bw: modelling". you will get a wondeful doc maintained by Eugene.

Thanks

former_member199945
Active Contributor
0 Kudos

Hi kodanda Pani,

BI Has a limitation for IOBJ max we can Provide length 60.

if you want to perform additionally more than this length,

2 good documents in SCN  related to iobj length , How can we increase Search in google as

1.Long texts in SAP BW: Modeling

2.The 60 Character Restriction for BW Data Models

Regards,
Seshu.P

former_member182196
Contributor
0 Kudos

This message was moderated.

former_member183012
Active Contributor
0 Kudos

Hi Pani,

Whatever your understanding about BI infoobject length is perfect..

Regards,

Ganesh Bothe

former_member976
Active Contributor
0 Kudos

Thanks for ur replay,

but user wants total description in report level then how to do?

our source side some records have 250 char (long text)

former_member183012
Active Contributor
0 Kudos

Hi Pani,

Any how you want achive this then check satendra's link..that is the only way

Regards,

Ganesh Bothe

Prabhith
Active Contributor
0 Kudos

Hi ,

Apart from all other replies, just  some additional information:

Happened to see some where that, with BW7.4 SP 5 on HANA, SAP is trying for the below things:

Overcome the 60 characters limitation for additional flexibility

Extend length for Characteristics values
--> The maximum output length and attribute length can be <= 250
--> 250 characters applies for the total (compound) length of the key

Extra long texts for Characteristics
--> Long text can be stored as CHAR 60 (standard) or CHAR 1333 (option ‘Long text is XL’ set).
--> No changes on frontends required
--> Simple switch for existing Characteristics possible

BR
Prabhith