Temporally-aware evaluative score

1. A method of processing a performance query to a dimensionally-modeled fact collection by processing dimension coordinates that exist within a dimensional data model of an organization having individual business agents assigned to organizational groups, wherein facts of the dimensionally-modeled fact collection are accessible according to the dimensional data model and wherein the dimension coordinates have a first particular grain (“finer grain”) that is finer than a second particular grain (“coarser grain”), the method to determine an evaluative score for a particular value at the finer grain (“finer grain value”) based on performance facts for dimension coordinates associated with the particular finer grain value, the method comprising:

determining at least one performance parameter, relative to a particular value at the coarser grain (“coarser grain value”), against which to measure the performance facts associated with the finer grain value, including processing temporal relationships of finer grain values to coarser grain values for the dimension coordinates, wherein processing the temporal relationships of finer grain values to coarser grain values includes processing data indicative of how relationships of the finer grain values to coarser grain values change over time and, based thereon, processing performance facts based on performance facts for dimension coordinates having the particular coarser grain value;

determining the evaluative score for the particular finer grain value based on performance facts of dimension coordinates having the particular finer grain value, in view of the at least one determined performance parameter;

wherein processing the temporal relationships of finer grain values to coarser grain values includes performing at least one of unfettering and disambiguation to account for a changing relationship of grains so that the evaluative score is adjusted to provide a different type of evaluation score than a score based on a static relationship of grain values;

said disambiguation comprising remapping the correspondence of fine-grained entities to coarser-grained entities when required to remove an ambiguity in how a fine grained entity maps to a coarser grained entity; and

said unfettering comprising re-expressing the constraint in terms of finer-grained entities of dimension coordinates satisfying an original, coarser-grained constraint when required to account for a time changing relationship between finer grains and coarser grains;

wherein the relationships of agents to groups is not static and a report is generated including at least one of a group score and an agent score in which said processing of temporal relationships affects scoring.

2. The method of claim 1 , wherein the at least one of a group score and an agent score includes a sales performance.

3. The method of claim 1 , wherein the at least one of a group score and agent score includes a call performance.

4. The method of claim 1 , wherein said disambiguation comprises:

processing data indicative of how the relationships of finer grain values to coarser grain values changes over time includes, for the particular coarser grain value,

determining a set of finer grain values for dimension coordinates having the particular coarser grain value;

determining a set of dimension coordinates having finer grain values in the determined set of finer grain values, including dimension coordinates having finer grain values in the determined set of finer grain values but not having the particular coarser grain value.

5. The method of claim 1 , wherein said unfettering comprises:

for the dimension coordinates having the particular finer grain value, on which the determination of evaluative score for the particular finer grain value is based, at least some of those dimension coordinates do not have the particular coarser grain value.

6. The method of claim 5 , wherein:

determining a set of dimension coordinates having finer grain values in the determined set of finer grain values, including dimension coordinates having finer grain values in the determined set of finer grain values but not having the particular coarser grain value includes:

processing a query constraint that is expressed in terms of the particular coarser grain value to determine an initial set of dimension coordinates; and

rewriting and reapplying the query constraint in terms of finer grain values of the determined initial set of dimension coordinates, to determine the set of dimension coordinates.

7. The method of claim 1 , wherein:

the particular finer grain value is a first particular finer grain value of a plurality of particular finer grain values; and

the method further comprises:

processing a temporal mode to determine a time extent descriptor; and

determining the plurality of finer grain values based at least in part on processing the determined time extent descriptor.

8. A computer program product for processing a performance query to a dimensionally-modeled fact collection by processing dimension coordinates that exist within a dimensional data model, wherein facts of the dimensionally-modeled fact collection of an organization having individual business agents assigned to organizational groups are accessible according to the dimensional data model and wherein the dimension coordinates have a first particular grain (“finer grain”) that is finer than a second particular grain (“coarser grain”), the method to determine an evaluative score for a particular value at the finer grain (“finer grain value”) based on performance facts for dimension coordinates associated with the particular finer grain value, the computer program product comprising at least one computer-readable medium having computer program instructions stored therein which are operable to cause at least one computing device to:

determine at least one performance parameter, relative to a particular value at the coarser grain (“coarser grain value”), against which to measure the performance facts associated with the finer grain value, including processing temporal relationships of finer grain values to coarser grain values for the dimension coordinates, wherein processing the temporal relationships of finer grain values to coarser grain values includes processing data indicative of how relationships of the finer grain values to coarser grain values change over time and, based thereon, processing performance facts based on performance facts for dimension coordinates having the particular coarser grain value; and

determine the evaluative score for the particular finer grain value based on performance facts of dimension coordinates having the particular finer grain value, in view of the at least one determined performance parameter;

wherein processing the temporal relationships of finer grain values to coarser grain values includes performing at least one of unfettering and disambiguation to account for a changing relationship of grains so that the evaluative score is adjusted to provide a different type of evaluation score than a score based on a static relationship of grain values;

said disambiguation comprising remapping the correspondence of fine-grained entities to coarser-grained entities when required to remove an ambiguity in how a fine grained entity maps to a coarser grained entity; and

said unfettering comprising re-expressing the constraint in terms of finer-grained entities of dimension coordinates satisfying an original, coarser-grained constraint when required to account for a time changing relationship between finer grains and coarser grains;

wherein the relationships of agents to groups is not static and a report is generated including at least one of a group score and an agent score in which said processing of temporal relationships affects scoring.

9. The computer program product of claim 8 , wherein the at least one of a group score and an agent score includes a sales performance.

10. The computer program product of claim 8 , wherein the at least one of a group score and an agent score includes a call performance.

11. The computer program product of claim 8 , wherein said disambiguation comprises:

processing data indicative of how the relationships of finer grain values to coarser grain values changes over time includes, for the particular coarser grain value, includes

determining a set of finer grain values for dimension coordinates having the particular coarser grain value;

determining a set of dimension coordinates having finer grain values in the determined set of finer grain values, including dimension coordinates having finer grain values in the determined set of finer grain values but not having the particular coarser grain value.

12. The computer program product of claim 8 , wherein said unfettering comprises:

for the dimension coordinates, having the particular finer grain value, on which the determination of performance score for the particular finer grain value is based, at least some of those dimension coordinates do not have the particular coarser grain value.

13. The computer program product of claim 12 , wherein:

determining a set of dimension coordinates having finer grain values in the determined set of finer grain values, including dimension coordinates having finer grain values in the determined set of finer grain values but not having the particular coarser grain value includes:

processing a query constraint that is expressed in terms of the particular coarser grain value to determine an initial set of dimension coordinates; and

rewriting and reapplying the query constraint in terms of finer grain values of the determined initial set of dimension coordinates, to determine the set of dimension coordinates.

14. The computer program product of claim 8 , wherein:

the particular finer grain value is a first particular finer grain value of a plurality of particular finer grain values; and

the computer program instructions are further operable to cause at least one computing device to:

process a temporal mode to determine a time extent descriptor; and

determine the plurality of finer grain values based at least in part on processing the determined time extent descriptor.

15. A computer system configured to process a performance query to a dimensionally-modeled fact collection by processing dimension coordinates that exist within a dimensional data model, wherein facts of the dimensionally-modeled fact collection of an organization having individual business agents assigned to organizational groups are accessible according to the dimensional data model and wherein the dimension coordinates have a first particular grain (“finer grain”) that is finer than a second particular grain (“coarser grain”), the method to determine an evaluative score for a particular value at the finer grain (“finer grain value”) based on performance facts for dimension coordinates associated with the particular finer grain value, the computer system configured to:

determine performance parameters, relative to a particular coarser grain value, against which to measure the performance facts associated with the finer grain value, including processing the temporal relationships of finer grain values to coarser grain values for the dimension coordinates; and

determine the evaluative score for the particular finer grain value based on performance facts of dimension coordinates having the particular finer grain value, in view of the determined performance parameters;

wherein processing the temporal relationships of finer grain values to coarser grain values includes performing at least one of unfettering and disambiguation to account for a changing relationship of grains so that the evaluative score is adjusted to provide a different type of evaluation score than a score based on a static relationship of grain values;

said disambiguation comprising remapping the correspondence of fine-grained entities to coarser-grained entities when required to remove an ambiguity in how a fine grained entity maps to a coarser grained entity; and

said unfettering comprising re-expressing the constraint in terms of finer-grained entities of dimension coordinates satisfying an original, coarser-grained constraint when required to account for a time changing relationship between finer grains and coarser grains;

wherein the relationships of agents to group is not static and a report is generated including at least one of a group score and an agent score in which said processing of temporal relationships affects scoring.

16. The computer system of claim 15 , wherein the at least one of a group score and an agent score includes a sales performance.

17. The computer system of claim 15 , wherein the at least one of a group score and an agent score includes a call performance.

18. The computer system of claim 15 , wherein said disambiguation comprises:

processing data indicative of how the relationships of finer grain values to coarser grain values changes over time includes, for the particular coarser grain value, includes

determining a set of finer grain values for dimension coordinates having the particular coarser grain value;

determining a set of dimension coordinates having finer grain values in the determined set of finer grain values, including dimension coordinates having finer grain values in the determined set of finer grain values but not having the particular coarser grain value.

19. The computer system of claim 15 , wherein said unfettering comprises:

for the dimension coordinates, having the particular finer grain value, on which the determination of performance score for the particular finer grain value is based, at least some of those dimension coordinates do not have the particular coarser grain value.

20. The computer system of claim 19 , wherein:

determining a set of dimension coordinates having finer grain values in the determined set of finer grain values, including dimension coordinates having finer grain values in the determined set of finer grain values but not having the particular coarser grain value includes:

processing a query constraint that is expressed in terms of the particular coarser grain value to determine an initial set of dimension coordinates; and

rewriting and reapplying the query constraint in terms of finer grain values of the determined initial set of dimension coordinates, to determine the set of dimension coordinates.

21. The computer system of claim 15 , wherein:

the particular finer grain value is a first particular finer grain value of a plurality of particular finer grain values; and

the computer system is further configured to:

process a temporal mode to determine a time extent descriptor; and

determine the plurality of finer grain values based at least in part on processing the determined time extent descriptor.

22. A method of processing a performance query to a dimensionally-modeled fact collection by processing dimension coordinates that exist within a dimensional data model having slowly changing dimensions, wherein facts of the dimensionally-modeled fact collection are accessible according to the dimensional data model and wherein the dimension coordinates have a first particular grain (“finer grain”) that is finer than a second particular grain (“coarser grain”), the method to determine an evaluative score for a particular value at the finer grain (“finer grain value”) based on performance facts for dimension coordinates associated with the particular finer grain value, the method comprising:

determining at least one performance parameter, relative to a particular value at the coarser grain (“coarser grain value”), against which to measure the performance facts associated with the finer grain value, including processing temporal relationships of finer grain values to coarser grain values for the dimension coordinates, wherein processing the temporal relationships of finer grain values to coarser grain values includes processing data indicative of how relationships of the finer grain values to coarser grain values change over time and, based thereon, processing performance facts based on performance facts for dimension coordinates having the particular coarser grain value;

determining the evaluative score for the particular finer grain value based on performance facts of dimension coordinates having the particular finer grain value, in view of the at least one determined performance parameter;

wherein processing the temporal relationships of finer grain values to coarser grain values includes performing at least one of unfettering and disambiguation, and to account for a changing relationship of grains so that the evaluative score is adjusted to provide a different type of evaluation score than a score based on a static relationship of grain values;

said disambiguation comprising remapping the correspondence of fine-grained entities to coarser-grained entities when required to remove an ambiguity in how a fine grained entity maps to a coarser grained entity; and

said unfettering comprising re-expressing the constraint in terms of finer-grained entities of dimension coordinates satisfying an original, coarser-grained constraint when required to account for a time changing relationship between finer grains and coarser grains; and

generating a report including at least one statistical measure of performance based on the evaluative score.

23. The method of claim 22 , wherein the dimensionally-modeled fact collection is for an organization having individual employee agents assigned to teams and the report includes a sales performance for teams that is different than for scoring based on a static relationship of employee agents to teams.

24. The method of claim 22 , wherein the dimensionally-modeled fact collection is for an organization having individual employee agents assigned to teams and the report includes a sales performance for agents that is different than for scoring based on a static relationship of employee agents to teams.

25. A computer program product for processing a performance query to a dimensionally-modeled fact collection by processing dimension coordinates that exist within a dimensional data model having slowly changing dimensions, wherein facts of the dimensionally-modeled fact collection are accessible according to the dimensional data model and wherein the dimension coordinates have a first particular grain (“finer grain”) that is finer than a second particular grain (“coarser grain”), the method to determine an evaluative score for a particular value at the finer grain (“finer grain value”) based on performance facts for dimension coordinates associated with the particular finer grain value, the computer program product comprising at least one computer-readable medium having computer program instructions stored therein which are operable to cause at least one computing device to:

determine at least one performance parameter, relative to a particular value at the coarser grain (“coarser grain value”), against which to measure the performance facts associated with the finer grain value, including processing temporal relationships of finer grain values to coarser grain values for the dimension coordinates, wherein processing the temporal relationships of finer grain values to coarser grain values includes processing data indicative of how relationships of the finer grain values to coarser grain values change over time and, based thereon, processing performance facts based on performance facts for dimension coordinates having the particular coarser grain value; and

determine the evaluative score for the particular finer grain value based on performance facts of dimension coordinates having the particular finer grain value, in view of the at least one determined performance parameter;

wherein processing the temporal relationships of finer grain values to coarser grain values includes performing at least one of unfettering and disambiguation to account for a changing relationship of grains so that the evaluative score is adjusted to provide a different type of evaluation score than a score based on a static relationship of grain values;

said disambiguation comprising remapping the correspondence of fine-grained entities to coarser-grained entities when required to remove an ambiguity in how a fine grained entity maps to a coarser grained entity; and

said unfettering comprising re-expressing the constraint in terms of finer-grained entities of dimension coordinates satisfying an original, coarser-grained constraint when required to account for a time changing relationship between finer grains and coarser grains; and

generating a report including at least one statistical measure of performance based on the at least one evaluative score.

26. The computer program product of claim 25 , wherein the dimensionally-modeled fact collection is for an organization having individual employee agents assigned to teams and the report includes a sales performance for teams that is different than for scoring based on a static relationship of employee agents to teams.

27. The computer program product of claim 25 , wherein the dimensionally-modeled fact collection is for an organization having individual employee agents assigned to teams and the report includes a sales performance for agents that is different than for scoring based on a static relationship of employee agents to teams.