BPC 10.1 SP05 - Currency Conversion Issues

[former_member192555]

Hi Experts,

I am struggling with FX Restatement/Currency Conversion of BPC 10.1 SP05 NW HANA. First I started with model I created, but I thought I did something wrong even though it is not my first time I am configuring FX restatement. But it is first time in 10.1.

Then, I switched to the predelivered models in EnvironmentShell - Consolidation and Rates where I only add FXTRANS and corrected the DIM in Data Maanger package for Currency/Group. I am not able to do FX translation. Do you experience the same?

Here is what I did.

1. This is my FXTRANS:

*RUN_PROGRAM CURR_CONVERSION

  CATEGORY = %CATEGORY_SET%

  CURRENCY = %RPTCURRENCY_SET%

  TID_RA = %TIME_SET%

  RATEENTITY = GLOBAL

  OTHER = [ENTITY = %ENTITY_SET%]

  INCREMENTAL_MODE =

*ENDRUN_PROGRAM

2 Checked the predelivered Business Rules in Consolidation

3. Entered Rates in rates model

4. Entered through Input Form info in LC

5. Corrected the DM for FX changing the DIM of Group with Currency

6. Execution, but always get - 0  SUBMITTED, 0  SUCCESS, 0  FAIL.

Here is the SP of the components.

[former_member192555 · Accepted solution]

Hi,

I am still struggling with finding a reason why the currency conversion is not working. I found that when I have data other then zero and run a CURR_CONVERSION the data is turned to zero.

Here is what I have:

When I run Currency_coversion I get following result. The data region is turned to zeroes.

When I run again Currency_coversion I get - 0  SUBMITTED, 0  SUCCESS, 0  FAIL.

Any guesses are welcome?

[Former Member · Accepted solution]

Did u try running it in Full Mode instead of Incremental ?

[former_member192555 · Accepted solution]

Hi Rakesh,

Yep, INCREMENTAL_MODE = X

[former_member200459 · Accepted solution]

Hi,Emiliyan Tanev

Please refer to SAP note 1650709 and 2101349 to double check your configurations.

It should work.

[former_member192555 · Accepted solution]

Hi Fred,

Thank you for those Notes, but unfortunately, they did not help me.

btw. If you are interested, I could give you temporal access (training system). Just write me on Contact Me

Thanks,

Emiliyan

[former_member225135 · Accepted solution]

Hi Emiliyan,

Just a quick check, are you using Entity FX Type property in Entity Dimension.

If yes, then correct your script as:

RATEENTITY=                   instead of RATEENTITY=GLOBAL

Regards,

Rahul

[former_member192555 · Accepted solution]

Hi Rahul,

Thank you for helping. Yep, I am using FX_TYPE in ENTITY dimension. I did what you recommended, but still it is not working.

Here is the code I had:

*RUN_PROGRAM CURR_CONVERSION

   CATEGORY = %C_CATEGORY_SET%

   CURRENCY = %RPTCURRENCY_SET%

   TID_RA = %TIME_SET%

   RATEENTITY =

   OTHER = [ENTITY = %COMPANY_SET%]

   INCREMENTAL_MODE = X

*ENDRUN_PROGRAM

It is really strange what the system is currently doing. If there are no records in Reporting Currency - USD, then I get - 0  SUBMITTED, 0  SUCCESS, 0  FAIL. If there are records in USD, then all of them are converted to nulls 42  SUBMITTED, 42  SUCCESS, 0  FAIL.

Best Regards,

Emiliyan

[former_member186338 · Accepted solution]

Hi Emiliyan,

CURR_CONVERSION works without any issues for everybody. In your case the reason can be:

1. Missing data (rates...)

2. Incorrect currency conversion setup

3. Incorrect BPC setup or incomplete SP upgrades.

You can find the reason if you debug in ABAP the CURR_CONVERSION execution.

Vadim

[former_member192555 · Accepted solution]

Hi Vadim,

I found my problem when I started the UJKT/debugging in ABAP. The problem was so, so stupid. I had an error in RATEENTTIY ID. I wrote it with capital letters instead of normal first capital and the rest - lowercases.

*RUN_PROGRAM CURR_CONVERSION

   CATEGORY = %C_CATEGORY_SET%

   CURRENCY = %RPTCURRENCY_SET%

   TID_RA = %TIME_SET%

   RATEENTITY = GlobalGLOBAL

   OTHER = [ENTITY = %COMPANY_SET%]

   INCREMENTAL_MODE = X

*ENDRUN_PROGRAM

[Former Member]

Hi,

in your example you show data on accounts BS111, BS222, PL310, PL010 and PL020. What is the rate type associated with those accounts in your chart of accounts? And what are the business rules for those ratetypes? Also, do you use a flow type Dimension? And how are the entities defined that hold the data?

BR,
Arnold

[former_member192555]

Hi Arnold,

Thank you for you help. I found the problem. It was in the RATEENTITY ID.

BR,

Emiliyan

[former_member186338]

Can you show UJKT log...

Vadim

[former_member192555]

Hi,

First time using it, but for the tests I hardcoded the Members:

LGX:

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = ACTUAL

CURRENCY = USD

TID_RA = 2015.01

RATEENTITY = GLOBAL

OTHER = [ENTITY = DE]

INCREMENTAL_MODE = X

*ENDRUN_PROGRAM

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

FILE:\ROOT\WEBFOLDERS\TEST_CONSOL \ADMINAPP\Consolidation\TEST.LGF

USER:BPC

APPSET:TEST_CONSOL

APPLICATION:Consolidation

RUN CURRENCY CONVERSION

UJP_PROCESS_EXCEPTION:No suitable category found in application Consolidation

I did not change anything in Category DIM.

[former_member186338]

The member ID's are case sensitive!

Use Actual instead of ACTUAL!

Vadim

[former_member192555]

LGX:

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = Actual

CURRENCY = USD

TID_RA = 2015.01

RATEENTITY = GLOBAL

OTHER = [ENTITY = DE]

INCREMENTAL_MODE = X

*ENDRUN_PROGRAM

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2015-05-22 11:41:28

FILE:\ROOT\WEBFOLDERS\TEST_CONSOL \ADMINAPP\Consolidation\TEST.LGF

USER:BPC

APPSET:TEST_CONSOL

APPLICATION:Consolidation

RUN CURRENCY CONVERSION

0  SUBMITTED, 0  SUCCESS, 0  FAIL.

SCRIPT RUNNING TIME IN TOTAL:1.00 s.

LOG END TIME:2015-05-22 11:41:28

[former_member186338]

And do you have data?

*XDIM_MEMBERSET CATEGORY=Actual

*XDIM_MEMBERSET TIME=2015.01

*XDIM_MEMBERSET RPTCURRENCY=LC

*XDIM_MEMBERSET ENTITY = DE

*WHEN TIME

*IS *

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

Result?

[former_member192555]

Here is it

LGX:

*XDIM_MEMBERSET CATEGORY=Actual

*XDIM_MEMBERSET TIME=2015.01

*XDIM_MEMBERSET RPTCURRENCY=LC

*XDIM_MEMBERSET ENTITY = DE

*WHEN TIME

*IS *

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2015-05-22 11:53:37

FILE:\ROOT\WEBFOLDERS\TEST_CONSOL \ADMINAPP\Consolidation\TEST.LGF

USER:BPC

APPSET:TEST_CONSOL

APPLICATION:Consolidation

[INFO] GET_DIM_LIST(): I_APPL_ID="Consolidation", #dimensions=10

ACCOUNT,AUDITTRAIL,CATEGORY,ENTITY,FLOW,INTERCO,MEASURES,RPTCURRENCY,SCOPE,TIME

#dim_memberset=4

CATEGORY:Actual,1 in total.

TIME:2015.01,1 in total.

RPTCURRENCY:LC,1 in total.

ENTITY:DE,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1.00 ms. 14  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

14  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 14  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

ACCOUNT AUDITTRAIL CATEGORY ENTITY FLOW INTERCO RPTCURRENCY SCOPE TIME SIGNEDDATA

BS111 Input Actual DE Balance ThirdParty LC S_None 2015.01 0.00

BS121 Input Actual DE Balance ThirdParty LC S_None 2015.01 111.00

BS122 Input Actual DE Balance ThirdParty LC S_None 2015.01 0.00

BS211 Input Actual DE Balance ThirdParty LC S_None 2015.01 0.00

BS212 Input Actual DE Balance ThirdParty LC S_None 2015.01 - 111.00

BS213 Input Actual DE Balance ThirdParty LC S_None 2015.01 0.00

BS214 Input Actual DE Balance ThirdParty LC S_None 2015.01 0.00

PL010 Input Actual DE Balance ThirdParty LC S_None 2015.01 0.00

PL020 Input Actual DE Balance ThirdParty LC S_None 2015.01 - 111.00

PL110 Input Actual DE Balance ThirdParty LC S_None 2015.01 0.00

PL120 Input Actual DE Balance ThirdParty LC S_None 2015.01 0.00

PL310 Input Actual DE Balance ThirdParty LC S_None 2015.01 0.00

PL320 Input Actual DE Balance ThirdParty LC S_None 2015.01 111.00

PL330 Input Actual DE Balance ThirdParty LC S_None 2015.01 0.00

14  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:1.00 s.

LOG END TIME:2015-05-22 11:53:37

[former_member186338]

Well, nothing wrong...

Then you have to check all settings required for currency conversion...

Vadim

[former_member192555]

Hi I checked them. I have followed everything written in BPC440. I am starting to think either something has changed in 10.1 SP05 or it is a bug. Unfortunately didn't find any SAP note regarding this issue.

[former_member190501]

Hi,

How about Time dimension properties?

Thanks,

Raju

[former_member192555]

Hi,

I am using the predelivered copied from the EnvironmentShell. In my case I am playing with 2015.01

[former_member190501]

Hi,

Can you replace INCREMENTAL_MODE =

with

INCREMENTAL_MODE = $INCREMENTAL_MODE$

and do relevant changes in DM script logic as mentioned in note 1896542  - How to make incremental mode selectable in data manager

Thanks,

Raju

[former_member192555]

Hi,

The note is for BPC 10.0.