=mooQ(“[VARIABLE_NAME]([DIMENSION1_NAME] '[DIMENSION_VALUE]')”)


Returns numerical data (as String) or text data from an Oracle OLAP cube or variable.


When you know the data type of a variable is numeric or text you should use mooQN or mooQT instead of mooQ in order to maximize performance of retrieved data.  



Syntax

               =mooQ("[TEXT_VARIABLE_NAME]([DIMENSION_NAME] '[DIMENSION_VALUE]')")


Return Value


               STRING

Example


               =mooQ("UNITS_CUBE_COST ( customer 'ACCOUNT_BAVARIAN IND' TIME 'MONTH_2006.02'  channel 'TOTAL_TOTAL' product 'TOTAL_TOTAL' )")

               =mooQ("CUSTOMER_LONG_DESCRIPTION(CUSTOMER 'ACCOUNT_CICI-D')")


Example Output


               41823

               CiCi Douglas

               

Notes


•        Slower than data type specific FinanceHub Excel formula


       Data Types permissible with mooQ


       ALL (with the exception of RAW)


•        mooQ can be seen interacting with the OLAP engine through the Oracle OLAP RECAP DML statement.  


•        FinanceHub supports retrieving data using mooQ on Oracle OLAP cubes of all dimension numbers.