VALSPERPAGE

The VALSPERPAGE program calculates the maximum number of values for a variable of a given width that will fit on one page. Pages are units of storage in the workspace.

Syntax

VALSPERPAGE(n)

Arguments

n: An INTEGER expression specifying the width of a variable in bytes. This value should be between 1 and 4000. When you specify a value greater than 4000 or less than 1, the result is NA.

Notes

Large Variables

Oracle OLAP lets you create very large, multidimensional variables. Theoretically, a variable can contain up to 2**63 cells, although this maximum is subject to memory constraints and other factors specific to your system.

Related Statements

AW function and DEFINE VARIABLE command.

Examples

Example 24-28 Calculating the Number of Cells in a Page

The following statement calculates the maximum number of cells available in a single page for a variable with an INTEGER data type. The default width of integers in Oracle OLAP is 4 bytes.

SHOW VALSPERPAGE(4)

The output of this statement is