System and method for analyzing and reporting extensible data from multiple sources in multiple formats

A computer-implemented method for generating dimensional analytical models from extensible data, the method comprising:

• acquiring, at a server, via one or more adapters one or more pieces of data from a plurality of data sources, wherein the plurality of data sources includes at least relational data sources and non-relational data sources;
• generating, using the server, a XOLAP virtual schema from the aggregated pieces of data without using a data warehouse and without a data warehouse model, wherein the XOLAP virtual schema is an Extensible Markup Language (XML) based multidimensional index of the plurality of data sources and is updated incrementally by virtually transforming the aggregated pieces of data using one or more virtual schema operators;
• generating, using the server, a multidimensional analytical model populated with the aggregated pieces of data from the plurality of data sources indexed by the XOLAP virtual schema;
• and
• wherein forming the multidimensional analytical model further comprises using a declarative language to describe the multidimensional analytical model by executing commands from the declarative language against the XOLAP virtual schema;
• and
• generating, using the server, one or more reports based on a subset of data in the multidimensional analytical model.

A non-transitory computer readable medium that stores a set of instructions that are executable by at least one or more processors of a server to cause the server to perform a method for generating dimensional analytical models from extensible data, the method comprising:

• acquiring via one or more adapters one or more pieces of data from a plurality of data sources, wherein the plurality of data sources includes at least relational data sources and non-relational data sources;
• generating a XOLAP virtual schema from the aggregated pieces of data without using a data warehouse and without a data warehouse model, wherein the XOLAP virtual schema is an Extensible Markup Language (XML) based multidimensional index of the plurality of data sources and is updated incrementally by virtually transforming the aggregated pieces of data using one or more virtual schema operators;
• generating a multidimensional analytical model populated with the aggregated pieces of data from the plurality of data sources indexed by the XOLAP virtual schema for the one or more pieces of data from the one or more data sources, wherein forming the multidimensional analytical model further comprises using a declarative language to describe the multidimensional analytical model by executing commands from the declarative language against the XOLAP virtual schema;
• and
• generating one or more reports based on a subset of data in the multidimensional analytical model.