Numeric data types

Single Precision

Floating-point numeric type (4 Bytes). Each cell occupies 4 bytes.

Numbers that need more than 4 bytes to be saved will be rounded.

Note that rounding occurs only when writing data to a single cell of the InfoCube, therefore if your data source provides data in single precision or in an 8 character field you should use this data type. When used in procedures and reports, single precision InfoCubes are aggregated using double precision variables therefore virtually no aggregation occurs.

This is the recommended data type to use for numeric InfoCubes, providing an excellent trade-off between accuracy and space required.

Double Precision

Floating-point numeric type with double precision (8Bytes). Each cell occupies 8 bytes.

Integer

Integer numeric type. Each cell occupies 2 bytes. The value of a single cell must be between -32000 and 32000.

Currency

It is a fixed 3 decimal format with the same accuracy as the Double Precision type. Each cell occupies 8 bytes.