Mapping the fields in Transformation file

[Former Member]

Hello,

how to map the following scenario in transformation file.

Target Fields:

ID

ACCTYPE

DIMLIST

EVDESCRIPTION

Source Fields:

ID

EVDESCRIPTION

My current transformation file is as below:

ID=*COL(1)

EVDESCRIPTION=*COL(4)

The id values are populated into ID column however the EVDESCRIPTION field remains empty.

so how to handle the mapping.

Regards

[Jeffrey_Holdema]

Use *NEWCOL( ) and fill in a constant value within the parenthesis for the two dimensions in the target which are not in the source.

For example,

ACCTYPE=*NEWCOL(EXP)

Best regards,

[Jeffrey Holdeman|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/jeffrey+holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group

[Former Member]

Hi,

Thanks.

Is it possible to pass blank values instead of some constant value which is not really helpful in my case.

Regards

[Jeffrey_Holdema]

Yes, I think so. Just try *NEWCOL( )

Best regards,

Jeffrey Holdeman

Enterprise Performance Management

Regional Implementation Group