Example of an Excel formula using the mooQ function:
=moodQ("CUBE(DIM1, DIMVAL1, DIM2, DIMVAL2..... DIMx, DIMVALx)")
Returns the contents of a cell based on the fully qualified reference for the given cube.
mooQ can be seen in the recap function of ORACLE OLAP.
Syntax
mooq(“[QDR]”)
Where [QDR] is a fully qualified node of a cube
Microsoft®, WINDOWS®, Microsoft Excel®, Microsoft Office® are registered trademarks of Microsoft Corporation.
ORACLE® is a registered trademark of ORACLE Corporation.
® SDMC Consulting Limited 2010
