on 08-13-2013 8:48 PM
To the SAP BPC and EPM Specialists out there:
Our BPC 10.0 Netweaver project uses the standard Currency Conversion programs but it is not finding any records.
Both the DM Package or the UJKT results always come back with:
RUN CURRENCY CONVERSION
0 SUBMITTED, 0 SUCCESS, 0 FAIL.
Please help if you can – details follow:
This is Planning only, no Consolidations or Group Translation.
How-To Guides and 2 separate BPC EPM Books were followed precisely as I can see.
An ABAP debugger found that the program below finds no LC and only finds Report Currency Records.
But I don’t want to create custom S/L to do this, trying to use the standard program FXTRANS.LGF.
Script Logic:
(This has been attempted with and without the OTHER Dims such as ENTITY, AUDITTRAIL).
And has been tried creating a *SELECT variable for RPTCURRENCY whereas it finds EUR, USD.
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATEGORY_SET%
CURRENCY = %RPTCURRENCY_SET%
TID_RA = %TIME_SET%
OTHER = [ENTITY=%ENTITY_SET%]
RATEENTITY = GLOBAL
*ENDRUN_PROGRAM
Planning App Dims and Records:
CATEGORY: Plan
TIME: 2014.12 (December, 2014)
ENTITY: 1000
RPTCURRENCY: LC
AUDITTRAIL: Dload
MEASURES: PERIODIC
Rates App Dims and Records:
CATEGORY: Plan
TIME: 2014.12 (December, 2014)
R_ENTITY: GLOBAL
INPUTCURRENCY: EUR, USD
R_ACCOUNT
AUDITTRAIL: Dload – TRIED WITH AUDITTRAIL DIM BOTH IN AND OUT OF THE RATES APP.
MEASURES: PERIODIC
Rates were input manually, and the USD ratio is 1.
Listcube shows:
TIME INPUTCURRENCY AUDITTRAIL CATEGORY R_ACCOUNT R_ENTITY SIGNEDATA
General Settings:
Plan Model refers to the Rates Model etc…All copied from ENVIRONMENTSHELL…
DIMENSION : attribute(s)
ACCOUNT : Ratetype = AVG
R_ACCOUNT: tried with and without ratetype = FX
AUDITTRAIL : datasrc_type = I, IS_converted = Y
ENTITY : currency (local currency for each Entity)
RPTCURRENCY : currency_type (currency type - Reporting for EUR and USD, Local for LC)
TIME : year, period, timeid, monthnum all set
INPUTCURRENCY (Rate model) MD (M or D, indicator – both M and D tried.
Business Rule:
ID = AVG – Average Rates
Formula = [AVG]
Saved and Validated with green light.
Tried with and without the “Entity Fx Type” populated as FX.
I have had this working on 7.x versions.
Any input would be greatly appreciated.
Hello,
Has anyone found a solution? I have the same problem when converting December
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Anyone found solution / work around / or note to solve this ticket.
Best regards
Flávio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John,
You said that "AVG" dimension member is used for INPUTCURRENCY dimension, how about your transaction data in the planning model, are they written as AVG? or CLO?
Also, check your business rules. If the business rule for AVG or CLO does not include the correct formula like [AVG] or [CLO], it would not paste any output.
At last, check Ratetype property member in the business rule, is it the same with entity's rate type property value for instance "FX"
I wish these help,
Best,
Mahir Parlakay,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Had a similar problem. The way I resolved it was to use "Global" for the Rate entity in the script logic.
Because my dimension had Global the same way in the ID. While the various notes tell you to use caps, (and that worked in older 10.0 systems), with SP11 being used in my current app, the all caps did not work but the "Global" worked! Good luck.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Any solution to this issue? We are also facing the same issue.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The Data Manager Advanced Script prompt is set up according to recommendations.
PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")
TASK(/CPMB/FX_RESTATMENT_LOGIC,SUSER,%USER%)
TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPP,%APP%)
TASK(/CPMB/FX_RESTATMENT_LOGIC,SELECTION,%SELECTION%)
TASK (/CPMB/FX_RESTATMENT_LOGIC,LOGICFILENAME,FXTRANS.LGF)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi everyone,
I have same issue when i run my FX Restatement using Financial Package, and the log was:
RUN CURRENCY CONVERSION
0 SUBMITTED, 0 SUCCESS, 0 FAIL.
Here is my configuration:
in Rate Model:
DIM: R_ENTITY (Rate Entity)
ID CONTROL_LEVEL CONTROL_CURRENCY_NOT_LC CURRENCY
GLOBAL
DIM: R_ACCOUNT (Rate Accounts)
ID ACCTYPE RATETYPE SCALING
AVG AST FX
CLO AST FX
DIM: INPUT CURRENCY
ID Curr_type Entity MD Reporting
CNY M
IDR G M Y
LC L M
SGD G M
THB M
USD G M
VND M
DIM: CATEGORY
ID STARTMTH YEAR
Actual 01 2013
in Consolidation Model:
DIM: ENTITY
ID CURRENCY PARENTH1
ACons IDR ALL_ENTITY
A IDR ACons
BCons USD ACons
B USD BCons
C CNY BCons
D THB BCons
E VND BCons
FCons SGD BCons
F SGD FCons
G IDR FCons
H CNY FCons
DIM: RPTCURRENCY
ID CurrType Entity Reporting
IDR G Y
USD G
SGD G
LC L
DIM AUDIT (Type: Datasource)
ID ISCONVERTED DATASRC_TYPE ISCONSOL
Original G I G
Data is loaded to consolidation application using data manager package into:
Audit : Original
Time : 2013.03
RptCurrency : LC
Flow : F99 for BS, and PL99 for PL
Exchange Rate is inputted into rate application:
R_Entity: Global
Time : 2013.03
Category: Actual
Measures: YTD
and the rate value are:
CLO - IDR = 1
CLO - USD = 0.000909
CLO - CNY = 0.0005
etc..
My FXTRANS.LGF (logic script)
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATEGORY_SET%
CURRENCY = %RPTCURRENCY_SET%
TID_RA = %TIME_SET%
ENTITY = %ENTITYLTL_SET%
RATEENTITY = GLOBAL
*ENDRUN_PROGRAM
*COMMIT
My business rule:
Source Flow PL99 - Formula [AVG]
Source Flow F99 - Formula [CLO]
when i run the fx restatement package, i set:
entity : H
time : 2013.03
category: actual
rptcurrency: IDR,USD
logicly, my values on entity H, RPTCurrency LC will be translated into USD and IDR.
But the package do nothing because of the log message is "0 SUBMITTED, 0 SUCCESS, 0 FAIL" even the package was run successfully.
Did i miss something?
Please BPC's master, can you help me?
Thanks
Noviany
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kalyan,
Thanks for this information, unfortunately all of this has been set as well as the full How-to-Guide settings, still to no avail.
Although I am not using Group, Scope, or Flow Dimensions – Just LC to Reporting Currency for Planning – no Consolidations or Legal Apps used at this time.
I also set the system_constants.lgf in t-code UJFS to align with any Dim or App Name differences.
And I evaluated the standard BPC security settings to ensure it wasn’t a lack of access to the objects.
Regards,
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Greetings Kalyan, thanks so much for your response....
Even though my original statement said that an abap debugger found the FXTRANS.LGF finds no LC records, the LC records have always existed as follows:
- We posted RPTCURRENCY = LC Records in the PLAN (Main) Model/App for ENTITY that have EUR and USD as their Master Data Currency Property.
- We posted INPUTCURRENCY = EUR,USD,GBP,JPY,and RMB in the RATES App, where R_ACCOUNT = AVG.
But the results are always that Currency Translation = Success, 0 zero Records Submitted.
Maybe there is a property not flagged, that causes the LC records to be ignored. But I have followed all the How-To-guides. Still unresolved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John,
Here is a quick checklist you may refer and see if all is set correctly:
Dimension Type Important Currency Related Requirements
Entity The required property is Currency, which stores the local currency of the
Entity.
Group The required properties are:
• Currency_Type whose values are G for group currency or N for non-group
currency
• Group_Currency whose values are the group currency(s) such as USD
Category This same category dimension must also be used in the Rate Model.
Currency The required properties are:
• Reporting whose values are Y or blank
• Currency_Type whose values are T for transaction currency, R for
Reporting, and L for local currency.
Account The required property is:
• RateType whose values are AVG, END, and so on
Time The required properties are:
• Year with values like 2011, 2012
• Period with values like JUN, JUL
• TimeID with values like 201206, 201207
• Monthnum with values like 6, 7
The same time dimension must also be used in the Rate Model.
DataSource The required properties are:
• Datasrc_Type whose values are I – Input, M – Manual Adjustment, A –
Eliminations and Adjustments
• IS_Converted whose values include:
N – these members are ignored in the conversion,
Y (or blank) – these members are converted from LC into the desired
currency, and G - these members are entered in a reporting currency
are translated to group currency.
Regards,
Kalyan.
Hi John,
The data has to be loaded in LC only then it will be converted in reporting/group or other desired currencies. The standard package looks for data in LC and then convert them to reporting/group currency.
Regards,
Kalyan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.