on 11-25-2013 10:01 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Collect those long description data in 5 different IO and then concatenate all those data into one using VB Macro at Analyzer level.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pani,
Whatever your understanding about BI infoobject length is perfect..
Regards,
Ganesh Bothe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.