on 05-27-2011 4:11 PM
Hi,
I want to know how to edit the Data type and Length of the Field in the datasource in SAP BI.
Scenario:
The datasource has been enhanced with the Fields and replicated to the BW system and working fine.
Now i have to change the Data type ( From Numc to Char) and length ( 15 to 25 ) of the particular field in the datasource.
What the things which i need to take care and how this can achieved?
Thank you in advance
Regards,
Adhvi
hi,
Rather than changing the Data type in the data source, use the Data type you want to use (char) in DSO and map it with Numc Data type in transformations. This way your Data sources will be in sync between source system and BW.
regards,
Arvind.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you everyone for your time to reply. Your inputs have helped me.
Regards,
Adhvi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have to map your field from dataosurce to any field in DSO or cube via transformation, so create custom filed as per your data type & length or you can change field in dta type & length to which you want to map.
Better do not change in ECC side, where as it may effect to all other objects which it was in use.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Depends on type of the datasource. If its Std, Custom on View/Table, you can not. You would have to change that field in the system itself.
If it is Custom based on FM, then can change in RSO2/RSA6.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.