System and method for real time data aggregation in a virtual cube in a multidimensional database environment

A method for real time data aggregation in a virtual cube in a multidimensional database, comprising:

• providing, at a computer that includes one or more microprocessors;
• a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one multidimensional cube, and
• a data source associated with the multidimensional cube;
• querying, by the multidimensional cube, the data source, the query comprising an identification of at least one source of real-time data accessible the data source;
• providing, by the data source, on-demand access to the multidimensional cube to the at least one source of real-time data;
• using targeted data from the at least one source of real-time data within the multidimensional cube without being stored therein.

A non-transitory computer readable storage medium having for real time data aggregation in a virtual cube in a multidimensional database, which when read and executed cause a computer to perform steps comprising:

• providing, at the computer that includes one or more microprocessors;
• a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one multidimensional cube, and
• a data source associated with the multidimensional cube;
• querying, by the multidimensional cube, the data source, the query comprising an identification of at least one source of real-time data accessible the data source;
• providing, by the data source, on-demand access to the multidimensional cube to the at least one source of real-time data;
• using targeted data from the at least one source of real-time data within the multidimensional cube without being stored therein.