=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


Date Type


Windows Data Type

Nominal storage allocation

Value range

System.Decimal

16 bytes

0 through +/-79,228,162,514,264,337,593,543,950,335 with no decimal point;

0 through +/-7.9228162514264337593543950335 with 28 places to the right of the decimal; smallest nonzero number is

+/-0.0000000000000000000000000001 (+/-1E-28).


Limitations


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


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


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