Real time datamining

1. A method comprising:

determining a plurality of dimensions within a reporting pyramid model to be used as statistical variables, the reporting pyramid model comprising a plurality of pyramid levels;

identifying criteria for retrieving lower level data associated with a value from a first report corresponding to one of the plurality of pyramid levels;

submitting to a database, by a processing device, a request for a dataset, wherein the request is in view of the plurality of dimensions and the criteria;

receiving the dataset in response to the request;

applying to the dataset, by the processing device, a user-selected statistical function; and

creating, by the processing device, a second report in view of the user-selected statistical function.

2. The method of claim 1 , wherein the user-selected statistical function is one of a linear regression, a quantile regression, a covariance, a Pearson Product-Moment correlation, a correlation coefficient, a standard deviation, a variance, or a distribution test.

3. The method of claim 1 , wherein determining the plurality of dimensions comprises:

displaying a first list of independent dimensions available at one of the plurality of pyramid levels of the first report;

displaying a second list of dependent dimensions available at the one of the plurality of pyramid levels of the first report; and

receiving a user selection of independent and dependent dimensions from the first and second lists for use as statistical variables.

4. The method of claim 1 , wherein the lower level data is transactional data from one or more a transactional database.

5. The method of claim 1 , further comprising identifying, in view of a user input, the user-selected statistical function.

6. The method of claim 1 further comprising:

receiving a datamining request from a user;

in response to receiving the datamining request, determining whether a reporting system is currently linked to a database management system; and

when the reporting system is not currently linked to the database management system, notifying the user that the datamining is currently unavailable.

7. The method of claim 6 further comprising:

when the reporting system is currently linked to the database management system, determining whether any databases of the database management system are inactive; and

when any databases are inactive, blocking options associated with the inactive databases.

8. The method of claim 1 wherein the datamining request is a databases query or a database application programming interface (API) call.

9. The method of claim 1 , wherein each of the plurality of dimensions is associated with a pyramid level.

10. The method of claim 1 , wherein the reporting pyramid model comprises a top and a bottom, the top of the pyramid comprising a lesser amount of detail than the bottom of the pyramid.

11. A system comprising:

a memory to store a first report and a second report; and

a processing device to:

determine a plurality of dimensions within a reporting pyramid model to be used as statistical variables, the reporting pyramid model comprising a plurality of pyramid levels,

identify criteria for retrieving lower level data associated with a value from the first report corresponding to one of the plurality of pyramid levels,

submit a request for a dataset to a database, wherein the request is in view of the plurality of dimensions and the criteria,

receive the dataset in response to the request,

apply to the dataset a user-selected statistical function, and

create the second report in view of the user-selected statistical function.

12. The system of claim 11 , wherein the user-selected statistical function is one of a linear regression, a quantile regression, a covariance, a Pearson Product-Moment correlation, a correlation coefficient, a standard deviation, a variance, or a distribution test.

13. The system of claim 11 , wherein when determining the plurality of dimensions, the processing device is to:

display a first list of independent dimensions available at one of the plurality of pyramid levels of the first report;

display a second list of dependent dimensions available at the one of the plurality of pyramid levels of the first report; and

receive a user selection of independent and dependent dimensions from the first and second lists for use as statistical variables.

14. The system of claim 11 , wherein the processing device is further to:

receive a datamining request from a user;

in response to receiving the datamining request, determine whether a reporting system is currently linked to a database management system; and

when the reporting system is not currently linked to the database management system, notify the user that datamining is currently unavailable.

15. A non-transitory computer readable storage medium including instructions that, when executed by a processing device, cause the processing device to perform operations comprising:

determining a plurality of dimensions within a reporting pyramid model to be used as statistical variables, the reporting pyramid model comprising a plurality of pyramid levels;

identifying criteria for retrieving lower level data associated with a value from a first report corresponding to one of the plurality of pyramid levels;

submitting to a database, by the processing device, a request for a dataset, wherein the request is in view of the plurality of dimensions and the criteria;

receiving the dataset in response to the request;

applying to the dataset by the processing device, a user-selected statistical function; and

creating, by the processing device, a second report based on the statistical function.

16. The non-transitory computer readable storage medium of claim 15 , wherein the statistical function is one of a linear regression, a quantile regression, a covariance, a Pearson Product-Moment correlation, a correlation coefficient, a standard deviation, a variance, or a distribution test.

17. The non-transitory computer readable storage medium of claim 15 , wherein determining the plurality of dimensions comprises:

displaying a first list of independent dimensions available at one of the plurality of pyramid levels of the first report;

displaying a second list of dependent dimensions available at the one of the plurality of pyramid levels of the first report; and

receiving a user selection of independent and dependent dimensions from the first and second lists for use as statistical variables.

18. The non-transitory computer readable storage medium of claim 15 , wherein the lower level data is transactional data from a transactional database.

19. The non-transitory computer readable storage medium of claim 15 , wherein the operations further comprise:

receiving a datamining request from a user;

in response to receiving the datamining request, determining whether a reporting system is currently linked to a database management system; and

when the reporting system is not currently linked to the database management system, notifying the user that datamining is currently unavailable.

20. The non-transitory computer readable storage medium of claim 19 , wherein the operations further comprise:

when the reporting system is currently linked to the database management system, determining whether any databases of the database management system are inactive; and

when any of the databases are inactive, blocking options associated with the inactive databases.