SET UPTOLOCAL

Restricts consolidations to those parents with the same defined currency. The default is OFF.

For example, all cities in Switzerland use the Swiss franc (CHF) as the unit of currency. Therefore, all children of Switzerland, such as the cities Geneva, Zurich, and Lucerne, consolidate to Switzerland. Consolidation stops at this level, however, because Europe also contains countries that use other currencies. The following database outline example illustrates this situation:

Database outline showing consolidation of parents with matching currency.

If you want to consolidate values above this level, you must use CCONV to convert the values to a master rate before consolidating.

Syntax

SET UPTOLOCAL ON | OFF ;

Notes

SET UPTOLOCAL ON has no effect on databases with no currency definitions.

Example

SET UPTOLOCAL ON;

SET UPTOLOCAL OFF;

See Also