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

[Former Member]

Hi Sriram,

It is better if you can provider a Screen-shot of Info-Object(ZAccount) Display Data . So that we can suggest you the corrections needed in the transformation file.

Aravind

[former_member186338]

In BPC the ACCTYPE can be only INC,EXP,AST,LEQ!

Vadim

[Former Member]

Hi Vadim

I have changed  mapping stillgetting below error

*MAPPING

ID=ID

ACCTYPE=ID(INC:EXP:AST:LEQ)

RATETYPE=*STR(AVG)

	[line 15] Unexpected 'INC' at position 4 in the mapping formula [ID(INC:EXP:AST:LEQ)]: 'INT' is expected
	Validation of mapping failed; check the worksheet for highlighted errors
	Validating conversions...
	Validation of the conversion was successful
	Saving transformation file failed

Sriram

[Former Member]

Hi Sriram,

You need to ask your finance people which accounts are INC, EXP, and so on.

then use conversion file to assign the correct account type to each member.

Andy

[former_member186338]

Sorry, but what do you mean by this syntax: ACCTYPE=ID(INC:EXP:AST:LEQ)???

Please read help about transformation and conversion

Vadim