Mapping of Source field and infoject in BI

[pavneet_rana]

Hi to all,

Can any one suggest me any solution on below example.

Example: We are mapping FIELD1 from Source to INFO1 infooject in BI.

But the Source FIELD1 have Data type of length 13 and decimal 2 and INFO1 infoobject in BI have Data type of length 17 and decimal 2.

Do to this field length we getting minute mismatch in BI for infoobject INFO1.

Is there any possiblity, that  we can change FIELD1 Data type length from 13 to lenght 17 , at Datasource level at BI.

or is there any soultion for this issue.

Regards

Pavneet Rana

[Former Member · Accepted solution]

you could write a code in BW in its transformation to ignore the field and make it length 13 with decimal 2. this way it will fix it for you, have you tried that ?

like you could take the source field and input it in another field and do

shift " your variable name" right deleting trailing space. this wilk move it to right deleting spaces or you could move it to left..

and have the save data as your result.

[pavneet_rana · Accepted solution]

Thansk for replying.

Please can suggest me what to do if,

Initially we are mapping FIELD1 from Source to INFO1 infooject in BI.

But the Source FIELD1 have Data type of length 13 and decimal 2 and INFO1 infoobject in BI have Data type of length 17 and decimal 2.

Now of i replace INFO1 infoobject mapping with INFO2 infoobject in BI.

it mean now INFO2 infoobject which have data type of lenght 13 and decinal 2 is mapped with Source field FIELD1.

Then how to Proceed in BI Porduction System.

Flow in BI =  Zdatasource(generic datasource) -> DSO1 -> CUBE1-> MP1

so if we are chaning the mapping for INFO1 infoobject mapping with INFO2 infoobject in BI in DSO1

and CUBE1 level.

Then do we need to delete the data in DSO1 and CUBE1 and then do mapping change, also do we need to reinitialize the DSO1 again after full load etc.

Please can any one tell me process step via step.

i shall be thankful to you for this.

Regards

Pavneet Rana

[Former Member · Accepted solution]

so once you assign the new field, yes you wil need to reload the data, so you will need to delete all the data from your DSO and reload everything. firstload in PSA before your delete the data from your DSO.make sure the new field does get populated in the PSA first. if it loads good then load it in your dso and activate it. once its good then delete data from the cube and send data to you cube.

[naresh_babu3]

Hi,

Is Field 1 is standard or Custom Field, If it is Custom Field yes you can change it in Datasource Level.

If it is Standard one, you cannot change the Length.

Naresh