amount multiplied by 100 after loading from BW Infoprov

[a_khanevich]

Hello!

I'm loading transactional data from BW to BPC by standard DM Package (/CPMB/LOAD_INFOPROV_UI).

I have the following direct assignment in the transformation file:

*MAPPING

SIGNEDDATA=ZFS_SUMRU

"ZFS_SUMRU" is a BW keyfigure with fixed currency.

After loading there is "1000" amount in BPC if it is "10" amount in BW-infocube.

What is the problem?

[bishwajit_das · Accepted solution]

Hi,

Please find the following notes :-

2080482 - Conversions of currencies are not applied when data are loaded to BPC through the data package "Load Transaction Data from BW InfoProvider UI"

1804424 - Transaction data loaded from ECC to BPC multiplied by 1000.

I think the simplest way is to maintain the BPC conversion file for Currency as -

EXTERNAL     INTERNAL     FORMULA

JPN                    JPN               VALUE*0.01

Regards,

Bishwajit

[Former Member]

Hi,

Do you have start or end routine in your transformation file?

Andy

[a_khanevich]

Options section is by default:

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

[Former Member]

Hi,

Also check what your are loading, it might be the sum of 100 records.

Check the granularity of your data, incorrect mapping or insufficient mapping can cause the summation.

Andy

[Shrikant_Jadhav]

Hi,

Check data in BW for ZFS_SUMRU by selecting required info object, do the same for BPC cube and compare the result.

Shrikant 

[a_khanevich]

I have a small amount of records just for testing purposes in which the source key field combination is represented by just one record.

[a_khanevich]

[Shrikant_Jadhav]

Hi,

Can you try this- modify BW data record value e.g. 1 and again load it to in to BPC.

[gregor_dieckmann]

Hi,

it seems that BPC ignores the so called 'currency shift' used in BW and Business Suite. With the key figure value alone one cannot know what the real value is, this depends on the currency. Table TCURX contains the exceptional currencies and their decimals; default is decimals = 2 (these currencies are not in TCURX).

Examples:

1 EUR in the fact table of an InfoCube is 1.00 (default decimals = 2)

1 JPY in the fact table of an InfoCube is 0.01 (TCURX decimals = 0)

Since BPC does not use currency/unit BW dimensions you have to do the currency shift.

Regards,

Gregor

[Former Member]

Hi,

There are two ways to match with BPC in case of JPY or any other such currencies

1) Create a BEx report and match BPC data with that.

2) Dont check setting "Do not use any conversion" when you display data of BW object.

Thanks

Obaid

[a_khanevich]

Hi!

How to handle this scenario in terms of "best practice" when integrating BW and BPC?

[Former Member]

Hi Aleh,

I would think that if the currency is JPY (example above) then you divide the amount by 100 in your conversion file.

Andy

[a_khanevich]

It's not a general rule. What if data region consists of currencies with different number of decimals?

[Former Member]

You need to add a check in the transformation file, for those specific currency you apply the rule divide by 100. everything else should stay the same.

[Shrikant_Jadhav]

Hi,

check your conversion file. Is there any formula ?

Also check in default logic whether you have written anything for multiplication.

Share your transformation and conversion file.

Regards,

Shrikant

[a_khanevich]

I have no conversion file and default logic in this scenario.