Patent Document ID: 20080154556
Application ID: 11615694
Patent Status: 0

Claim One:
1. A 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”), the report query specifying a dimension coordinate constraint to which the plurality of dimension coordinates correspond, the method comprising: for a subset of the plurality of dimension coordinates, wherein each of the dimension coordinates of the subset is such that there is at least one other dimension coordinate of the subset having a value at the finer grain (“finer grain value”) that is the same as the finer grain value of that dimension coordinate; and the at least one other dimension coordinate also has a value at the coarser grain (“coarser grain value”) that is different from the coarser grain value of that dimension coordinate, for every unique finer grain value of the dimension coordinates of the subset, determining the coarser grain value to associate with all dimension coordinates of the subset having that finer grain value, wherein the determined coarser grain value is the coarser grain value of one of the dimension coordinates, of the subset, having that finer 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 generating a report in view of the plurality of dimension coordinates and their associated coarser grain values.