Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Import BW Master Data Transformation and Conversion

This is the *CONVERSION section of one of a transformation file I am reviewing:

*CONVERSION

ID=C_Doctor_ZBPC_DR.xls

ISINACTIVE=C_Doctor_ZBPC_DR.xls!ISINACTIVE

The Target Dimension is called Doctor. The Conversion file itself has two sheets. One is called Conversion and the other is called ISINACTIVE.

ISINACTIVE is an attribute in the Doctor dimension.

They sheets contain:

Conversion sheet:

------------------------

EXTERNAL     INTERNAL                                                   FORMULA

*                       js:%external%.toString().replace(/\s+/g,"")

ISINACTIVE sheet:

-------------------------

EXTERNAL      INTERNAL                                                   FORMULA

Y                      *SKIP

My questions are:

1. Can a conversion files be applied to attributes in the destination like this? My understanding is they can only apply to the ID field for a dimension.

2. The first line in the *CONVERSION section does not reference a sheet. Will it just pick the first one or ignore it?

3. Nothing references the sheet containign the java script. Will it be applied?

Former Member
replied
Not what you were looking for? View more on this topic or Ask a question