Skip to Content

Object length issue in sap bi

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Nov 25, 2013 at 10:04 AM

    Hi Pani,

    Whatever your understanding about BI infoobject length is perfect..

    Regards,

    Ganesh Bothe

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Nov 25, 2013 at 10:13 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 25, 2013 at 10:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 25, 2013 at 10:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 25, 2013 at 11:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 25, 2013 at 12:39 PM

    Hi

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 25, 2013 at 12:44 PM

    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

    Add comment
    10|10000 characters needed characters exceeded