Currency Conversion for LEGALAPP with LRATE

[Former Member]

I'm setting up a currency conversion for LEGALAPP with an LRATE cube,

//=============================================

// Currency translation logic

//=============================================

// *RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','ACTUAL',u2019EUR','GLOBAL',

'%SCOPETABLE%','%LOGTABLE%')

// *COMMIT

*RUN_STORED_PROCEDURE=SPRUNCONVERSION([[LEGALAPP]],[[ACTUAL]],[[EUR]],[[GLOBAL]],[[%SCOPETABLE%]],[[%LOGTABLE%[])

*COMMIT

The only Currency conversion rules definition:

Account rate type : AVG

Source flow : OTHERFLOW

Formula : [[AVG]]

Other columns are emtpy.

The Error-Message:

ERROR* FX-150 Problem IN Ownership

My first Question: Are the brackets ok for the parameters?

My next Question: Why this error-message

The out-commented lines work without error, but there is no currency-translation at all.

When testing various version of the Logic, I've got several errors:

SPRunConversion Version 2.08

ERROR* FX-200 No Rate Extract From FactRate

My idea: no appropriate record found in the LRATE-Cube, maintain rates

ERROR* FX-220 No Rate for reference currency

My idea: Logic Parameter '%Currency_SET%' entered into the formula

ERROR* FX-150 Problem IN Ownership

No idea.

Are error - lists available with possible error-causes?

Thanks a lot

Jochen

Edited by: Jochen Kowalski on Sep 18, 2008 3:06 PM

Edited by: Jochen Kowalski on Sep 18, 2008 3:08 PM

[Former Member]

Your hint to check the logic logfile gave me the clue:

There was a typo with the ' - comma in the currency parameter.

The conversion is now working!!!!

I would like to extend the currency - parameter with something like '%currency_SET%'

to convert all currency in one step.

Is this variable filled in automatically or do I have to build a loop around the

sprun..... - line?

Jochen

[Former Member]

Great that the conversion is working now.

You can use the %currency_set% method, but it will only work when only one member is selected.

If you want conversion for more than one currency it is adviced to add multiple sprunconversion calls:

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','ACTUAL',u2019EUR','GLOBAL','%SCOPETABLE%','%LOGTABLE%')

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','ACTUAL',u2019GBP','GLOBAL','%SCOPETABLE%','%LOGTABLE%')

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','ACTUAL',u2019USD','GLOBAL','%SCOPETABLE%','%LOGTABLE%')

Alwin

[Former Member]

I checked everything, but no conversion into EUR.

Some additional facts:

RATEENTITY:

ID = GLOBAL, CURRENCY = <EMPTY>

DATASRC

ID = IC_INP, DATASRC_TYPE = I, IS_CONVERTED = Y

ACCOUNTL:

ID = 4111000, ACCTYPE = AST, RATETYPE = AVG

CONSOLEVIEW:

ID = LC, CURRENCY_TYPE = L

ID = EUR, CURRENCY_TYPE = R

ID = GBP, CURRENCY_TYPE = R

I defined no GroupCurrency with Currency_Type G

Is this OK?

Thanks

Jochen

[Former Member]

All additional information looks OK.

Are you getting an error when running the sprunconversion?

Could you post the logfile?

Alwin

[Former Member]

Hi Jochen,

The outcommented line: // *RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','ACTUAL',u2019EUR','GLOBAL','%SCOPETABLE%','%LOGTABLE%') is OK, the other one is incorrect because it misses the quotes.

Please check the following to see why the conversion is not running:

- check if you have entered rates for AVG

- check if you have accounts where the ratetype is AVG

- check if you have subtable members where the subtable_orig property has a value of OTHERFLOW

- check if you have square brackets around AVG in the formula field of the business rules

- create a report with accounts in the rows and currency dimension in the columns, select in the columns LC and EUR, select in the pagekeyrange a subtable where the subtable_orig has a value of OTHERFLOW and see if LC data is converted to EUR

Hope this helps,

Alwin