mooFRDescDown ([DIMENSION], [OLAP VARIABLE])


The mooFRDescDown function returns a one dimensional array on the Y axis from 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.

 

mooFRDescDown is primarily used to return either row or column descriptive data, however, it can be used to return any one dimensional array back to the calling desktop application.

 

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

 

mooFRDescDown should only be used against one dimensional variables


Syntax


               

                 mooFRDescDown ([DIMENSION], [OLAP VARIABLE])


Return Value


               STRING


Example


               array = (o.mooFRDescDown("CUSTOMER", "CUSTOMER.DESC")