=mooDesc(“[dim]” “[dimval]”)


Returns the Long Description of a dimension value for a given dimension.  


Requires the Analytic Workspace meta-data to conform to Oracle OLAP standard form definition.  

Alternatively, this function can be used after the application DBA defines a formula text variable with the name [DIMENSION]_LONG_DESCRIPTION which references the non-standard named description variable.


Syntax


               =mooDesc("[dim]", "[dimval]")



Return Value


               STRING


Example


               =mooDesc("CUSTOMER", "ACCOUNT_BAVARIAN IND")



Example Output


               Bavarian Industries