In addition to the cell based functions there are mooFR functions which can be used to retrieve data from Oracle OLAP in a very fast way. These retrieve data in to arrays rather single cells.

 

Please refer to the example code within the myObjectiveOLAP-Examples workbook when reviewing this explanation

 

In the examples taken from the myObjectiveOLAP-Examples workbook we are asking Oracle OLAP to return a two dimensional array (table) to VBA for the current status of the Customer and Time dimensions from the UNITS_CUBE_COST OLAP variable.

 

The result of using these three functions is the end generation of a report by Channel and Time.

 

Unlike the cell based reports; reports built from mooFR functions can automatically expand when new dimension values are added.