Running Currency conversions for more than one currency at same time

[Former Member]

Hello

Does anyone know whether it is possible to run currency conversion (using the stored procedure SPRUNCONVERSION) for more than one currency at the same time? The logic is fine as we can run each currency individually but when we try to run for more than one currency at the same time we have the following error:

SpRunConversion Version 1.07.30

ERROR FX-130 No Group available.

Many thanks

[Former Member]

WHat is the script you have used? You are able to run for multiple currencies. the currencies should have a CURRENCYTYPE property of either G or R

Anis

[Former Member]

The scrip for the currency consolidation is:

*RUN_STORED_PROCEDURE=SPRUNCONVERSION([FINANCE],[%CATEGORY_SET%],[%GROUPS_SET%],[GLOBAL],[%SCOPETABLE%],[%LOGTABLE%],[2])

*RUN_STORED_PROCEDURE=SPRUNCONSO([FINANCE],[%CATEGORY_SET%],[%TIME_SET%],[%GROUPS_SET%],[%LOGTABLE%],[2])

and all CURRENCYTYPEs have been set to G.

There are several currency groups which have been set in Euros and we run this script to consolidation at a higher level. When we try to run more than one currency group at a time, an error appears but when the groups are run individually there is no problem.

[Former Member]

myk--

1)I'm sure you have the necessary properties and dimensions configured... but please double check this document.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0907bdb-e908-2d10-ca9e-f67166e21...

2) reprocessing your dimensions with full process on the application.

and also finally save and validate the Business rules...

Hope tht helps..

[Former Member]

The consolidation works perfectly well but users have to select each currency group one at a time. We want to be able to select more than one currency group to consol at the same time, but when we do this we just get a FX-130 error message.

Is there a way to structure a DTS package to enable the user to select more than one currency group for consol?