Skip to Content
author's profile photo Former Member
Former Member

BPC NW 7.5: error while loading transaccional data from BW

hi bpc experts:

I m on BPC NW 7.5 SP11, I m setting the load data package for transaction data (which came from BW), my transformation file is this:

****************************************************************************************************

*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=YES
MAXREJECTCOUNT=
ROUNDAMOUNT=

*MAPPING
C_ACCT =ZGLACOUNT
C_CATEGORY =*NEWCOL(IFRS)
C_DATASRC =*NEWCOL(DS_ENTRADA)
ENTITY =0COMP_CODE
FLOW =*NEWCOL(F_100)
GROUPS =*NEWCOL(NO_GRUPO)
INTCO =0COMPANY
RPTCURRENCY=0CURKEY_LC
TIME =0FISCPER
USEGMENTO =ZSEG_CON
SIGNEDDATA =ZBAL_ML

*CONVERSION

****************************************************************************************************

while validating (or executing the package) this transformation file it fails, the log says : the number of rejected registers exceed the max (501).

On the rejected list show this :

1 ,1105100000,IFRS,DS_ENTRADA,01,F_100,NO_GRUPO,,COP,2012003,,1047300.00-

Line1 :Dimensión: miembro ENTITY: 01 no es válido o es miembro calculado (not valid or calculated member)

1 ,1105100000,IFRS,DS_ENTRADA,01,F_100,NO_GRUPO,,COP,2012003,,1047300.00-

Line1 :Dimensión: miembro INTCO: NO_GRUPO no es válido o es miembro calculado (not valid or calculated member)

1 ,1105100000,IFRS,DS_ENTRADA,01,F_100,NO_GRUPO,,COP,2012003,,1047300.00-

Line1 :Dimensión: miembro TIME: 2012003 no es válido o es miembro calculado (not valid or calculated member)

1 ,1105100000,IFRS,DS_ENTRADA,01,F_100,NO_GRUPO,,COP,2012003,,1047300.00-

Line1 :Dimensión: miembro USEGMENTO: 2012003 no es válido o es miembro calculado (not valid or calculated member)

As you can see , the validation tells me that some members does not exist but they are, for example on my Entity dimension I have 01, but the log says that it doesnt exist, why it could be?

The same for Time dimension, Also it looks strange that tries to read NO_GRUPO for INTCO dimension, if on the mapping section I set INTCO =0COMPANY.

Pls some help

regards

jav

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2012 at 04:20 AM

    Hi Joe,

    Please make sure that the format of BPC member is same as that of BW master data. If not, you need to use the conversion file to map the different members for each of the dimensions.

    Also, ensure that the data is loaded only on the base level members. The data should never be loaded into the parent nodes or any member with dimension formula.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2012 at 05:17 AM

    Hi Joe

    Try using "DELIMITER =" instead of "DELIMITER = ," in Options.

    Regards

    Jigar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.