=mooDimDesc(“[DIMENSION]”, “[DIMENSION_VALUE]”, [OPTION])


Returns the description for a given dimension value in a mooServer enabled Analytic Workspace


Syntax


               =mooDimDesc("[DIMENSION]", "[DIMENSION_VALUE]", [OPTION])


Return Value


               STRING


Option


          The third option argument tells the mooDimDesc function what description you wish to retrieve:


               Option   0

                     Passing 0 returns the column description

               

               Option   1                

                     Passing 1 returns the row description


               Option   2                

                     Passing 2 returns the long description description



Example 1


               =mooDimDesc("CUSTOMER", "ACCOUNT_BAVARIAN IND", 0)


Example Output


               ACCOUNT_BAVARIAN IND





Example 2


               =mooDimDesc("CUSTOMER", "ACCOUNT_BAVARIAN IND", 1)



Example Output


               Bavarian Industries




Example 3


               =mooDimDesc("CUSTOMER", "ACCOUNT_BAVARIAN IND", 2)



Example Output


               ACCOUNT_BAVARIAN IND Bavarian Industries