![]() Previous |
![]() Next |
The VALSPERPAGE program calculates the maximum number of values for a variable of a given width that fits on one page. Pages are units of storage in the workspace.
Return Value
INTEGER
Syntax
VALSPERPAGE(n)
Parameters
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
.
Usage 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.
Examples