mooFRDescAcross ([DIMENSION], [OLAP VARIABLE])


The mooFRDescAcross function returns a one dimensional array on the X 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.

 

mooFRDescAcross 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.

 

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

 

mooFRDescAcross should only be used against one dimensional variables


Syntax


               

                 mooFRDescAcross ([DIMENSION], [OLAP VARIABLE])


Return Value


               STRING


Example


               array = (o.mooFRDescAcross("TIME", "TIME.DESC")