=mooCellQDRT(“[CUBE]”, “[dim1]”, “[dim1value]”, “[dim2]”, “[dim2value]”, etc....)


Returns the text result of a qualified data reference from a text variable within an Analytic Workspace.


Syntax


               =mooCellQDRT("[CUBE]", "[dim1]", "[dim1value]", "[dim2]", "[dim2value]", etc....)


Return Value


               STRING


Example


               =mooCellQDRT(SYS.CFG, SYS.ROW, "FAILED_PASSWORD_LOCK", SYS.COL, "VALUE")



Example Output


               YES


Limitations


•        Can only be used to return TEXT data, numerical data must be returned using the mooCellQDR() function.


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


•        FinanceHub supports retrieving data using mooCellQDRT on cubes with between 1 and 14 dimensions.