Patent ID: 8036859
Filing Date: 2011-10-11
Classification: G06F

Abstract:
1. A computer-implemented method of processing a report query to a dimensional data model by processing a plurality of dimension coordinates that exist within the dimensional data model, wherein each of the plurality of dimension coordinates has a second particular grain (“finer grain”) that is finer than a first particular grain (“coarser grain”) and having a value at the finer grain (“finer grain value”) and at the coarser grain (“coarser grain value”), the report query specifying a dimension coordinate constraint to which the plurality of dimension coordinates correspond, the computer-implemented method being carried out by at least one computing device executing instructions from a computer-readable medium, the method comprising: for a temporal dimension having temporal characteristics of grain relationships including a subset of the plurality of dimension coordinates in which there is a time changing relationship of the grains over a time period of interest leading to-a potential ambiguity as to what coarser grain value to associate with a finer grain value in attributing facts at the finer grain value to the coarser grain value, wherein, for each of the dimension coordinates of the plurality of dimension coordinates not in the subset, the coarser grain value associated with that dimension coordinate is the coarser grain value of that dimension coordinate; the method further comprising by the at least one computing device, executing computer program instructions from the computer-readable medium to generate a report in view of the plurality of dimension coordinates and their associated coarser grain values.