=mooQN(“[NUMERIC_VARIABLE_NAME]([DIMENSION1_NAME] '[DIMENSION_VALUE]')”)


Returns numerical data from an Oracle OLAP numerical cube or variable.


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


Syntax

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


Return Value


               DECIMAL

Example


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



Example Output


               41,823


Limitations


•        Can only be used to return NUMERIC data, numerical data must be returned using the mooCellQN or mooQ function.


       Data Types permissible with mooQN


       INTEGER

       SHORTINTEGER

       LONGINTEGER

       DECIMAL

       SHORTDECIMAL

       NUMBER


•        mooQN cannot be seen interacting with the OLAP engine through the Oracle OLAP RECAP DML statement.  

       If you are unsure as to why a specific mooQN retrieve is failing, the end-user can switch to mooQ in order to see the interaction with the Oracle OLAP

         option.


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