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


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


Syntax


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


Return Value


               DECIMAL


Example


               =mooCellQDR("UNITS_CUBE_COST", "CUSTOMER", "ACCOUNT_BAVARIAN IND", "TIME", "MONTH_2006.02", "CHANNEL", "TOTAL_TOTAL", "PRODUCT", "TOTAL_TOTAL")



Example Output


               41822.97


Limitations


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


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


•        FinanceHub supports retrieving data using mooCellQDR on cube between 1 and 14 dimensions in size.