Reporting on facts relative to a specified dimensional coordinate constraint

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 attributing credit for contacts handled within an organization having dimensionally modeled employee organizational information including dimension coordinates and associated grains by processing a request including a specification of a dimension coordinate constraint defining a team in the organization chart and a specification of a person grain for the team constraint, to a dimensionally-modeled fact collection, the method comprising:

• receiving a specification of the team constraint and a specification of a person grain for the team constraint;
• processing an indication of a fact reporting mode, the fact reporting mode being selectable by a user designation;
• generating at least one query to the dimensionally-modeled fact collection;
• and
• processing a result of providing the at least one query to the dimensionally-modeled fact collection and returning a report,
• wherein the report includes an indication of every person in a person dimension coordinate satisfying the team constraint, and
• wherein the processed result further includes:
• fettered facts of the dimensionally-modeled fact collection, the fettered facts being specified for every person in a person dimension coordinate satisfying the team constraint while a member of the team during a time period of interest to attribute the number of communication contacts handled by each member of the time while they are members of a team satisfying the team constraint during the time period of interest, and
• in response to the indication of the fact reporting mode indicating an unfettered mode, automatically including 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, facts unbounded by the team constraint to attribute the total number of communication contacts handled by each person that is a member of the team for any portion of the time period of interest;
• and
• returning the processed result in response to the request;
• the unfettered facts providing an additional type of selectable 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 individual persons transition between teams over the time period of interest.

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 an organizational chart having an employee dimension and associated grains by providing a request including a specification of a dimension coordinate constraint that is a team constraint and a specification of a particular associated grain corresponding to a person grain, to a dimensionally-modeled fact collection, the method comprising:

• receiving the specification of the team constraint and the specification of the person grain for the team constraint;
• processing an indication of a fact reporting mode selectable by a user designation, wherein the fact reporting mode is one of a fettered mode and an unfettered mode;
• generating at least one query to the dimensionally-modeled fact collection;
• processing a result of providing the at least one query to the dimensionally-modeled fact collection, and
• processing the indicated fact reporting mode;
• wherein in a first pass of processing the processed result includes:
• an indication of every dimension member at the person level satisfying the team constraint, wherein for the fettered mode facts reporting facts attributed to each dimension member that is a member of a team satisfying the team constraint during a time period of interest;
• and
• wherein for the unfettered mode, performing a second pass of processing for each dimension member determined in the first pass of processing, the second pass of processing and reporting facts attributed to each respective dimension member unbounded by the team constraint;
• the unfettered facts providing an additional type of selectable information for the returned processed result that is not strictly bound by the team constraint to account for a situation in which at least one person is related to more than one team over a time period of interest.

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 to attribute factual information handled within an organization having 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, to a dimensionally-modeled fact collection, the method comprising:

• receiving the specification of a dimension coordinate constraint and the specification of an associated 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 the 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 dimension coordinate satisfying the team constraint, and
• wherein the processed result further includes:
• fettered facts of the dimensionally-modeled fact collection, the fettered facts including a fact attribution for every dimension in the dimension coordinate constraint satisfying the dimension coordinate constraint during a time period of interest, and
• in response to the indication of the fact reporting mode indicating an unfettered mode, automatically including unfettered facts of the dimensionally-modeled fact collection, the unfettered fact attribution being specified by determining for every dimension value satisfying the dimension coordinate constraint, attribution information unbounded by the dimension coordinate 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 for the returned processed result that is not strictly bound by the dimension coordinate constraint to account for a situation in which the grain relationships change during the time period of interest.

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:

• processing a result of providing 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 a fact reporting mode being a 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.

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, an initial 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

• processing a result of providing 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 a fact reporting mode being a 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.

A method of processing a request in a system having a dimensionally modeled fact collection, a fact collection query generator to generate queries for the dimensionally modeled fact collection, and a report generator to process results received from the dimensionally modeled fact collection and generate reports, the request including a specification of a dimension coordinate constraint and a specification of a particular associated grain for the dimension coordinate constraint to the dimensionally-modeled fact collection, the method comprising:

• providing, via a user interface, a specification of the dimension coordinate constraint and the specification of the particular associated grain for the dimension coordinate constraint;
• providing, via the user interface, an indication of a fact reporting mode selectable by a user designation, wherein the fact reporting mode is one of a fettered mode and an unfettered mode;
• receiving a processed result from the system via the user interface;
• wherein the processed result includes:
• an indication of every dimension coordinate satisfying the dimension coordinate constraint and having a particular value at the associated grain;
• and
• if the result of processing the indicated fact reporting mode is that the indicated fact reporting mode is a fettered mode or an unfettered mode, facts of the dimensionally-modeled fact collection specified by the every dimension coordinate satisfying the dimension coordinate constraint;
• if the result of processing the indicated fact reporting mode is that the indicated fact reporting mode is an unfettered mode, automatically including facts of the dimensionally-modeled fact collection for at least one other dimension coordinate that does not satisfy the dimension coordinate constraint, wherein each of the at least one other dimension coordinate has a value at the associated grain that is the same as the value at the associated grain of one of the every dimension coordinates that does satisfy the dimension coordinate constraint.

A method of attributing credit for contacts handled within an organization having dimensionally modeled employee organizational information including dimension coordinates and associated grains by utilizing a system having a dimensionally modeled fact collection, a fact collection query generator to generate queries to the dimensionally modeled fact collection, and a report generator to process results generated from the dimensionally modeled fact collection, the queries being by the fact collection query generator by processing a request including a specification of a dimension coordinate constraint defining a team in the organization chart and a specification of a person grain for the team constraint to the dimensionally-modeled fact collection, the method comprising:

• providing, via a user interface, a specification of the team constraint and a specification of a person grain for the team constraint;
• providing, via a user interface, an indication of a fact reporting mode, the fact reporting mode being selectable by a user designation;
• receiving a processed result from the report generator via the user interface;
• wherein the processed result includes:
• an indication of every person in a person dimension coordinate satisfying the team constraint, and
• wherein the processed result further includes:
• fettered facts of the dimensionally-modeled fact collection, the fettered facts being specified for every person in a person dimension coordinate satisfying the team constraint while a member of the team during a time period of interest to attribute the number of communication contacts handled by each member of the time while they are members of a team satisfying the team constraint during the time period of interest, and
• in response to the indication of the fact reporting mode indicating an unfettered mode, automatically including 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, facts unbounded by the team constraint to attribute the total number of communication contacts handled by each person that is a member of the team for any portion of the time period of interest;
• and
• returning the processed result in response to the request;
• the unfettered facts providing an additional type of selectable 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 individual persons transition between teams over the time period of interest.

A system for processing a request including 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 system comprising:

• a user interface to input the request;
• a fact collection query generator;
• at least one database configured to store fact data associated with the dimensionally modeled fact collection;
• and
• a report generator to process results obtained from the dimensionally modeled fact collection;
• the fact collection query generator configured to:
• receive the specification of the dimension coordinate constraint and the specification of the particular associated grain for the dimension coordinate constraint;
• process an indication of a fact reporting mode, the fact reporting mode being selectable by a user designation;
• generate at least one query to the dimensionally-modeled fact collection;
• and
• the report generator 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 dimension coordinate constraint, and
• wherein the processed result further includes:
• fettered facts of the dimensionally-modeled fact collection, the fettered facts being specified by the every dimension coordinate satisfying the dimension coordinate constraint, and
• in response to the indication of the fact reporting mode indicating an unfettered mode, automatically including unfettered facts of the dimensionally-modeled fact collection, the unfettered facts being specified by at least one other dimension coordinate that does not satisfy the dimension coordinate constraint, wherein each of the at least one other dimension coordinate has a value at the associated grain that is the same as the value at the associated grain of one of the every dimension coordinate that does satisfy the dimension coordinate constraint;
• and
• returning the processed result to the user interface in response to the request;
• the unfettered facts providing an additional type of selectable information for the returned processed result that is not strictly bound by the dimension coordinate constraint to account for a situation in which at least one value at a selected grain level is related to more than one dimension coordinate at another grain level over a time period of interest.

A system for processing a request including 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 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 system comprising:

• a user interface to input the request;
• a fact collection query generator;
• at least one database configured to store fact data associated with the dimensionally modeled fact collection;
• and
• a report generator to process results obtained from the dimensionally modeled fact collection;
• the fact collection query generator configured to:
• receive 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;
• process an indication of a fact reporting mode, the fact reporting mode being selectable by a user designation;
• generate at least one query to a dimensionally-modeled fact collection;
• and
• the report generator 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.