BPC Currency Translation issue

[Former Member]

Hi People,

I am trying to run currency translation but FX Trans DM Packaging is getting aborting every time.

Below is my Financial model and its dimensions.

GII_ACCOUNT, GII_COMPCODE,GII_COSTCENTER,GII_REGION, GII_RPTTEAM,GII_TIME,GII_VERSION,GII_WBSELE, RPTCURRENCY.

And i had transaction in LC in Financial model.

Rate model.

Rate template (All LC to JPY)

And used below script logic in Financial model

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %GII_VERSION_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %GII_TIME_SET%

RATEENTITY = Global

ENTITY = %GII_COMPCODE_SET%

*ENDRUN_PROGRAM

But my package is getting abort.

NOTE : Before getting abort my package , i got error "RUN_LOGIC:Property INTCO is not maintained in dimension" so i was added INTCO property in entity dimension - GII_COMPCODE.

Could you please suggest me what i am missing ? Thanks!

Regards,

Vishu

[former_member186338 · Accepted solution]

Please read this document

and compare all settings with your case.

Also look on help: Currency Conversion as Script Logic - SAP Business Planning and Consolidation, version for SAP NetWe...

your script is incorrect - have to be OTHER = [GII_COMPCODE=%GII_COMPCODE_SET%]

[Former Member · Accepted solution]

Hi Vadim,

I have checked mandatory properties, it looks fine.

1. ACCOUNT Dimension – Property – RATETYPE - AVG

2. ENTITY Dimension - Property – CURRENCY

and added INTCO property

3. CURRENCY Dimension - Property – CURRENCY_TYPE

RPTCURRENCY

4.TIME Dimension - Property – YEAR ,PERIOD ,TIMEID ,MONTHNUM  maintained properly.

5. INPUTCURRENCY Dimension - Property – MD  - InputCurrerncy dimension used in Rate model.

Do you think i am still missing anything please?

Thanks,

Vishu

[former_member186338 · Accepted solution]

If you don't have INTCO dimension you don't need "and added INTCO property"

".TIME Dimension - Property – YEAR ,PERIOD ,TIMEID ,MONTHNUM  maintained properly." - are you 100% sure?

"INPUTCURRENCY Dimension - Property – MD  - InputCurrerncy dimension used in Rate model." -???

"Do you think i am still missing anything please?" Please check everything once more!

[former_member186338 · Accepted solution]

P.S. And where is the rule setup screenshot?

[Former Member · Accepted solution]

Hi vadim,

**** If you don't have INTCO dimension you don't need "and added INTCO property"

Yes i dont have INTCO dimension, Initially  i did not maintained INTCO property but my paclage throwing error that --- RUN_LOGIC:Property INTCO is not maintained in dimension so i just added it in Companycode dimension.

********".TIME Dimension - Property – YEAR ,PERIOD ,TIMEID ,MONTHNUM  maintained properly." - are you 100% sure?

Yeah. Here is the snapshot

*****"INPUTCURRENCY Dimension - Property – MD  - InputCurrerncy dimension used in Rate model." -???

Yeah and RPTCURRENCY Used in Financial model

******* P.S. And where is the rule setup screenshot?

Thanks,

Vishu

[former_member186338 · Accepted solution]

FX package will not show error like "RUN_LOGIC:Property INTCO..." something wrong! May be you are launching incorrect script?

Time dimension with a single time member will not work! Fill data for the whole year!

"INPUTCURRENCY Dimension - Property – MD" - how do you setup this property?

[former_member225135 · Accepted solution]

Hi Vishu,

The property of Input currency should either be "M" or "D". you can not have both !

Regards,

Rahul

[Former Member · Accepted solution]

Hi Vadim,

FX package will not show error like "RUN_LOGIC:Property INTCO..." something wrong! May be you are launching incorrect script?

Error Package

******Time dimension with a single time member will not work! Fill data for the whole year!

Yeah i had maintained for all the year. I just took SS for single month for your reference.

*****"INPUTCURRENCY Dimension - Property – MD" - how do you setup this property?

    As a "M"

Thanks,

Vishu

[former_member186338 · Accepted solution]

PROMPT(SELECTINPUT... - copy full line please!

Show full script text - FXTRANS.LGF!

P.S. "Yeah i had maintained for all the year. I just took SS for single month for your reference." - please show full year!

[Former Member · Accepted solution]

Advanced logic:

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)

Script logic :

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %GII_VERSION_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %GII_TIME_SET%

RATEENTITY = Global

OTHER = [GII_COMPCODE=%GII_COMPCODE_SET%]

*ENDRUN_PROGRAM

TIme Dimension.

[Former Member · Accepted solution]

Hi Rahul,

Yeah i had only "M"

Thanks,

Vishu

[former_member186338 · Accepted solution]

Nothing wrong!

Please TIME hierarchy for Year!

[former_member186338 · Accepted solution]

Ups! FY 2016 - ID with space inside? Bad idea!

[former_member186338 · Accepted solution]

Also - you have non standard fiscal Year!

2016.07 has to be Jan, Monthnum 1 etc!!!!

The required properties has to be set according to fiscal, not to calendar year to be in line with hierarchy! FXTRANS will not work with setup like this!

[Former Member · Accepted solution]

Hi Vadim,

Yeah, My own time dimension properties values are creating problem.

For testing - i had included TIME dimension - BPC predefined dimension instead of using my own GII_TIME Dimension in the models and Currency translation works well.

Could you please tell me again what are the properties i have to changes in my own time

dimension ?

Here is my time dimension and its properties.

Thanks,

Vishu

[former_member186338 · Accepted solution]

Sorry, I have already told you....

Your hierarchy for TIME is created for Fiscal Year.

Then the properties has to be also fo fiscal year:

...

2016.06 2016 2016.Q4 012 MONTH 12 DEC 20160600

2016.07 2017 2017.Q1 001 MONTH 1 JAN 20160700

2016.08 2017 2017.Q1 002 MONTH 2 FEB 20160800

...

[Former Member · Accepted solution]

Hi Vadim,

I had updated as you suggest. Please see below updated MD in Time dimension.

But my package is still getting abort. Could you please check SS i am still missing?

FYI, I have data for 2016.08 in LC in Financial model and maintained rates for 2016.08

Thanks,

Vishu

[former_member186338 · Accepted solution]

I have already told you - dimension member ID with space inside is a bad idea:

FY 2017

Use

FY2017 or FY_2017 or FY.2017

[former_member186338 · Accepted solution]

Also, all members of FY2016 has to be created!

Please, be accurate!

[Former Member · Accepted solution]

Hi Vadim,

As you told i have updated FY2016 and FY2017 and removed space in FY 2016 etc.

But i still getting abort.

FY2016 -

FY2017 -

I had data for 2016.08 in Model and running DM Package for 2016.08 month.Hope this one is correct?

Thanks,

Vishu

[former_member186338 · Accepted solution]

Sorry, it's not possible for me to inspect all settings... Looks like you are doing something wrong because FXTRANSLATION is a very simple thing and has to work without any issues!

I can recommend to make a fresh copy of the environmentshell and test FXTRANS here! It will work! Then compare it with your environment!

[Former Member · Accepted solution]

Ok.Thanks for your help vadim.

As i told you, Currency translation is working fine if i use TIME - BPC Predefined Environment shell Dimension in my same model but i am getting problem if i include my own dimension GII_TIME and it has non financial year set up.

Seems, Currency translation will not work for non financial year set up but i had changed properties as you said?

Thanks,

Vishu

[former_member186338 · Accepted solution]

What about hierarchy name in TIME dimension? I see something strange as T01???

Also only one hierarchy is allowed for time dim...

[Former Member · Accepted solution]

What about hierarchy name in TIME dimension? I see something strange as T01???

Yea hierarchy name is T01

*********   Also only one hierarchy is allowed for time dim.

Yea i used only one time dimension. and I had tested like below.

First time : I included my own time dimension(GII_TIME) which is having non financial year set up in MODEL - Did not work currency translation

Second time : This time, I removed my own time dimension and added TIME dimension - BPC Predefined Time Dimension - Currency translation works fine.

Third time : removed TIME dimension - BPC Predefined Time Dimension and added again my own dimension but this i had updated proprieties as you suggest - But currency translation did not work.

So, i am thinking it wont work if time dimension has non financial year setup?

Thanks,

Vishu

[former_member186338 · Accepted solution]

"So, i am thinking it wont work if time dimension has non financial year setup?" - incorrect! It will work with fiscal year, you have to recheck properties!

Or better - recreate a dimension from zero!

[former_member186338 · Accepted solution]

I have found the error!!!

Incorrect property name:

Not MONTH_NUMBER

But MONTHNUM

!!!!

[former_member186338 · Accepted solution]

Standard!

[Former Member · Accepted solution]

Yeah. updated property and works well now.  thank you so much Vadim.

Learned to create own dimension using "Copy of existing Dimension" so that wont miss necessary properties and spelling mistake.

Once again thank you so much Vadim.