mooExecute(“ [OLAP DML] “)


An API that allows a client developer to execute Oracle OLAP DML statements directly within the Oracle OLAP environment and return any output from the Oracle OLAP engine


Syntax

       

               mooexecute(“ [OLAP DML] “)


Return Value


               STRING


Example


Sub mexecute()

'Example of MOOEXECUTE


On Error GoTo ErrorH


  Set moo = Application.COMAddIns.Item("myObjectiveOLAPXL.AddinModule").Object


  Debug.Print moo.mooexecute("shw tod")

 

  Exit Sub


ErrorH:


Debug.Print Error(Err)


End Sub