cancel
Showing results for 
Search instead for 
Did you mean: 

BPC 10.0 Currency Conversion finds no Records

Former Member
0 Kudos

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

  1. 2014.12   EUR                        DLoad      Plan         AVG         GLOBAL   1.2000000
  2. 2014.12   GBP                        DLoad      Plan         AVG         GLOBAL   1.4000000
  3. 2014.12   JPY                         DLoad      Plan         AVG         GLOBAL   0.9000000
  4. 2014.12   RMB                       DLoad      Plan         AVG         GLOBAL   0.9000000
  5. 2014.12   USD                        DLoad      Plan         AVG         GLOBAL   1.0000000

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.

Accepted Solutions (0)

Answers (10)

Answers (10)

Former Member
0 Kudos

Hello,

Has anyone found a solution? I have the same problem when converting December

Flavio_VB
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Mark,

To solve our problem, we just follow the steps in note 2101349.

Be sure that everything is coustomized according instructions on this note.

If you dont have any customization on back-end (BW), it should solve your problem.

BR

Flávio

Former Member
0 Kudos

Thank you very much Flávio

Flavio_VB
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

Anyone found  solution / work around / or note to solve this ticket.

Best regards

Flávio

Former Member
0 Kudos

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,

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Tara,

I face the same issue, but when I upload data using EVSND with data_src INPUT and currency USD I get 3 SUBMITTED, 3 SUCCES, 0 FAIL, but with EVGET the output is zero.

When I upload data on LC the log message is 0 SUBMITTED, 0 SUCCES, 0 FAIL.

Any idea?

Thanks,

N

Former Member
0 Kudos

Hi All,

Any solution to this issue? We are also facing the same issue.

Regards.

Former Member
0 Kudos

Hi Experts

Can some one please have some input here.

JAck

Former Member
0 Kudos

Hi ,

Time dimension seems to be ok. Just check if rates are maintained for given period in rate model.

Are you using some property like RATE_CATEGORY in your category type dimension. ??

Former Member
0 Kudos

John,
Have you found a resolution to this issue? I am experiencing a very similar error in BPC 10 and I noticed you are running your CURR_CONVERSION on 2014.12 (December).
I am also in a periodic Planning Model with very simple currency rules ID: AVG Formula: [AVG]
I am only experiencing the error for in DEC of each year. I loaded a budget file for every period of 2012 through 2014 into Local Currency for multiple company codes. When I translate currency, the Currency Conversion is successful for Jan - Nov of each year.
Every time I run December, ex. 2013.DEC, it comes back with the result of:
RUN CURRENCY CONVERSION
0  SUBMITTED, 0  SUCCESS, 0  FAIL.
If I run under the same parameters for November, ex. 2013.NOV, the package runs successfully:
RUN CURRENCY CONVERSION
1405  SUBMITTED, 1405  SUCCESS, 0  FAIL.
I have attached a screen shot of the 2013 Time Dimension.
My Dimension Property set up is extremely similar to John's with the exception of Member naming conventions such as AUDITTRAIL: AT_SAP & CATEGORY: Budget...
Our Script Logic for *RUN_PROGRAM CURR_CONVERSION is identical.

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)

Again, the currency conversion is working and calculating properly for Jan through Nov, only December is producing the result of No Records. I have verified that the Rates are in the proper intersection just as they are for Jan - Nov as well as the Data in the Planning model is in LC in the correct intersections such as Jan - Nov.
Has anyone experienced this where only one month, the 12th period, provides no records?
In addition, I have gone through the full list of the Currency Related Requirements as provided by Kaylan:
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,
Geoff

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi John Pasquantonio,
Hi Noviany Jonatan,

Please see my below screenshot and check whether you have included %CURRENCY% in prompt.

I think after including %CURRENCY% in prompt, Currency translation will work

Former Member
0 Kudos

Hi Sarvesh

Here is my Prompt Selection for FXTrans Package script:

"%ENTITY_DIM%,%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%"

In My FXTRANS.LGF (logic script)

I set my variable as %CATEGORY_SET%, while in the package script it call %CATEGORY_DIM%

Does it matter?

Thanks for your reply

Noviany

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.