Example of an Excel VBA application using the mooFRDescAcross function:
array = (o.mooFRDescAcross("TIME", "TIME.DESC")
Returns a one dimensional array on the X axis from Oracle OLAP
Syntax
mooFRDescAcross ([DIMENSION], [OLAP VARIABLE])
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
Microsoft®, WINDOWS®, Microsoft Excel®, Microsoft Office® are registered trademarks of Microsoft Corporation.
ORACLE® is a registered trademark of ORACLE Corporation.
® SDMC Consulting Limited 2010
