Currency Translation -Reporting type

[former_member200537]

Hi,

We are trying to do currency translation on planning application in APSHELL(SAP Delivered one) applicationset and we maintained all required properties and members for currency translation as mentioned in "How to do Currency Translation for Financial Application using SAP BusinessObjects Planning and Consolidation 7.0 for the SAP NetWeaver Platform" document.When we are running Datamanger "FXRestament" by passing valid values (Entity C9000,Category PLAN,RPT Currency USD,Year 2009.MAY) datamanger is running succesfully but in the formual log we are getting below message and currency translaiton is not happening

APPSET:APSHELL

APPLICATION:PLANNING

RUN CURRENCY CONVERSION

0 SUBMITTED, 0 SUCCESS, 0 FAIL.

SCRIPT RUNNING TIME IN TOTAL:1.97 s.

but in the listcube of planning application we could see data for entity C9000, Category PLAN, RPTCurrency LC,Year 2009.MAY and also exchange rate is mainted for the year 2009 in rate application but currency translation is not happening.

Script logic we used for currency translaiton in planning application is as below

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

OTHER = [ENTITY=%ENTITY_SET%]//For More than one other scope parameters: OTHER = [ENTITY=%ENTITY_SET%;INTCO=%INTCO_SET%...]

*ENDRUN_PROGRAM

Please advise on the above issue.We are using BPC NW7.0 SP07

Thanks

UDAY

[Former Member]

Hello,

We are facing similar issue, What is solution for this problem.

Quick help would be highly appreciated.

Regards,

Ankit Udeshi

[Former Member]

Has anybody found a solution to this issue?  We are having the same problem in BPC NW 7.5 SP12.

Thanks,

Jeff

[Former Member]

Hi Members,

Please find the Sap Note number "1254330 and 1582384".

Hope it solves to u r problem.

Regards,

Srinivasan.

[Former Member]

check following -

1. Category Dimension - YEAR should be same as in TIME dimension. It must be 'numeric'

2. Enter following in FXTRANS.LGF -

*SELECT(%RPTCURRENCYVARIANT%, "ID" , "RPTCURRENCY", "[CURRENCY_TYPE]='R'")    
*RUN_PROGRAM CURR_CONVERSION
       
     CATEGORY = %CATEGORY_SET%
     TID_RA = %TIME_SET%
     CURRENCY = %RPTCURRENCYVARIANT%
     RATEENTITY = GLOBAL
     OTHER = [ENTITY=%ENTITY_SET%]
*ENDRUN_PROGRAM

Hope this helps.

[Former Member]

Hi Rashmi,

In your suggestion for the FXTRANS.LGF below are "ID" and "RPTCURRENCY" holding places for the specific Rate Acct IDs (AVG, END, etc) or literal values for the script? The script is working for our END rates but not the AVG rates.

Thanks,

Pam

[Former Member]

HI,

I am also facing the same issue..When i run datamanager package ,it shows status as "success"

But the currency coversion is not working. I am running this in NW 7.5

Script logic

-

---

*RUN_PROGRAM CURR_CONVERSION

CATEGORY =%CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

OTHER=[ENTITY=%ENTITY_SET%]

R_ENTITY = GLOBAL

*ENDRUN_PROGRAM

Is there anything missing in my script logic?

[Former Member]

Hi Rashmi & Udaybi,

Did any one of you guys solve the issue ? I am having the same issue. Please help.

--

Thanks,

Tagz

[Former Member]

Hi,

Please remove the OTHER in the ENTITY assumption of your script, and try executing the logic,

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATEGORY_SET%
TID_RA = %TIME_SET%
ENTITY=%ENTITY_SET%
RATEENTITY = GLOBAL
*ENDRUN_PROGRAM

Also Ensure that this logic works only if the values are in Local Currency ie, the CURRECY_TYPE property of the currecy should be L. This logic converts the values in Local Currency to other Reporting Currency which have CURRENCY_PROPERTY as R.

Hope this will help.

Regards,

G.Vijaya KUmar

[former_member200537]

Hi Vijaya Kumar,

Thanks for your reply.

I tried the script logic you mention in your reply but it doesn't works either.Datamanger is running successfully but in the formula log no records are converting( 0records submitted 0 records transferred). I'm sure there is data in the planning application for the values I'm inputting in datamanager for currency dimension as LC and exchange rate is also maintained in rate application.

I double check RptCurrency (currency type)dimension and it's property Currency_Type we maintained 'L' for Local Currency and 'R' for USD(reporting currency).

please advise us if we are missing any thing.

[Former Member]

Hi,

if the Problem is not there Please check your Business Rule if it has any Formula in it or not.

That might be the reason. Update that with following,

[<<RATEACCT>>]

In case the rate account is AVG, the formula will be [AVG]

And for updating the same you need to validate it first and save it else it might not get update.

Hope this should resolve your issue.

Regards,

G.Vijaya Kumar

[former_member200537]

Hi Vijaya Kumar,

Thanks for your prompt response.

we are already maintaining currency conversion business rule in planning application as below

Account Rate type - AVG

Formula - [AVG]

please advise on this.

Thanks

UDAY

[Former Member]

Hi,

Maintain the Formula as,

[AVG]

The square brackets in my precvious reply where missed out.

Regards,

G.Vijaya KUmar

[former_member200537]

Hi Vijaya Kumar,

We are maintaining formula in square bracket only in formula of business rule,even i type AVG in square bracket in my reply but here it doesn't allow square bracket hence it shows like AVG (with out square bracket).

[former_member200537]

Still the problem exist, Any more suggestions?

[Former Member]

Hi,

The Final option from my end which i think you could have missed out is the RATETYPE property in acount dimension.

Have you maintained that property for the accounts as AVG.

Also check that you are maintaining the rate values for the Rate account "AVG".

Be sure that there is no dimension formula maintained for the accounts which you are trying to perform the currency conversion.

Regards,

G.Vijaya Kumar

[Former Member]

Hi Uday,

What I would suggest is that please go to the application parameters in BPC Web Admin for your application and then add a parameter "FXTRANS" and set the value as 1.

Note that this is the application parameter for your application.

Hope this helps.

[former_member200537]

Hi,

Thanks for reply.

Yes we are maintaining FXTRANS value as 1 for planning application in application parameter and also we are maintaining Rate_Type property as AVG for Planning application account type dimension(P_ACCT).We are also maintaining exchange rate for R_ACCT 'AVG' and Category 'Plan' for all the months in the year 2009 in the rate application.

Any more suggestions.

Thanks

UDAY

Edited by: Udaybi on May 14, 2010 3:13 PM

[former_member200537]

contacted SAP and open a message

[Former Member]

hi Udaybi,

so did you open a msg and got a solution for your problem.

i am hitting the same issue at this moment, but i am sure it is just one of the properties missing.

never the less, ifyou have a solid solution ... please enlighten us.

Kind Regards, MW

[Former Member]

Hi,

I am also facing the same issue with the currency translation. I am on BPC 7.5NW version.

Any solution to your problem? Could you please share it with me too?

Regards,

RashmiG

[Former Member]

Hi,

I am also getting the same issue. Could you please let me know what was the solution for this issue.

Thanks,

SAC

[Former Member]

Hi,

Has anyone resolved this issue ? Currently i'm working with BPC 7.5 NW and having the same problem. Already followed all the requirement for currency translation but still getting 0 records.

Thanks.