Outline Paging Limits

The maximum size of a buildable outline (the number of members) depends on several factors:

Table 200 shows the amount of addressable memory available for Essbase on supported 32-bit operating systems:

Table 200. Addressable Memory for 32-bit Operating Systems

Operating System

Addressable Memory

Windows 2003 Server

3 GB

Requires a setting in the boot.ini file

AIX

3.25 GB

Up to 13 (256 MB) segments. Requires setting the LDR_CNTRL environment variable to:

0xD0000000@DSA

HP-UX

2.9 GB

Requires using the following command to set the addressable memory for the Essbase server process, ESSSVR:

chatr +q3p enable ESSSVR

Redhat Linux

3.9 GB available by default

Solaris

3.9 GB available by default

Essbase uses about 40 MB of memory on startup. In addition, the various caches require the following memory allocations:

Therefore, the initial memory footprint for Essbase is about 90 MB. In addition, memory must be allocated to process incoming query requests. Typical memory to reserve for this purpose is about 300 MB. The total memory allocated for Essbase is therefore 390 MB.

On a Windows system with 1.85 GB of addressable memory, the amount available to build and load the outline is about 1.46 GB (1.85 GB - 390 MB = 1.46 GB).

The maximum outline size depends on whether it is built using a dimension build or from an outline already loaded into Essbase.