SET UPTOLOCAL

The SET UPTOLOCAL calculation command for Essbase 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.

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;