Interactive on-demand hypercube synthesis based multi-dimensional drilldown and a pivotal analysis tool and methods of use

A system comprising an apparatus having at least one processor and at least one memory including computer program code having a means to access at least one transactional data store, the at least one memory and the computer program code configured to, with the at least one processor, cause the system to:

• accessing said transactional data store, said transactional data store comprising an at least one data set, said at least one data set containing information pertaining to a plurality of individuals, each of said plurality of individuals corresponding to a unique individual identifier;
• request a data from a first plurality of categories of information from said at least one data set stored on said transactional data store;
• build a first multi-dimensional hypercube from said data, having a plurality of dimensions corresponding to said plurality of categories of information;
• flatten said first multi-dimensional hypercube into a banded single-dimensional array;
• identify a set of fields for use as pivots along said single-dimensional array;
• and
• build at least one successive multi-dimensional hypercube by requesting and receiving a second plurality of categories of information from said at least one data set stored on said transactional data store, said at least one successive multi-dimensional hypercube having dimensions corresponding to said set of fields for use as pivots;
• wherein each of said at least one successive multi-dimensional hypercube contains an incrementally smaller subset of data.

A method for facilitating an interactive on-demand hypercube synthesis based multi-dimensional drilldown and pivotal analysis tool, the method comprising the steps of:

• connecting to a transactional data store, said transactional data store comprising an at least one data set, said at least one data set containing information pertaining to a plurality of individuals, said individuals each corresponding to a unique individual identifier;
• requesting a data from a plurality of categories of information from said at least one data set stored on said transactional data store;
• transmitting said data from said transactional data store and receiving said data;
• building a first multi-dimensional hypercube from said data, having dimensions corresponding to said plurality of categories of information;
• flattening said first multi-dimensional hypercube into a banded single-dimensional array;
• identifying a set of fields for use as pivots along said banded single-dimensional array;
• and
• building at least one successive multi-dimensional hypercube, said at least one successive multi-dimensional hypercube having dimensions corresponding to said set of fields for use as pivots;
• wherein each of said at least one successive multi-dimensional hypercube contains an incrementally smaller subset of data.