cancel
Showing results for 
Search instead for 
Did you mean: 

How to change unknown master code to dummy code while import transaction data from bw using conversion file

Former Member
0 Kudos
121

hi expert

please let me know How to change unknown master code to dummy code while import transaction data from bw using conversion file

for example)

source data

C001 1,000

C002 1,000

C003 1,000

C004 1,000

C005 1,000

C006 1,000

C007 1,000

Entity Dimension

C001

C002

C003

C004

C005

CDMY

Changed(imported) data

C001 1,000

C002 1,000

C003 1,000

C004 1,000

C005 1,000

CDMY 2,000

I like to change not registered entity code to dummy entity code

Is there any way to change master code using Conversion File ?

OR NOT

Please tell me how to ..

thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

The master data of the dimension cannot be changed using the conversion file. In your dimension, you will need to maintain the master as

Entity Dimension

C001

C002

C003

C004

C005

CDMY

In the conversion file, you need to have:

INTERNAL     EXTERNAL

C001               C001

C002               C002

C003               C003

C004               C004

C005               C005

*                    *SKIP

Hope this helps.

Former Member
0 Kudos

INTERNAL     EXTERNAL

C001               C001

C002               C002

C003               C003

C004               C004

C005               C005

*                      CDMY

IT WORKS !

THANKS

Former Member
0 Kudos

Hi,

Yes, it would be CDMY.  Typing mistake

Answers (0)