Currency Translation - Data not visible

[Former Member]

Hi,

Unable to see data for currency translation. These are the levels at which data is posted, the logic runs however data is not visible.

Exchange Rates loaded at following levels.

App RATE

INPUTCURRENCY CAD

CATEGORY ACTUAL

RATE AVG

RATESRC RATEINPUT

MEASURES Periodic

TIME 2009.MAR

and tb loaded in legalapp at the following levels

App LEGALAPP

ACCOUNTL 2

ACCTDETAIL F_ERR

CATEGORY ACTUAL

DATASRC INPUT

GROUPS LC

INTCOL ABC_NO_INT

LEGALENTITY 7100

MEASURES Periodic

TIME 2009.MAR

fx trans logic is

*RUN_STORED_PROCEDURE = SPRUNCONVERSION([%APP%], [%CATEGORY_SET%],[GLOBAL], [%SCOPETABLE%],[%LOGTABLE%])

Business rules are

business rules is

account rate type -

---

> formula

avg -

---

> [avg]

end -

---

> [end]

kindly let me know what am I missing and at what level the data should be visible. Am checking in Fact2Legalapp but dont see any data.

Thanks

[TedemanCPA]

Hi Andy,

In your Package log, does it say how many records calculated/updated?

There are several key items to check when using SPRunConversion. For me, it was making sure that the parameters in the business rules table were updated. The only real reference on it is in the Admin Guide on about pg. 65.

In addition to Validating/Saving the Rules table, also make sure you do an initial Validation of the FXTrans.lgf script logic.

[Former Member]

Also the error we are getting while processig the above is

Execute formulasError

SPRunConversion Version 7.0.113.01

ERROR FX-230 Problem in your Entity Dimension id from your Rate application

Thanks