BPC 10.0 Unsuccessful Currency Translation

[former_member332601]

Hi,

I cannot translate values in Consolidation model. In package log I get successful status, but no records are red, so no records are transferred.

What I’m willing to do is to translate values from 10.2014 entered as EUR into values in USD also for 10.2014.

TIME: “10.2014”

SCOPE: “Europe”

INTERCO: “Germany”

FLOW: “B/S or P&L balance”

ENTITY: “Germany”

AUDITTRAIL: “Input”

ACCOUNT: “BS111” and “PL010”

RPTCURRENCY: “EUR”

C_CATEGORY: “Actual”

Please see my configuration in screenshots below. All advices are welcomed.

There are two models Consolidation and Rates model.

My logic script.

Rates and data are already available in models.

The local currency for entity DE is set for EUR.

Settings for most important dimension properties.

Should be this formula in business rule in square brackets [] or not?

When I run package I set prompts like below:

No rows are submitted and I don't know why?

How to get to this log file?

BPC version for NetWeaver

#currency translation #currency transformation #0 Submitted #BPC 10.0

[former_member332601 · Accepted solution]

Hi,

the issue was that transaction values were saved to database in inappropriate context/page axis definition. All transaction values has to be entered for Group/Scope dimension set to NONE dimension member. It has dimension property CURRENCY_TYPE property = "N", thus it is possible to run translation correctly.

Regards,

Bartosz

[Former Member]

Hi Bartosz,

Your screen shot helped eliminate some possibilities, but an important area that you may want to check, if you haven't done so already, is:

• Verify that RATETYPE Property of ACCOUNT Dimension members with IDs  “BS111” and/or “PL010” is "CLO".
  

System does not convert currency of Accounts for which, corresponding to its Rate type property, Currency Translation Rules is not maintained.

PS: FORMULA must be enclosed in square brackets, so that's not an issue.

Hope this helps.

Regards,
Rajesh

[former_member332601]

Hi Rajesh,

thank you for the response. I've already set this as on screenshot before.

BTW, I also changed system_constants.lgf (Tcode -> UJFS) file to be compatible with changes within my environment. Unfortunately currency conversion still doesn't work as it should be.

Regards,

Bartosz

[bishwajit_das]

Put , INCREMENTAL MODE = X

Try this...

Regards,

Bishwajit

[former_member332601]

Hi Bishwajit,

I already tried to add this parameter to logic script to be sure that all records are processed - with no success.

Regards,

Bartosz