Loading master data from an info object BW)into an BPC dimension

[Former Member]

Hello Experts,

I'm trying to load master data  Infoobject (ZACCOUNT) from BW to BPC Dimension while doing validation &process transformation file getting below error.

Please suggest where I'm doing wrong .

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

ID=ID

ACCTYPE=ID(1:2)

RATETYPE=*STR(AVG)

	ValidateRecords = YES
	Error in Admin module or a component used by Admin module
	Member '410000' attribute value is invalid: 'ACCTYPE' = '41'.
	Member '510000' attribute value is invalid: 'ACCTYPE' = '51'.
	Member '520000' attribute value is invalid: 'ACCTYPE' = '52'.
	Member '530000' attribute value is invalid: 'ACCTYPE' = '53'.
	Member '540000' attribute value is invalid: 'ACCTYPE' = '54'.
	Member '550000' attribute value is invalid: 'ACCTYPE' = '55'.
	Member '560000' attribute value is invalid: 'ACCTYPE' = '56'.
	Member 'G4_GM' attribute value is invalid: 'ACCTYPE' = 'G4'.
	Member 'G4_NI' attribute value is invalid: 'ACCTYPE' = 'G4'.
	Member 'G4_PTI' attribute value is invalid: 'ACCTYPE' = 'G4'.
	Member 'G5_OPEX' attribute value is invalid: 'ACCTYPE' = 'G5'.
	Validation with data file failed

[former_member193143]

Hello Sriram,

First you have to know about what are different account types are used in BPC. refer below link as reference the you will get some idea.

And Second we cannot use acctype blindly for all account members, its depends on organisational perspective, based on the nature of account members we will use the acctype.

Mapping section which you are mention above is little strange for me, can you please explain your business scenario..?

     ACCTYPE=ID(1:2) its completely wrong because as Vadim said its not possible to use like that. Its standard and you need to use any one of these AST, LEQ, INC, EXP

Thank you very much..

Best Regards,

Saida Reddy Gogireddy