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