SET UPTOLOCAL

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

Syntax

SET UPTOLOCAL ON | OFF ;

Description

This command 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:

Outline example

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

Notes

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

Example

SET UPTOLOCAL ON;

SET UPTOLOCAL OFF;

See Also

CCONV
SET CCTRACKCALC
CLEARCCTRACK
CCTRACK (configuration file setting)

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com