Patent Document ID: 8112387
Application ID: 13103006
Patent Status: 1

Claim One:
1. A computer program product for processing a request providing a specification of a dimension coordinate constraint and a specification of a particular associated grain for the dimension coordinate constraint, to a dimensionally-modeled fact collection, the computer program product comprising: at least one non-transitory computer-readable storage medium having computer program instructions stored therein which are configured to cause at least one computing device to implement a method of processing a request for information associated with dimensionally modeled organizational information in which an employee dimension includes a set of grains having a relationship with each other, the request including a specification of a dimension coordinate constraint and a specification of a particular associated grain for the dimension coordinate constraint, the method comprising: receiving the specification of a dimension coordinate constraint that is a team constraint and the specification of a particular associated grain for the team constraint corresponding to a person grain; processing an indication of a fact reporting mode, the fact reporting mode being selectable by a user designation; generating at least one query to a dimensionally-modeled fact collection; and processing a result of providing the at least one query to the dimensionally-modeled fact collection, wherein the processed result includes an indication of every dimension coordinate satisfying the team constraint, and wherein the processed result further includes: in response to the indication of the fact reporting mode being the fettered mode, reporting fettered facts of the dimensionally-modeled fact collection, the fettered facts including an attribution for every person in a person dimension coordinate satisfying the team constraint during a time period of interest, and in response to the indication of the fact reporting mode indicating an unfettered mode, automatically reporting unfettered facts of the dimensionally-modeled fact collection, the unfettered facts being specified by determining, for every person in the person dimension coordinate satisfying the team constraint, an attribution unbounded by the team constraint during the time period of interest; and returning the processed result in response to the request; the unfettered facts providing an additional type of selectable attribution information for the returned processed result that is not strictly bound by the team constraint to account for a situation in which one or more employees transition between teams over the time period of interest.