mooFR ([DOWN_DIM], [ACROSS_DIM], [OLAP VARIABLE])


The mooFR function returns a two dimensional array from a variable in Oracle OLAP.  The contents of the array (table) passed back can then either be further processed in VBA or passed directly to a worksheet within Excel for reporting.

 

To ensure valid data is returned by this function it is the responsibility of the calling application to ensure that only the DOWN and ACROSS dimensions have one or more values in status.

 

If you are using mooFR against a variable with more than two dimensions you should limit the paging dimensions to only one value each.

 

mooFR can not be used against one dimensional variables, however mooFRDescDown or mooFRDescAcross can be used in these circumstances, even for numeric data.

 

mooFR observes the current status of the DOWN and ACROSS dimensions within the Oracle OLAP database and it is the responsibility of the calling application or user to set these appropriately.


Syntax


               

                 mooFR ([DOWN_DIM], [ACROSS_DIM], [OLAP VARIABLE])


Return Value


               STRING


Example


               array = (o.mooFR("CUSTOMER", "TIME", "UNITS_CUBE_COST")