Error in transaction data upload in BPC 10.0 (NW)

[former_member212095]

Hello

I am trying to upload transaction data upload.

However, I am getting an error "Validation with data file failed"

Below is the screenshot:

I am unable to see the error.

Regards,

gaurav

[former_member599120 · Accepted solution]

Hi Gaurav,

Please take a look at Red Color dimension name, If you would like to hard code dimension member you could try this: RPTCURRENCY=*STR(SAR) or refer technical name RPTCURRENCY=0CURRENCY.

Thanks,

Wandi Sutandi

[former_member212095 · Accepted solution]

Hi

I have changed the RPTCURRENCY

Still I am getting the same error

[Former Member · Accepted solution]

Hi,

you haven't changed the conversion entry ... as said above, it should reference the file and sheet.

Regards,

Arnold

[former_member212095 · Accepted solution]

Hi Arnold

Please see the below changes I have done based on your suggestion.

Still I am getting the same error

[Former Member · Accepted solution]

Hi,

do you tkae the data directly from the table or do you export the data into a flat file first?

Regards,

Arnold

[former_member212095 · Accepted solution]

Hi Arnold,

I am taking directly from Infocube ZBPC_C01 via table and not from Flat file

regards,

Gaurav

Message was edited by: Gaurav Tipnis

[Former Member · Accepted solution]

Hi Gaurav,

could you try to set

VALIDATRECORDS=NO

MAXREJECTCOUNT=1000000

and try again.

Regards,
Arnold

[Former Member · Accepted solution]

Hi Gaurav

As suggested by Arnold modify the option & also refer below option which is more standard while pulling data from cube.

Check the DELIMITER value

JAck

[brahmareddy_kolli · Accepted solution]

Hi,

Please check your FUNCTIONAL_AREA Dimension, Please maintain one new conversional file for functional area. Its should work now.

With Regards

Brahmareddy Kolli

[former_member212095 · Accepted solution]

Hi BK

I have removed the functional area from my model and now I am able to load Transaction data from BW.

I have 1 GL ID bifurcated into 2 functional area (for eg. Salary is shown under selling & dist. as well as under general admin expenses)

I have created Functional area dimension and also mapped it with 0FUNCAREA.Now I want to upload transaction data.I want to knw how data will be trfrd into above two functional area having same GL ID)

Thanks

Gaurav

[Former Member · Accepted solution]

Hi Gaurav,

instead of mapping ACCOUNT directly from 0GL_ACCOUNT you need to concatenate 0GL_ACCOUNT and 0FUNCAREA and use the resulting string in a conversion file to find out the correct BPC account.

So GL account 4711 plus functional area SD would be BPC account abc whilst GL account 4711 plus functional area GA would be BPC account def.

Regards,

Arnold

[former_member212095 · Accepted solution]

Hi Arnold

This is exactly what i want.

Can you share how my conversion file will look like.

[Former Member · Accepted solution]

Hi Gaurav,

in the transformation file you would simply concatenate the two, so instead of

ACCOUNT=0GL_ACCOUNT

you would use

ACCOUNT=0GL_ACCOUNT+0FUNCAREA

in your conversion file you would then have

EXTERNAL    INTERNAL

4711SD          ABC

4711GA          DEF

this will make the conversion file very long.

What I sometimes do is use a string in between, so

ACCOUNT=0GL_ACCOUNT+*str(q)+0FUNCAREA

and then in the conversion file work with * for any accounts that are not split by functional area or all data on one functional area regardless of the GL account

EXTERNAL      INTERNAL

4711qSD          ABC

4711qGA          DEF

5813q*               XYZ

*qRD                 GHI

Regards,

Arnold

[former_member212095 · Accepted solution]

HI Arnold

I will go with the second option as u have mentioned it as not so tedious

My doubt is what will my internal be in this case for master data upload.

You have mentioned it as ABC,DEF.I didnt understand what exactly this is.

I will explain you with an example.

My functional areas are 400 & 500 & my GL ID is 400000

So my conversion file will be

EXTERNAL           INTERNAL

400000q400           ?????

400000q500           ????

Regards

GT

[Former Member · Accepted solution]

Hi Gaurav,

the internal bit is the BPC account code you want the data to be loaded to.

Regards,

Arnold

[former_member212095 · Accepted solution]

Hi Arnold

My C_account dimension comprises of GL Ids only ie 600000 in this case.I also have a Functional area dimension which comprises of functional area only 400 only.

Now suppose I load my transaction data into BPC

My ACCOUNT=0GL_ACCOUNT+*str(q)+0FUNCAREA

Wherein my external number will be

EXTERNAL           INTERNAL

600000q400         ??

Do you mean to say that I have to maintain my master data in my accounts dimension which will be GL ID plus functional area ie 600000400

Please advice

Regards,

GT

[Former Member · Accepted solution]

Hi Gaurav,

so, you have data on GL account 400000 with functional areas 400 and 500. Which BPC account and which BPC functional area should this be loaded to?

If all data from GL account 400000 should always go to BPC account BPPCACCOUNT1, regardless of the functional area in the GL, then you can use a simply and direct mapping as each GL account will always only be loaded to one BPC account.

Similarly, each functional area from the GL would have an equivalent functional area in BPC, so GL functional area 400 would be loaded to BPC functional area BPCFA1 and GL functional area 500 would be loaed to BPC functional area BPCFA2.

In this scenario you would need two conversion files, one for accounts and one for functional areas.

The account one would be

EXTERNAL    INTERNAL

400000           BPCACCOUNT1

The functional area one would be

EXTERNAL    INTERNAL

400                 BPCFA1

500                 BPCFA2

On the other hand, if the data on GL account 400000 should be loaded to different BPC accounts depending on the functional area then you need the concatenation as describe above.

For example, GL account 400000 with functional area 400 should be loaded to BPCACCOUNT1 and GL account 400000 with functional area 500 should be loaded to BPCACCOUNT2. Then your conversion would be

EXTERNAL   INTERNAL

400000q400  BPCACCOUNT1

400000q500 BPCACCOUNT2

Regards,

Arnold