Import BW Master Data Transformation and Conversion

[Former Member]

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?

[JohnL · Accepted solution]

Hi Paul,

Can you review these sections:

41.6 Data Transformations and Conversions and 41.6.1.1.3 Transformation File: Conversion Section in the EPM Add-IN Help file:

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

Also look at these How to guides: http://search.sap.com/ui/scn#query=Master+Data+Loads&startindex=1&filter=scm_a_site(scm_v_Site11)&fi...

Read this one too: http://scn.sap.com/docs/DOC-4221

[former_member186338]

Hi Paul,

But why not to test it yourself?

Vadim

[Former Member]

Perhaps because testing is time-consuming and expensive and asking a question takes a few minutes. Isn't that why we're here?

[former_member186338]

But without self testing you will stay with zero knowledge in BPC forever

[Former Member]

I didn't say I never test. I do. But testing is expensive and time consuming,and can be avoided if I can get an answer to a question, as John Leggio so kindly provided.