=mooQT(“[TEXT_VARIABLE_NAME]([DIMENSION_NAME] '[DIMENSION_VALUE]')”)


Returns textual data from an Oracle OLAP TEXT cube or variable.


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


Syntax

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


Return Value


               STRING


Example


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



Example Output


               CiCi Douglas



Limitations


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

       

       Data Types permissible with mooQN


       TEXT


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

       If you are unsure as to why a specific mooQT 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 mooQT on Oracle OLAP cubes of all dimension numbers.