SET UPTOLOCAL

Command

The SET UPTOLOCAL command 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 France use the franc (FF) as the unit of currency. Therefore, all children of France, such as the cities Paris, Nancy, and Avignon, consolidate to France. Consolidation stops at this level, however, because Europe also contains countries that use other currencies. The following database outline example illustrates this situation:

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
CCTRACK (Essbase.CFG file setting)

Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.