Importance

Loading Importance Indicators...

Abstract

Disclosed are a method and system for generating user-defined pivot views of data records contained in a database where, as depicted in FIG. 2a, an underlying real facts table at first is extended by continuous index values (200) which provides a continuous numbering of the facts from `1` to `x` (x=20 in the present example). In the resulting pivot view shown in FIG. 2b, in each cell (210) the indices of those facts are presented which sales value has to be summed-up in the corresponding cell. The pivot view is generated by means of a sequence vector. The underlying sequence vector for the pivot view in FIG. 2b is depicted in FIG. 2c and consists of two columns (260, 270), the left column (260) containing continuous numbers from again `1` to `x` and the right column (270) containing the mentioned index values (275) depicted in FIG. 2a in an ordered arrangement that enables sequentially building-up the pivot view of FIG. 2b.

Loading the Abstract Image...

First Claim