cancel
Showing results for 
Search instead for 
Did you mean: 

Need to Change the Data type and length of field in datasource in sap bi.

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (3)

Answers (3)

Former Member
0 Kudos

Thank you everyone for your time to reply. Your inputs have helped me.

Regards,

Adhvi

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.