Skip to Content
0
Former Member
Jul 01, 2015 at 06:01 AM

Import BW Master Data Transformation and Conversion

27 Views

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?