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.
INTEGER
VALSPERPAGE(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.
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.
Example 8-157 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 an INTEGER value in Oracle OLAP is 4 bytes.
SHOW VALSPERPAGE(4)
The output of this statement is
992