cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

BPC 10.1 Loading MD TEXT of 0VENDOR

Former Member
0 Likes
2,052

Hi Experts

I'm trying to load 0VENDOR's master data text only but correct text not loaded against vendor code.

Transformation file Code:

  *MAPPING
  ID=ID
  SCALING=*NEWCOL(Y)
  NAME=0NAME

Vendor Dimension structure:

After running package (/CPMB/IMPORT_IOBJ_MASTER) maximum Description field are empty or filled with 0VENDOR as shown below:

But in BW it shows correctly as shown below:

Waiting for helpful reply.

Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Likes

Try medium text in Language tab.

Former Member
0 Likes

After selecting medium text 80% values are populated but 20% still not in BPC but in BW these vendor shows there description and name as shown below:

former_member186338
Active Contributor
0 Likes

imran.shafiq

Look on the BW text table for 0VENDOR

Former Member
0 Likes

Vadim Kalinin

0VENDOR text table also shows the description of above samples as shown below:

former_member186338
Active Contributor
0 Likes

May be the items without description are not updated at all? Due to validity range?

Delete 0VENDOR from description and load again.

Former Member
0 Likes

Vadim Kalinin

I tried following 2 options:

1) Delete all the vendors whose description & name are not loaded and load with overwrite option.

2) Delete every thing from vendor dimension and load with overwrite option.

But none of the above options load all vendors description & name into BPC.

former_member186338
Active Contributor
0 Likes

imran.shafiq

Sorry, but I don't like the approach to delete everything, I prefer to work with some particular case!

For example: 0000100067

Can you delete it from BPC dimension and then load again?

Will it come again with empty description?

Former Member
0 Likes

vadim.kalinin

Yes, I also tried selected deletion but result is still same.

former_member186338
Active Contributor
0 Likes

imran.shafiq

Details, screenshots...

Former Member
0 Likes

Vadim Kalinin

Kindly mentioned which screen shots you needed? or which screenshots are missing in my previously provided screen shots?

former_member186338
Active Contributor
0 Likes

imran.shafiq

Sorry, but due to the fact that I can't see your screen then any test have to be described with full details including screenshots.

In general, there is something wrong:

1. You have medium text description of the member

2. You are able to load it after delete of the member - deletion to be confirmed

3. Try to load only single member to see if there are some duplicates

P.S. Look on member table in BW - do you have some duplicates?

4. No description is loaded