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