Tranformation Validation Error

[former_member230848]

Hi Experts,

I am loading   master data load  for COSTCENTER ,while validation error occurs: "Validate data load fail ".

After that I have tried to load selcetive attributes and  hierarchy one specific record loaded.But while loading overall and Data Manager package running  fail status with this error occurs :

No 1 Round:

Error in Admin module or a component used by Admin module

Dimension member  is an invalid member ID

model: Revenue. Package status: ERROR

I have seen lot of threads ,but  hierachy is compulsory to choose in this context,right now we are not selecting.

Please advice on this.

Regards

Vadan

[Former Member]

Hi Vadan,

Please share your transformation file and error screenshot. Refer below document throughly for more information

http://sapassets.edgesuite.net/sapcom/docs/2015/08/26ef2552-557c-0010-82c7-eda71af511fa.pdf

Also check if you have any Blank ID or field in Costcenter object which is causing the error.

Regards,

JP

[former_member230848]

Hi JP,

Thanks for resp,please find screens

[Former Member]

HI Vadan,

Does your cost center object has any compounding object? Check that..If yes...refer my above link to give the mapping. And I think there are balnk fields in the objects. So write the mapping for ID as

ID=IF(ID=*STR() THEN *STR(C_NONE);ID)

Regards,

JP

[former_member186338]

In your conversion file you perform only space replacement in the ID. But any other incorrect symbol will be passed.

[former_member230848]

HI Vadim,

In conversion  fine  while error occurs  : Detected duplicate member ID '0000030100' I have appliesd skip parameters,nothing showing.Only data validation error occurs.

Thanks for your response

Regards

Vadan

[former_member230848]

Hi JP ,

The COSTCENTER  have  compounding attribute CO_AREA, but I didn't define as a property for Dimension.I will check with this ID option  and reviewed the link also,thankyou.

Reg,

Vadan

[former_member186338]

Use external to import master data without 0000...

[Former Member]

Yes plaese read the document....As compounding objects are not be defined as property but while loading master data you have to define it....like

ID=0CO_AREA+ID

Regards,

JP

[former_member230848]

Yes Vadim ,

I am using External Import ,no luck.

R

Vadan

[former_member186338]

Then you have some ID in BW that is incorrect for BPC (not allowed characters)...

[former_member230848]

Hi Vadim ,

Could you please explain how to sort out this issue  at BW and BPC level.Thankyou

R

Vadan

[former_member186338]

Just ask BW person to help you!

[former_member230848]

Hi ,

I have tried this ID option defined as : ID=*IF(0COSTCENTER=*STR() THEN *STR(NO_CC);0COSTCENTER)

but its again showing  Error : Field Name  0COSTCENTER  does not exist.

I am choosing this Infoobject while validation .No luck.

R

Vadan

[former_member186338]

Sorry, but the proposal was ID=IF(ID=*STR() THEN *STR(C_NONE);ID)

[former_member230848]

Hi Vadim ,

I have tired that way but the ID position  is getting issue,its showing unexpected error .

Reg,

Vadan

[former_member186338]

Sorry, but absolutely not clear! Screenshots etc... required!

[former_member186338]

Sorry Vadan, but it's not possible to help you without all details. The error means that some ID is invalid - containing invalid characters or...

- incorrect transformation file

- incorrect conversion file