mooSetDecimals(“ [integer value] “)        


Sets the Oracle OLAP DECIMALS option.

       

Syntax


               mooSetDecimals("[integer value]")


               Where the [integer value] represents the number of decimals places required


Return Value


               BOOLEAN

Example


Public Sub mooSetDecimals()


'Sets the Decimals Option in Oracle OLAP


Dim boo As Boolean


If Not oregistered Then:   boo = regQ:


'Check Im connected if not connect

If Not   o.connected Then

   boo = o.connect

   boo = o.connected

   Else

   boo = True

End If


'Connected so execute

If boo = True Then

    boo = o.mooSetDecimals("0")

    boo = o.wrap_runNonQ("show DECIMALS"): Debug.Print (o.mooGetDML)

    Else

   'Something went wrong print any error information

   Debug.Print "Unable to Connect"

   Debug.Print o.getlastmooerr

End If


End Sub


Return Value Example


0